Analyzing trends by day of week

Time series analysis is conducted at various date grains - year, month, week, day. It also involves evaluating trends at different date-derived context such as day of the week.

In this exercise, you will use the WEEKDAY() function to create a new day of the week variable, then analyze trends by city with small multiples.

If you have lost any progress, close any open reports and load 1_2_weekday.pbix from the Workbooks folder on the Desktop.