Course wrap-up

Time Series Analysis in Power BI

Kevin Barlow

Data Analytics Professional

Time series data fundamentals

Different kinds of data variation

  1. Seasonal
  2. Cyclical
  3. Secular
  4. Irregular

Time Series Data Variation

Manipulating time series data

Time series data formats:

  1. ISO 8601 standards
  2. UNIX

Power BI functions:

  1. DATEADD()
  2. DATEDIFF()
  3. FORMAT()
Time Series Analysis in Power BI

Window functions

Expanding window functions

Analysis relative to a single anchor point in time

Expanding Window Functions

Rolling Window Functions

Rolling window functions

Consistent span of time, changes with new data

Time Series Analysis in Power BI

Forecasting time series

Forecasting and hindcasting take historical data and project into future dates with a given confidence interval.

Confidence Intervals GIF

Forecasting with Geometric Mean

There are several techniques to forecast data, including using averages and geometric means.

Time Series Analysis in Power BI

Congratulations!

Time Series Analysis in Power BI

Preparing Video For Download...