Time series run chart

Trend Analysis in Power BI

Jacob H. Marquez

Data Scientist at Microsoft

Visualizing a time series

A column or bar graph displaying the stock prices for the New Germany Fund from June 2014 to May 2018.

Trend Analysis in Power BI

Visualizing a time series

A column or bar graph displaying the stock prices for the New Germany Fund from June 2014 to May 2018.

Trend Analysis in Power BI

Visualizing a time series

A column or bar graph displaying the stock prices for the New Germany Fund from June 2014 to May 2018.

Trend Analysis in Power BI

What is a run chart?

A run, or line, chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018.

Trend Analysis in Power BI

Patterns in a time series

Cyclical

A time series line chart showing a pattern of rise and falls within the data.

  • Rise and fall patterns
  • No fixed time period
  • Pattern typically longer than a year in length
  • Less predictable
Trend Analysis in Power BI

Patterns in a time series

Cyclical

A time series line chart showing a pattern of rise and falls within the data.

  • Rise and fall patterns
  • No fixed time period
  • Pattern typically longer than a year in length
  • Less predictable

Seasonality

A time series line chart showing a pattern of rise and falls within the data but during certain periods of the year.

  • Pattern is influenced by the season (ex. holiday spending)
  • Fixed time periods
  • Pattern typically occurs over less than a year
Trend Analysis in Power BI

Evaluating the trend in the time series

A run, or line, chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the linear trend between the first and last date.

Trend Analysis in Power BI

Trends with rolling averages

A run, or line, chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the 7-day rolling average trend.

Trend Analysis in Power BI

Smoothing with rolling averages

A run, or line, chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the 7-day rolling average trend.

Trend Analysis in Power BI

Smoothing with rolling averages

A run, or line, chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the 14-day rolling average trend.

Trend Analysis in Power BI

Smoothing with rolling averages

A run, or line, chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the 28-day rolling average trend.

Trend Analysis in Power BI

Anomalies in a time series

A line chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the 28-day rolling average trend. A dark grey circle is highlighting a possible anomaly.

Trend Analysis in Power BI

Anomalies in a time series

A line chart displaying the stock prices for the New Germany Fund from January 2018 to May 2018. There is a dark blue line showing the 28-day rolling average trend. A dark grey circle is highlighting a possible anomaly.

Trend Analysis in Power BI

Let's practice!

Trend Analysis in Power BI

Preparing Video For Download...