Build the dashboards companies ask for: Power Query, star-schema data models, DAX measures and time intelligence, report design, row-level security and publishing to the Power BI Service.
Course Curriculum
| 1. Getting Data | |||
| 1.1 Power BI Desktop tour | 00:09:00 | ||
| 1.2 Connecting to Excel, SQL and web sources | 00:10:00 | ||
| 1.3 Power Query transformations | 00:15:00 | ||
| 2. Data Modeling | |||
| 2.1 Fact and dimension tables, star schema | 00:14:00 | ||
| 2.2 Relationships and cardinality | 00:10:00 | ||
| 2.3 Date table | 00:08:00 | ||
| 3. DAX | |||
| 3.1 Calculated columns vs measures | 00:10:00 | ||
| 3.2 CALCULATE and filter context | 00:15:00 | ||
| 3.3 Iterators: SUMX, AVERAGEX | 00:10:00 | ||
| 3.4 Time intelligence: YTD, MTD, YoY | 00:14:00 | ||
| 3.5 Variables and DAX best practices | 00:09:00 | ||
| 4. Visualization | |||
| 4.1 Choosing visuals and report layout | 00:10:00 | ||
| 4.2 Drill-through, tooltips and bookmarks | 00:12:00 | ||
| 4.3 Dashboard design principles | 00:10:00 | ||
| 5. Sharing | |||
| 5.1 Publishing to Power BI Service and workspaces | 00:09:00 | ||
| 5.2 Scheduled refresh and gateways | 00:09:00 | ||
| 5.3 Row-level security | 00:09:00 | ||
| 5.4 Final project: executive dashboard for a multi-branch company | 00:30:00 | ||
Course Reviews
No Reviews found for this course.






Up Academy Data & AI Team