Who is this training for?
Mid-level data analysts
Training objectives
- Get data in Power BI
- Clean, transform, and load data in Power BI
- Design a semantic model in Power BI
- Add metrics and calculations to Power BI Desktop models
- Design Power BI reports and configure filters
- Create and manage workspaces and semantic models in Power BI
Summary
Transform and load data, define relationships and semantic model calculations, create interactive visuals, and distribute reports using Power BI.
Course outline
- Get data in Power BI
- Clean, transform, and load data in Power BI
- Design a semantic model in Power BI
- Add measures to Power BI Desktop models
- Add tables and calculated columns to Power BI Desktop models
- Design Power BI reports
- Configure Power BI report filters
- Create and manage workspaces in Power BI
- Manage semantic models in Power BI
Approach and methodology
Practical and structured approach combining focused theory and guided workshops. Participants gradually prepare and visualize data with Microsoft Power BI through real-world exercises inspired by professional scenarios, promoting immediate application of learning. They learn how to clean and transform data, create relevant visualizations, and produce interactive reports to aid in analysis and decision-making. Led by a Microsoft certified trainer, the training focuses on interactivity and the development of directly transferable skills to effectively exploit data in a professional context.
Prerequisites
- Basic knowledge of data concepts
- Familiarity with: Microsoft Excel or similar tool
- An understanding of: tables, columns, relationships
- Minimal experience in: data manipulation or analysis (asset)
Recommendations
Take the Getting Started with Microsoft Data Analytics or equivalent course
