👨‍🏫 Instructor-Led Training

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

Course Code: DP-605
Duration: 1 Day
Level: Foundational
Category: Database Administration

Course Overview

Transform raw data into compelling insights by mastering data preparation and visualization using Microsoft Power BI. This instructor-led course empowers data professionals and business analysts to connect, clean, and model data efficiently, then create interactive reports and dashboards that drive informed decision-making.

Explore the full Power BI workflow—from importing and shaping data with Power Query to building dynamic visualizations and publishing reports for organizational collaboration. Learn best practices for optimizing data models, enhancing performance, and using Power BI’s advanced features to deliver impactful analytics solutions.

This course includes 40% to 50% hands-on activities, providing practical experience in preparing and visualizing data with Microsoft Power BI.


Target Audience:

This course is designed for:

  • Data analysts, business analysts, and data professionals looking to develop Power BI skills

  • IT professionals and report developers responsible for delivering self-service BI solutions

  • Individuals preparing for Microsoft certifications related to Power BI and data analytics

  • Anyone interested in mastering data transformation and visualization with Power BI

Prerequisites:
Basic understanding of data concepts and familiarity with Excel or other BI tools is helpful but not mandatory.


Course Outline:

Module 1: Introduction to Power BI and Data Preparation

  • Overview of Power BI components and ecosystem

  • Connect to various data sources including Excel, databases, and cloud services

  • Use Power Query Editor to clean, transform, and shape data for analysis

Module 2: Data Modeling Fundamentals in Power BI

  • Design effective data models using relationships, calculated columns, and measures

  • Explore DAX (Data Analysis Expressions) basics for powerful calculations

  • Optimize data models for performance and usability

Module 3: Creating Interactive Reports and Visualizations

  • Build and customize interactive charts, graphs, and maps

  • Use slicers, filters, and bookmarks to enhance report interactivity

  • Apply best practices in visual design and storytelling with data

Module 4: Advanced Analytics Features in Power BI

  • Implement time intelligence and advanced DAX functions

  • Use Q&A natural language queries to explore data

  • Incorporate AI visuals such as key influencers and decomposition trees

Module 5: Sharing and Collaborating with Power BI

  • Publish reports to Power BI Service and create dashboards

  • Configure data refresh and manage data gateways

  • Collaborate using workspaces, apps, and sharing features

Module 6: Power BI Governance and Best Practices

  • Understand security and access controls in Power BI environments

  • Monitor report usage and performance

  • Apply governance strategies for scalable Power BI adoption


Delivery Format:

  • Instructor-led training with expert demonstrations

  • 40% to 50% hands-on exercises using Microsoft Power BI environment

  • Real-world scenarios to build practical skills in data preparation and visualization

Ready to Get Started?

Join thousands of professionals who have advanced their careers with our training programs.

Join Scheduled Training

Find upcoming sessions for this course and register for instructor-led training with other professionals.

View Schedule

Custom Training Solution

Need training for your team? We'll create a customized program that fits your organization's specific needs.

Get Custom Quote