Course Outline
January 3, 2020
|By Parker Stevens
Back to: Power BI – Intermediate
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
-
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