Learn the fundamentals of data analytics, including descriptive and inferential statistics, and how different industries and organizations use data for forecasting and decision-making. Explore statistical analysis and modeling, including statistical algorithms, theorems, and models.
Overview
Syllabus
Basic Data Analysis
- Measures of Central Tendency
- Measures of Position
- Measures of Dispersion
- The Normal Curve
- Descriptive Statistics
Predictive Analytics I
- Forecasting
- Series Forecast
Data Visualization I
- Charts
- Icon Sets
- Histograms
- Moving Average
Predictive Analytics
- Correlation
- Regression - overview
- Regression - analysis
- Linear regression
- Multiple regression
Probability
- Probability I
- Probability II
- Binomial Probability
- Poisson Probability
Prescriptive Analytics I
- What If Analysis
- Data Table (3 variables)
- Scenario Manager
- Scenario Manager - Pivot
Data Visualization II
- Sparklines
- Color Scales
- Drawing Shapes
- Pivot Tables
- Pivot Charts
Prescriptive Analytics II
- Solver - overview
- Linear Programming
- The Solver model
- Non-Linear Programming
- Evolutionary Solver
