DP-605T00: Prepare and visualize data with Microsoft Power BI Training

DP-605 trains you to turn raw data into clear, useful reports using Microsoft Power BI. You'll learn to connect data sources, clean and model data, design semantic models, and build dynamic reports. The course is instructor led with hands on labs, and it's built for data and BI professionals who need to produce reliable reports for their teams.

📘 Power BI 👥 142 Enrolled ⏱️ 1 Day 💼 Foundation Level ⭐ 5 | 26 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$599

Course Overview

This course covers data preparation, transformation, and visualization in Power BI. You'll connect to data sources, use Power Query for transformation, design semantic models, write DAX measures, and build interactive reports. It also covers Copilot for Power BI and Microsoft Fabric integration. By the end, you'll be able to deliver consistent, high quality analytics across business functions.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

What you will learn

Data Source Identification and Connection
Optimizing Data Retrieval
Data Cleaning and Transformation
Advanced Data Handling
Semantic Model Design in Power BI
Implementing Measures in Power BI Models
Creating Calculated Tables and Columns
Power BI Report Design
Configuring Power BI Report Filters
Managing Workspaces and Semantic Models in Power BI

Who Should Attend This Course?

Data Analyst

Prerequisites

Before starting this learning path, you should be familiar with data and analytics concepts.

📞 Talk to a Learning Advisor

📘 DP-605T00: Prepare and visualize data with Microsoft Power BI Outline

Get started building with Power BI

How Power BI services and applications work together.
Explore how Power BI can make your business more efficient.
How to create compelling visuals and reports.

Get data in Power BI

Identify and connect to a data source
Get data from a relational database, like Microsoft SQL Server
Get data from a file, like Microsoft Excel
Get data from applications
Get data from Azure Analysis Services
Select a storage mode
Fix performance issues
Resolve data import errors

Clean, transform, and load data in Power BI

Resolve inconsistencies, unexpected or null values, and data quality issues.
Apply user-friendly value replacements.
Profile data so you can 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.

Configure a semantic model

Set modeling options.
Create and configure relationships.
Configure table and column properties.
Create hierarchies.
Create quick measures.
Create numeric range and field parameters.

Design Power BI reports

Report structure.
Report objects.
Different visualization types.

Get started with Copilot in Power BI

Use Copilot in Power BI during report development.
Prepare semantic models for use with AI.
Interact with data using natural language in Copilot Chat.

Introduction to end-to-end analytics using Microsoft Fabric

Identify the capabilities of Microsoft Fabric.
Implement Microsoft Fabric to meet your enterprise's analytics needs.

Still have questions?

Reach out to our learning advisors for personalized guidance on choosing the right course, group training, or enterprise packages.

📞 Talk to an Advisor

What You Get with Microtek Learning

Instructor-Led Excellence

✓ Certified Instructor-led Training
✓ Top Industry Trainers
✓ Official Student Handbooks

Measurable Learning Outcomes

✓ Pre- & Post-Training Assessments
✓ Practice Tests
✓ Exam-Oriented Curriculum

Real-World Skill Building

✓ Hands-on Activities & Scenarios
✓ Interactive Online Courses
✓ Peer Collaboration (Not in self-paced)

Full Support & Perks

✓ Exam Scheduling Support ^*
✓ Learn & Earn Program ^*
✓ Support from Certified Experts
✓ Gov. & Private Pricing ^*

Our Clients

For over 10 years, Microtek Learning has helped organizations, leaders, students and professionals to reach their maximum potential. We have led the path by addressing their challenges and advancing their performances.