MS Excel — Use #PowerQuery to add a Dynamic Date Dimension table (Query) to your data sources
Part 2 — Building Basic Data Analysis with Excel Power Tools
Overview
Continuing from Part 1 — “Use #PowerQuery to IMPORT .csv formatted data from the web”
Once I have extracted data (a list of failed banking institutions), it needs to be transformed in order to simplify analysis.
In this case, a table of date dimensions would prove very useful. I have a closing date for every record.
A date dimension table that would associate Year, Quarter, Month, Week of Year and Day of Week greatly simplifies slicing and analyzing the data for different views. 💯💪
I highlight one of the methods I use to create the date dimension table in video below.
I now have a data table and a closing date dimension table (sitting in the Data Model in #excel).
In the next video, I will connect (“join”) these two tables and generate a quick analysis…stay tuned!