Power BI Mastery

Create stunning dashboards and data visualizations.

Comes after: Excel for Data Analysis

1. What Is Power BI?The parts of Power BI, its building blocks, and the path from raw data to a shared dashboard.
2. Getting and Transforming Data with Power QueryConnect Power BI Desktop to your data and shape it with repeatable steps before it reaches the model.
3. Data Modeling and the Star SchemaOrganise tables into facts and dimensions joined by relationships, the foundation of every reliable Power BI report.
4. DAX Basics: Measures and Calculated ColumnsWrite your first DAX formulas and learn when to use a measure and when to use a calculated column.
5. CALCULATE and Filter ContextUnderstand the idea behind every DAX result, then change it on purpose with CALCULATE, ALL and iterators.
6. Time Intelligence in DAXCalculate year-to-date totals, compare with last year and build rolling averages using a proper date table.
7. Visualizations and Report DesignPick the right visual for each question and lay out a report page that people can read in seconds.
8. Interactive Reports: Slicers, Drill-Through and BookmarksLet readers explore: filter with slicers, drill from summary to detail and switch views with bookmarks.
9. Publishing, Sharing and SecurityPublish reports to the Power BI service, keep data refreshed and control who sees what with row-level security.
10. Project: Build a Sales Report in Power BITake one dataset from raw files to a published, interactive, secured report, using every skill in this course.