Power BI Course
Power Query, data modeling, DAX, visuals, dashboards and Power BI Service - from first import to a published report.
View course →
Data modeling
Power BI Data Modeling Course
Most wrong numbers in Power BI come from the model, not the visuals. Learn to design models that give correct results and run fast.
- Hands-on, project-based
- Trainer feedback on every module
- Free counselling & demo on request
- Format
- Live, instructor-led
- Duration
- Shared at counselling
- Fees
- Shared on enquiry
- Level
- Intermediate
Power BI Data Modeling Course overview
A good model separates what happened (fact tables: sales, tickets, transactions) from the descriptions of it (dimension tables: customer, product, date). Relationships connect them, and filters flow from dimensions to facts.
This course teaches those ideas through the problems that appear in real projects: duplicates in a dimension, two date columns, many-to-many relationships and models that are slower than they should be.
Who this course is for
- Power BI users whose totals do not match Excel
- Analysts who inherit models built by others
- Learners preparing for BI developer roles
Prerequisites
- Basic Power BI knowledge (Power BI course)
Modeling topics
Star schema
Why one fact table surrounded by dimensions beats one wide flat table.
Fact and dimension tables
Grain, keys and what belongs where.
Relationships and cardinality
One-to-many, many-to-many, filter direction and inactive relationships.
Date tables
Build and mark a proper date table for time intelligence.
Performance
Reduce column count, cardinality and model size; use Performance Analyzer.
DAX interaction
How model design changes which measures are simple or hard.
What you will learn
- Identify the grain of a fact table
- Split a flat file into facts and dimensions
- Choose relationship settings correctly
- Create and mark a date table
- Resolve ambiguity and many-to-many problems
- Measure and improve model performance
Tools covered
- Power BI Desktop
- Model view
- Power Query
- DAX
- Performance Analyzer
Practical projects
Flat file to star schema. Rebuild a single wide Excel table as a model.
Multi-fact model. Sales and returns sharing common dimensions.
Model audit. Find and fix problems in a deliberately flawed model.
Detailed curriculum
The program is taught module by module. Each module ends with a hands-on exercise built on business-style data.
Module 1Modeling concepts
- Normalisation vs star schema
- Grain and keys
Module 2Building relationships
- Cardinality, direction, active/inactive
Module 3Dimension design
- Date, product, customer, geography
Module 4Multiple fact tables
- Conformed dimensions, bridge tables
Module 5Performance
- Model size, cardinality, query reduction
Module 6Model governance
- Naming, folders, documentation
Learning methodology
Every concept is taught on a working file. You see the business question first - for example, "which regions missed target last quarter?" - and then build the formula, query or measure that answers it.
Each module closes with an exercise you complete yourself, followed by trainer feedback. Mistakes are part of the process: we cover the errors people actually hit, such as text-formatted numbers, broken lookups and wrong relationship direction.
Training files and practice datasets are provided so you can repeat every exercise after class.
Training format, batches and certification
Format. Instructor-led, practical sessions. Online, classroom and hybrid options are confirmed when you speak to us.
Batches. Upcoming batch dates are shared during counselling so you get current information. Ask for weekday, weekend or fast-track availability.
Certification. You receive a CharterPeak course completion certificate on completing the program and its assessments. This is not a Microsoft certification. If you want to prepare for a Microsoft exam such as PL-300, tell us and we will map the syllabus to the official skills outline.
Your trainers
Trainer names, backgrounds and areas taught are listed on our trainers page. Ask for a short demo class or a call with the trainer before you enrol.
Sample lesson: the total that is bigger than the sum
A matrix shows regional revenue that does not add up to the grand total. The cause is a many-to-many relationship through a customer table with duplicate IDs. We clean the key, move to a one-to-many relationship, and the totals reconcile.
Career applications
- Power BI developer and BI analyst
- Analytics engineering fundamentals
- Reporting leads who review others’ models
Continue your learning path
- Write measures in DAX
- Use the model in dashboards
- See the whole path in Power BI data analytics
Frequently asked questions
Do I need database knowledge?
No. We explain keys and relationships from scratch using Excel-style examples.
Is star schema always required?
It is the recommended default in Power BI because it is simple, fast and works well with DAX. We also show when a different design is justified.
Does this include SQL?
No. The course uses Power BI and Power Query only.
What is cardinality?
It describes how rows relate across tables - for example one customer to many orders. Getting it wrong is the most common cause of incorrect totals.
What is the duration of the Power BI Data Modeling Course?
Duration depends on the batch (weekday, weekend or fast-track). We confirm the schedule and total hours when you speak to us, so you get current information rather than a fixed number on a web page.
Who can join the Power BI Data Modeling Course?
Students, graduates, working professionals and career changers. The prerequisites are listed on this page; if you are unsure, book a free counselling call and we will point you to the right starting course.
Is the training practical?
Yes. Each module is taught on working files with exercises you complete yourself, followed by trainer feedback and project work.
Is the training online or in a classroom?
Delivery options depend on the batch. Ask about current online, offline and hybrid availability when you enquire.
Is certification provided?
You receive a CharterPeak completion certificate after finishing the program and its assessments. It is not a Microsoft certification and we do not promise exam results.
What fees and payment options apply?
Fees depend on the batch and format and are shared on enquiry. See our refund policy before you enrol.
Related courses
Power BI DAX Course
Measures, filter context, CALCULATE, time intelligence and iterators - the calculation layer of Power BI.
View course →Power BI Data Analytics Course
Project-driven analytics in Power BI: question, data, model, analysis and a stakeholder-ready story.
View course →Business Intelligence Course
From raw data to decision support: preparation, modeling, analysis, visualization and reporting in Power BI.
View course →Related learning resources
Power BI Data Modeling: Star Schema and Relationships
Why a star schema works best in Power BI and how to set up relationships correctly.
Read guide →DAX in Power BI: Fundamentals and Essential Functions
Understand filter context, CALCULATE and time intelligence so your measures stay correct.
Read guide →Power Query in Power BI: Prepare Data Before You Model
Prepare data in Power Query before modeling, so DAX and visuals stay simple.
Read guide →Ready to start?
Talk to us about your background and goals. We will recommend the right batch and starting point - no pressure.