Starting to explore time series data

Trend Analysis in Power BI

Jacob H. Marquez

Data Scientist at Microsoft

What is a "time series"?

Definition:

A series of data points graphed in chronological order.
Most commonly, it is a sequence taken at successive equally spaced points in time.

¹ https://en.wikipedia.org/wiki/Time_series

Use Cases:

Examples:

An image showing the date 2019-03-25 08:30 being decomposed into it's year, month, and day parts.

An image showing the date 2019-03-25 08:30:00 being decomposed into it's hour, minute, and seconds parts.

An image showing the date 2019-03-25 08:30:00 being mutated into day of year, week of year, and day of week parts.

The subscription_start_date variable being compared to the current date to derived the subscription age and age_group.

Period-over-period change

The calculation for period-over-period change.

Period-over-period change

The calculation for period-over-period change.

DATE(): constructs a date value from parts (e.g. year, month, and day)

LEFT(): extracts a given number of characters from a set of characters, starting from the left side.

RIGHT(): extracts a given number of characters from a set of characters, starting from the right side.

MID(): extracts a given number of characters from a set of characters, starting from a defined place in the set.

WEEKDAY(): returns the day of the week as a number; default is to use the number 1 for Sunday.

Trend Analysis in Power BI