Completed
12. Excel Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Visualizing Data and Building Dashboards in Excel & Power BI
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics
- 3 3. Why Visualize? Table or Visualization?
- 4 4. Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule”
- 5 5. Tables Formatting Rules
- 6 6. Conditional Formatting
- 7 7. Column and Bar Charts to compare differences across categories
- 8 8. Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar
- 9 9. Line Chart: 3 examples
- 10 10. Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company.
- 11 11. X-Y Scatter Chart: Relationship Between Two Numbers
- 12 12. Excel Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing.
- 13 13. PivotTable Custom Style
- 14 14. Power BI Comprehensive Dashboard example with Power Query, Data Modeling, Time Dimension Table, DAX Formulas and Publishing and Sharing Online.
- 15 15. Power Query to take data from multiple worksheets in multiple Excel files and transform it into a single table. Learn how to use Excel.CurrentWorkbook function, The Merge feature to lookup price…
- 16 16. Array Formula Dashboard Tips: Conditional Formatting and Dynamic Charts
- 17 17. PivotTable Dashboard Tips: PivotTable to create Dynamic Dashboard Title
- 18 18. Import Excel Power Query query into Power BI Desktop
- 19 19. Power BI Desktop Dashboard Tips: Formatting Date Slicer, Invert Picture, Conditional Formatting
- 20 20. Add New File To Folder and Update Three Dashboards: Array Formula, PivotTable and Power BI
- 21 21. Summary and Conclusions
- 22 22. Closing and Video Links
