“Finally, a Power BI book that acknowledges that the real work is in data preparation and modeling—not just dragging fields onto a canvas. The DAX section alone is worth the price.” — Mark Simonson, Senior BI Consultant
The 2020 edition places a heavy emphasis on the Power Query Editor. This is where the magic happens before any visuals appear on the screen. Students learn to connect to various data sources, including Excel files, SQL databases, and web scraping. The course focuses on cleaning messy data by removing duplicates, pivoting columns, and changing data types to ensure the final report is accurate and performant. Mastering Data Modeling and DAX “Finally, a Power BI book that acknowledges that
This course serves as a comprehensive entry point into Microsoft Power BI, a leading business intelligence tool used for data visualization and reporting. The 2020 Edition was specifically designed to update previous versions to match the significant User Interface (UI) overhaul Microsoft rolled out that year. The course takes a "zero-to-hero" approach, guiding students from connecting to data sources to publishing complex, interactive dashboards to the Power BI Service. Students learn to connect to various data sources,
A highlight of this introduction is the deep dive into data modeling. Creating relationships between tables is a critical skill that separates amateurs from pros. The 2020 curriculum explains the "Star Schema" and how to manage one-to-many relationships effectively. Furthermore, it introduces Data Analysis Expressions (DAX). By learning to write measures and calculated columns, users gain the power to perform complex calculations like year-over-year growth or rolling averages. Visualizing Insights with Impact The 2020 Edition was specifically designed to update