- Data Management and Integration
- Data Transformation and Cleaning
- Advanced Power Query techniques
- Handling missing and erroneous data
- Data shaping and restructuring
3. Data Integration
- Connecting to multiple data sources (SQL, Azure, APIs)
- Merging and appending queries
- Managing data refresh schedules
4. DAX Functions
- Understanding context in DAX
- Time intelligence functions
- Advanced calculations (CALCULATE, FILTER, ALL, ALL EXCEPT)
5. Data Modelling
- Creating and managing complex relationships
- Using calculated tables and columns
- Optimizing data models for performance
6. Data Visualization and Reporting
7. Advanced Visualizations
- Custom visuals and marketplace
- Visualization best practices for clarity and impact
- Interactive elements (drill-through, bookmarks, and buttons)
8. Analytics in Power BI
- Integrating R and Python visuals
- Statistical analysis and forecasting
- Using AI visuals (Key Influencers, Decomposition Tree)
9. Designing Interactive Dashboards
- Dashboard layout and design principles
- Using themes and templates
- Enhancing user experience with navigation features
10. Report Optimization and Performance Tuning
- Performance analysis tools in Power BI
- Best practices for optimizing report performance
- Managing large datasets
11. Collaboration and Deployment
- Publishing and sharing reports and dashboards
- Managing workspaces and apps
- Using Power BI mobile