Completed
2. 00:26 Power BI Desktop and Power Query to import 7 million rows of SQL Database sales data and build Interactive Gross Profit Dashboard.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas - MS 365 Excel Basics #13
Automatically move to the next video in the Classroom when playback concludes
- 1 1. 00:00 Introduction
- 2 2. 00:26 Power BI Desktop and Power Query to import 7 million rows of SQL Database sales data and build Interactive Gross Profit Dashboard.
- 3 3. 02:46 What is a Columnar Database?
- 4 4. 04:18 Idea behind DAX Revenue Formula Measure
- 5 5. 05:56 Log in to SQL Database, Import 7 million rows of data with Power Query in Power BI Desktop
- 6 6. 10:41 Build DAX Date Table
- 7 7. 15:37 Row Context in DAX Calculated Columns and DAX Iterator Functions
- 8 8. 20:50 Hide Fields in Report View
- 9 9. 22:15 Two-Step DAX Revenue Measure using ROUND and RELATE#D DAX functions
- 10 10. 29:24 One-Step DAX Revenue Measure using SUMX DAX function
- 11 11. 31:28 Compare One-Step and Two-Step Measures. Which is better?
- 12 12. 34:33 Create four Remaining Measures in Report View
- 13 13. 37:24 What is Gross Profit? Two Measures for Gross Profit.
- 14 14. 42:00 Create Two Power BI Reports, including Map Report
- 15 15. 44:30 Map Visual
- 16 16. 46:00 Conclusion
- 17 17. 46:25 Closing and Video Links
