Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm
Learn about:
1) (00:04) Notes about downloading files
2) (00:36) Look at Finished Grade Dashboard
3) (01:10) Look at Text files that we need to import from a folder
4) (02:07) Power Query to Import Text Files (extension “.txt”) from a Folder
5) (06:14) What is a Dashboard?
6) (08:02) Build PivotTable for Class Mean and Standard Deviation
7) (09:52) Build Column Chart from Categorical data (Class Name)
8) (10:43) Add Slicer to PivotTable for Academic Year
9) (11:07) What a Slicer does.
10) (11:18) Create Dynamic Chart Title for Chart that changes when Slicer Changes.
11) (12:37) Build PivotTable for Grade Frequency Distribution based on the filter of Class Name
12) (13:46) Create Dynamic Chart Title for Chart that changes when Filter AND Slicer Changes.
13) (14:03) Build Histogram For Grade Distribution
14) (15:56) Connect Second PivotTable and Histogram to Slicer for First PivotTable
15) (16:31) Video is Paused and third PivotTable and Histogram is created.
16) (16:35) Finishing Touches on Dashboard. Sizing Charts and arranging Slicers. Learn about Alt keyboard to line charts up against cells.
17) (18:58) Drop new Text Files in original folder and see that the entire: 1) Power Query Import and Data Transformation, 2) PivotTables and 3) Charts in our Dashboards updates when we refresh with the keyboard Ctrl + Alt + F5.
18) (21:14) Summary and Conclusion
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.