Overview
Develop dynamic reports with Microsoft Power BI
Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
Why Choose KORNERSTONE
- Accredited, practitioner-led, expert certificate trainers to provide high quality training
- Official training material included
- Practical, scenario-based learning – focus on application, not just theory
- Excellent Passing Rate
Skills Covered
- Get started building with Power BI
- Get data in Power BI
- Clean, transform, and load data in Power BI
- Configure a semantic model
- Design Power BI reports
- Get started with Copilot in Power BI
- Introduction to end-to-end analytics using Microsoft Fabric
Prerequisites
Completion of the Get started with Microsoft data analytics is recommended.
Target Audience
- IT professionals
Course Curriculum
Module 1: Get started building with Power BI
Module 2: Get data in Power BI
- Introduction
- Get data from files
- Get data from relational data sources
- Create dynamic reports with parameters
- Get data from a NoSQL database
- Get data from online services
- Select a storage mode
- Get data from Azure Analysis Services
- Fix performance issues
- Resolve data import errors
- Exercise – Get data in Power BI
- Check your knowledge
- Summary
Module 3: Clean, transform, and load data in Power BI
- Introduction
- Shape the initial data
- Simplify the data structure
- Evaluate and change column data types
- Combine multiple tables into one table
- Profile data in Power BI
- Use Advanced Editor to modify M code
- Exercise – Load data in Power BI Desktop
- Check your knowledge
- Summary
Module 4: Configure a semantic model
- Introduction
- Configure relationships
- Configure tables
- Configure columns
- Configure hierarchies
- Configure measures
- Configure parameters
- Exercise – Configure a semantic model in Power BI Desktop
- Check your knowledge
- Summary
Module 5: Design Power BI reports
- Introduction
- Design the analytical report layout
- Design visually appealing reports
- Use report objects
- Select report visuals
- Apply filters and slicers to reports
- Understand filtering techniques and considerations
- Case study – Configure report filters based on feedback
- Exercise – Design Power BI reports
- Check your knowledge
- Summary
Module 6: Get started with Copilot in Power BI
Module 7: Introduction to end-to-end analytics using Microsoft Fabric
- Introduction
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
- Summary
Dates & Locations
October 22, 2026
Exam & Certification
Note: There is no exam directly associated with this course. However, Microsoft offers an extensive portfolio of industry-recognized certifications that can help you stand out as a tech professional in 2025 and beyond. Achieving Microsoft certification is one of the most effective ways to validate your skills and accelerate your career.
With our expert-led training, you’ll be prepared to:
- Master in-demand capabilities across Cloud, Data & AI, and Cybersecurity — areas driving global digital transformation.
- Prove your expertise with a globally respected credential recognized by employers worldwide.
- Advance your career by enhancing your credibility, increasing your earning potential, and opening doors to new opportunities.
Explore our full range of Microsoft certifications and start building the skills that matter today.
