Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas - MS 365 Excel Basics #13

This 47-minute tutorial demonstrates how to build a Power BI dashboard using 7 million rows of SQL data and DAX formulas. Learn the fundamentals of columnar databases and follow a step-by-step process to import large SQL datasets using Power Query in Power BI Desktop. Master essential DAX concepts including creating a date table, understanding row context in calculated columns, and implementing both one-step and two-step revenue measures using functions like ROUND, RELATED, and SUMX. Discover how to properly hide fields in Report View, create multiple measures including gross profit calculations, and design interactive reports with map visualizations. Downloadable practice files are available to follow along with the hands-on demonstration. The tutorial includes subtitles in multiple languages and translated audio tracks for accessibility.

Syllabus

1. 00:00 Introduction
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. 02:46 What is a Columnar Database?
4. 04:18 Idea behind DAX Revenue Formula Measure
5. 05:56 Log in to SQL Database, Import 7 million rows of data with Power Query in Power BI Desktop
6. 10:41 Build DAX Date Table
7. 15:37 Row Context in DAX Calculated Columns and DAX Iterator Functions
8. 20:50 Hide Fields in Report View
9. 22:15 Two-Step DAX Revenue Measure using ROUND and RELATE#D DAX functions
10. 29:24 One-Step DAX Revenue Measure using SUMX DAX function
11. 31:28 Compare One-Step and Two-Step Measures. Which is better?
12. 34:33 Create four Remaining Measures in Report View
13. 37:24 What is Gross Profit? Two Measures for Gross Profit.
14. 42:00 Create Two Power BI Reports, including Map Report
15. 44:30 Map Visual
16. 46:00 Conclusion
17. 46:25 Closing and Video Links