Prepare and visualize data with Microsoft Power BI (DP-605T00)
Learn to prepare, model, and visualize data in Microsoft Power BI, build interactive reports, use Copilot, and explore end-to-end Microsoft Fabric analytics.
Register or Request Training
- Private class for your team
- Live expert instructor
- Online or on‑location
- Customizable agenda
- Proposal responses same day as request
Course Overview
This introductory course teaches professionals how to prepare, model, and visualize data with Microsoft Power BI. Learn to connect to data, perform basic preparation with Power Query, configure semantic models, and design interactive reports that support informed decision-making.
The course also introduces Copilot-assisted report development in Power BI and end-to-end analytics with Microsoft Fabric. No prior Power BI experience is required.
Course Benefits
- Navigate Power BI and identify its core building blocks.
- Connect to file-based, relational, NoSQL, online, and Azure Analysis Services data sources.
- Clean, transform, combine, and profile data with Power Query.
- Configure relationships, tables, columns, hierarchies, measures, and parameters in a semantic model.
- Design effective report layouts and select appropriate visuals, filters, and slicers.
- Use Copilot in Power BI to assist with data preparation, modeling, and report creation.
- Describe end-to-end analytics capabilities in Microsoft Fabric.
Delivery Methods
Live expert-led online training from anywhere. Guaranteed to run .
Delivered for your team at your site or online.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- Get started building with Power BI
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
- Get data in Power BI
- 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
- Clean, transform, and load data in Power BI
- Shape the initial data
- Simplify the data structure
- Evaluate and change column data types
- Combine multiple tables into a single table
- Profile data in Power BI
- Use Advanced Editor to modify M code
- Configure a semantic model
- Configure relationships
- Configure tables
- Configure columns
- Configure hierarchies
- Configure measures
- Configure parameters
- Design Power BI reports
- 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
- Get started with Copilot in Power BI
- Use Copilot in Power BI to prepare and model data
- Create reports with Copilot in Power BI
- Get your data ready for AI usage in Power BI
- Module assessment
- Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
Class Materials
Each student receives a comprehensive set of materials, including course notes and all class examples.
Class Prerequisites
Experience in the following would be useful for this Microsoft Power Platform class:
A basic understanding of data analytics is useful. No prior experience with Power BI is required.
Have questions about this course?
We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.