Creating a Dashboard in Excel Using Power Query and Multiple Data Files
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Ygs4brQEHhs
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.
#############################
![](http://youtor.org/essay_main.png)