Power BI: Data Transformation & Modeling

Enhance your Power BI expertise with our Data Transformation & Modeling course, tailored for data analysts and business intelligence professionals aiming to optimize data quality and build high-performing semantic models.

Course Thumbnail

Essential Skills Gained

Checkmark

Optimize data quality and address errors

Checkmark

Implement and maintain star schemas

Checkmark

Write advanced DAX functions for dynamic reporting

Checkmark

Enhance data security with row-level security techniques

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

  • Data Analysts
  • Business Intelligence Professionals
  • Power Users
  • Report Developers

Description

Take your Power BI skills to the next level with Power BI: Data Transformation and Modeling, an engaging, hands-on course designed for professionals who already know the basics and want to refine their expertise. Throughout the course you will learn gain the tools and techniques to handle real-world challenges like optimizing data quality, creating scalable queries, and building high-performing semantic models. This course focuses on practical applications, ensuring you can confidently retrieve and connect data from various sources, address data quality issues, and manipulate queries with advanced techniques. You'll also explore best practices for creating and maintaining star schemas, writing efficient DAX measures, and implementing row-level security to enhance data governance. Through a mix of expert-led instruction and hands-on activities, you'll not only expand your technical skills but also learn strategies to make your reports more reliable, insightful, and secure. Whether you're fine-tuning relationships, improving report performance, or setting up parameters and incremental refresh, this course equips you with techniques you can immediately apply in your role. By the end of the course, you'll be ready to build Power BI reports and models that align with best practices and deliver impactful results for your organization.

Calendar icon

Upcoming Course Dates

July 30-31, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$1695

September 17-18, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$1695

October 29-30, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$1695

Course Outline

Download PDF

Getting the Data

  1. Entering Your Credentials

  2. Change Data Source Settings

  3. Editing Permissions

  4. Writing your own SQL code

  5. Using Folders and SharePoint Folders

Data Quality and Data Typing

  1. Turning on the profiling tools

  2. Profiling on more than 1000 rows

  3. Handling errors and data types

Applied Steps

  1. Adding, deleting, rearranging steps

  2. Using The Advanced Editor

When the existing data is not enough (or too much)

  1. Replacing and adding data

  2. Adding new queries and columns

Manipulating Queries

  1. Combining queries

  2. Duplicating and referencing queries

Future Proofing Queries

  1. Resolving errors

  2. Re-using work in other queries

Parameters and Functions

  1. Creating and using parameters

  2. Explanation of the Semantic Model

Filters and Relationships

  1. Types of relationships

  2. Importance of filtering

Adding to the Semantic Model

  1. Adding content using DAX

  2. Evaluating report performance

Row-level Security

  1. Security overview

  2. Dynamic and static methods

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.