DP-605: Prepare and visualize data with Microsoft Power BI
Overview
Learn how to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.
Who should attend
This course is for Data Analysts.
Prerequisites
Basic understanding of Data Analytics and Power BI.
What you'll learn
After completing this course, students will be able to:
- Build with Power BI
- Get data in Power BI
- Cleanse, transform, and load data in Power BI
- Design a semantic model in Power BI
- Design Power BI reports
- Create interactive reports using Copilot for Power BI
- Discover end-to-end analytics using Microsoft Fabric.
Course content
Build with Power BI
- Understand how Power BI apps and services work together.
- Explore how Power BI can make your business more efficient.
- Create engaging visuals and reports.
Get data in Power BI
- Log in and connect to a data source.
- Get data from a relational database, such as Microsoft SQL Server.
- Get data from a file, such as Microsoft Excel.
- Get app data.
- Get data from Azure Analysis Services.
- Select a storage mode.
- Troubleshoot performance issues.
- Fix data import errors.
Cleanse, transform, and load data in Power BI
- Resolve inconsistencies, unexpected or null values, and data quality issues.
- Apply user-friendly value overrides.
- Profile data to learn more about a specific column before using it.
- Evaluate and transform column data types.
- Apply data shape transformations to table structures.
- Combine queries.
- Apply user-friendly naming conventions to columns and queries.
- Edit M code in the Advanced Editor.
Design a semantic model in Power BI
- Create common date tables.
- Set up many-to-many relationships.
- Resolve circular relationships.
- Design star schematics.
Design Power BI reports
- Learn about the structure of a Power BI report.
- Learn about report objects.
- Select the appropriate type of visual to use.
Create interactive reports using Copilot for Power BI
- Design a semantic model.
- Create visuals and reports.
- Create summaries.
Describe end-to-end analytics in Microsoft Fabric.
Common questions
When does DP-605: Prepare and visualize data with Microsoft Power BI next run?
The next date is Mon, 7 Sept 2026, and there are 10 further dates scheduled. Delivered ACE Training Christchurch, ACE Training Wellington, ACE Training Hamilton, ACE Training Auckland. Every date and its format is listed on this page.
How much does DP-605: Prepare and visualize data with Microsoft Power BI cost?
From $950 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
Basic understanding of Data Analytics and Power BI.
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code DP605 when you enquire.