1 – Power Query
- Merge vs Append
- Group By
- Parameters in Power Query
- Column from examples and advanced conditional logic
2 – Modeling and Professional Organization
- The Star Schema Model (Facts and Dimensions)
- Calendar Table (Date table)
- Description, formatting, and data types
- Organization (Folders)
3 – DAX
- Review of concepts
- Variables
- Evaluation context
- CALCULATE Function
- Time-Intelligence functions
4 – Advanced Visualization and Storytelling
- Conditional Formatting (Icons, Bars, Rules)
- Parameters
- Bookmarks
- Custom Tooltips
- Drill-Through and navigation buttons
- Custom themes and standardization
- Visual Calculation
5 – Service Distribution
- Team Workspaces
- Scheduled refreshes
- Dashboards vs Reports
- Roles