Power BI: Data Transformation & Modeling

Audience Profile

This course is geared for data analysts, business intelligence professionals, and power users who are already familiar with Power BI basics but want to sharpen their skills and become more effective in their roles. Whether you're designing dashboards, creating data models, or improving reporting accuracy, this class provides the tools you need to succeed.

Suggested Learning Paths:

Business User/Report Developer

TTDPB01: Power BI: Essentials (2 days). Foundation for all learners.
TTDPB04: Power BI: Creating Reports (1 day). Learn to design and build insightful reports.
(Optional) TTDPB03: Power BI: Data Transformation & Modeling (2 days). If you need to clean and prepare data before reporting.

For Data Analysts & Power Users (Focus: Data Preparation, Analysis, and Advanced Calculations)

TTDPB01: Power BI: Essentials (2 days). Foundation for all learners.
TTDPB03: Power BI: Data Transformation & Modeling (2 days). Learn Power Query and data modeling best practices.
TTDPB05: Power BI: Mastering DAX for Data Analysis (1 day). Essential for writing complex calculations and optimizing analysis.
(Optional) TTDPB04: Power BI: Creating Reports (1 day). If they also need to design and present reports.

For Data Engineers (Focus: Data Preparation & Optimization)

TTDPB01: Power BI: Essentials (2 days). Foundation for all learners.
TTDPB03: Power BI: Data Transformation & Modeling (2 days). Core course for data cleaning and model structuring.
(Optional) TTDPB05: Power BI: Mastering DAX for Data Analysis (1 day). If you need to optimize performance with calculated measures.

At Course Completion

This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll learn how to:

Identify and retrieve data from various data sources and understand the different connection methods.
Connect and change connections to a variety of data sources
Identify problems with data quality and errors and address them
Leverage Applied Steps and the Advanced Editor
Manipulate queries to create additional queries or modify existing queries
Future proof queries
Create parameters and functions
Set up for incremental refresh
Create a star schema that meets best practice standards
Write DAX measures with a variety of DAX functions, including CALCULATE
Use variables and nested expressions to streamline DAX measures
Activate inactive relationships
Avoid many-to-many relationships
Set up incremental refresh in the model
Measure the performance of a report page
Use the DAX query view to view and improve the performance of DAX expressions
Create security roles and assign row level security through the role

If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals.

Prerequisites

To ensure a smooth learning experience and to gain the most from attending this course, you should have:

-Basic familiarity with Power BI tools and interface.
-A working knowledge of importing and visualizing data.
-General understanding of database concepts and relationships.

Take Before: In order to gain the most from this course, you should have incoming skills equivalent to those in the course listed below, or should have attended this as a prerequisite:

-TTDPB01
-Power BI Essentials