Time Series Modeling in Excel, R, and Power BI
2hAdvanced2023-03-23
Authors
Helen Wall
Data analytics and business analysis expert
Course details
The use of time series models has become a central topic in today’s data science world. In this course, instructor Helen Wall shows you how to run autoregressive integrated moving average (ARIMA) models as predictive, time series modeling tools in Excel, R, and Power BI.
Explore the building blocks of a time series decomposition, which lets you make data forecasts with accuracy, consistency, and ease. Take a deep dive into the fundamentals of autoregressive coefficients, autocorrelation, moving average coefficients, stationarity and random walks with integrated components, and how to forecast time series models using Power BI. By the end of this course, you’ll be ready to start wielding your new data analytics skills to make more timely and effective decisions for your business.
Explore the building blocks of a time series decomposition, which lets you make data forecasts with accuracy, consistency, and ease. Take a deep dive into the fundamentals of autoregressive coefficients, autocorrelation, moving average coefficients, stationarity and random walks with integrated components, and how to forecast time series models using Power BI. By the end of this course, you’ll be ready to start wielding your new data analytics skills to make more timely and effective decisions for your business.
Skills covered
RPower BIStatisticsBusiness AnalyticsMachine LearningBusiness IntelligenceSpreadsheetsMicrosoft ExcelData AnalysisArtificial Intelligence (AI)Programming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftSoftware DevelopmentDeep Dive (X:Y)
Concepts
Introduction
- Predicting the future with time series models
- What you should know
- Course project
Time Series Models
- Time series models
- Dates
- Date time index
- Time series objects
- Filtering
- Removing NAs
- Aggregating and grouping
- Time series decomposition
- Adding fitted lines
- Forecasting future trends
- Challenge - Aggregating time series data
- Solution - Aggregating time series data
Autoregression
- Linear regression best fit lines
- Residuals
- Lags
- Autoregression
- Moving average
- Challenge - Determining overall trends
- Solution - Determining overall trends
Time Trends
- Autocorrelation
- Partial autocorrelation
- Stationarity
- ARIMA modeling
- Power BI modeling
- Challenge - Forecasting next week's demand
- Solution - Forecasting next week's demand
Conclusion
- Extending your time series knowledge