Creating a Dashboard in Excel Using Power Query and Multiple Data Files

This video covers the following concepts:
a. Connecting to a folder that contains multiple datasets with the same format but different records.
b. Transforming data columns in Power Query
c Creating pivot tables
d. Creating a dashboard
Scroll down and download public use files for years 2013 to 2020 and put all the files in the same folder.