Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.

Prerequisites:

• Experience with using Excel or other spreadsheet tools
• Experience with using Power BI at a basic level
• Understanding of relational databases
• Basic skills in data visualization and analysis

• Gain proficiency in retrieving data from diverse sources.
• Learn advanced techniques for cleaning and transforming data.
• Master the art of semantic modeling for optimized report performance.
• Enhance report visualization skills for effective data communication.
• Acquire expertise in report filtering and workspace management for streamlined report distribution.

Module 1. Get data in Power BI

Module 2. Clean, transform, and load data in Power BI

Module 3. Design a semantic model in Power BI

Module 4. Add measures to Power BI Desktop models

Module 5. Add calculated tables and columns to Power BI Desktop models

Module 6. Design Power BI reports

Module 7. Configure Power BI report filters

Module 8. Create and manage workspaces in Power BI

Module 9. Manage semantic models in Power BI