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
Data Files: https://data.cms.gov/provider-summary...
Scroll down and download public use files for years 2013 to 2020 and put all the files in the same folder.