Course Outline

January 3, 2020

Level up your Power BI skills with this amazing course! These lessons will take you from an intermediate to an advanced user of Power BI. Take a look at all of the lessons on the right side of the page! Here are some of my favorite topics that we cover:

Creating a custom date table
KPIs
Drill-through
Report-page tooltips
Bookmarks
What-if Parameters
Data alerts
Live connections to Power BI datasets
And many, many more!

At the end of this course, you will be in the top tier of Power BI developers as you will understand so much of the Power BI framework. You will confidently navigate both Power BI Desktop and Power BI Service and can easily build dynamic and beautiful Power BI reports loaded with functionality!

Syllabus

Introduction
- Course Outline
- Downloadable Materials
Intermediate Data Connections
- Import vs DirectQuery
- Custom Date Table
- Duplicating vs Referencing Queries
Data Modelling
- Fact & Dimension Tables
- Bi-Directional Relationships
- Inactive Relationships (USERELATIONSHIP)
Visualizations You Should Know
- KPIs
- Bar Charts
- Combo Charts
- Tables
- Matrix
- Slicers (All Kinds)
- Custom Visuals
Expression-Based Formatting
- Icons (Traffic-Light KPI)
- Formatting By Field Value
- Conditional Titles
Key Power BI Functionalities
- Drill-Through
- Hierarchies
- Selection Pane
- Bookmarks & Buttons
- Filter Pane
- What-If Parameters
- Report Page Tooltips
Intermediate Power BI Service
- Data Alerts
- Personalized Bookmarks
- Adding Comments to a Report
- Live Connections to Power BI Datasets
Putting It All Together
- Using Your New Skills
Final Words
- Power BI Intermediate Course Feedback
- Congratulations and Next Steps