Summary
Keywords
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.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.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
