Learn to harness the power of Power BI to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports seamlessly.

The ideal audience are those wanting to expand their knowledge of data modeling, visualization, and analysis with the use of Microsoft Power BI.

Audience prerequisites: Students for this course are familiar with data manipulation and may have some experience with data analysis. They are likely Microsoft Excel power users and may have used other reporting tools. They need to understand how to use desktop applications, including GUI and code, and how to navigate online platforms.

• 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