The Power BI: Data Transformation & Modeling (TTDPB03) course helps you build cleaner, faster, and more reliable data models. This hands-on training is designed for users with basic Power BI knowledge who want to improve their skills in data transformation, modeling, and DAX.

Throughout the course, you will learn techniques to handle real-world challenges such as improving data quality, optimizing queries, and building high-performance data models.

We can organize this training at your preferred date and location.

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.

Who Should Attend

Data analysts
Business intelligence professionals
Users familiar with Power BI basics who want to improve their skills

What You Will Learn

By the end of the course, you will be able to:

Retrieve data from multiple data sources
Connect and modify data connections
Identify and resolve data quality issues
Use Applied Steps and Advanced Editor
Manipulate queries and create new queries
Create parameters and functions
Set up incremental refresh
Build star schema data models
Write DAX measures including CALCULATE
Analyze and improve report performance
Implement row-level security (RLS)

Training Outline

Getting the Data

Data connections
Credentials and settings
SQL queries

Data Quality

Profiling tools
Handling null values
Data types

Applied Steps

Managing transformation steps
Using Advanced Editor

Query Management

Merge and append
Query duplication and referencing

Query Optimization

Query folding
Error handling

Parameters & Functions

Creating parameters
Building functions

Data Modeling

Semantic model
Star schema
Fact and dimension tables

Relationships

Relationship types
Active/inactive relationships

DAX & Performance

Creating measures
Performance analysis

Security

Row-level security

Why Choose Us

Experience Power BI: Data Transformation & Modeling through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from anywhere in the world or arrange a dedicated online training program for your organization.

Experience Power BI: Data Transformation & Modeling in a professional face-to-face classroom environment. Classroom Based training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class exclusively for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Power BI: Data Transformation & Modeling as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Bilginç IT Academy trainers can travel internationally to deliver dedicated training programs at your preferred location.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Power BI: Data Transformation & Modeling Training