Downloadable Materials
February 24, 2020
|By Parker Stevens
Back to: Power BI – Intermediate
For each lesson of this course, you will find a .zip file containing useful files for your Power BI journey. There will be a Power BI file (.pbix) for use at the start of each lesson and a file containing the finished solution following lesson completion. These are good resources to have. You can challenge yourself by trying to use your personal Power BI file continuously throughout the course, knowing that you can always start fresh with the PBIX file from the downloadable materials!
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