Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byIan Littlejohn

Last updated 2/2026

English

What you'll learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video
Have a COMPREHENSIVE understanding of creating data models and developing DAX formulas in Microsoft Power BI
Create calculated FIELDS and MEASURES using DAX in Power BI
Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Creating Calculated Tables
Learn to create VIRTUAL TABLES and powerful cross table calculations
Create RELATIONSHIPS between tables of data
Learn to create Hierarchies and Data Groups for better data analysis

Course content

10 sections • 56 lectures • 4h 11m total length

Introduction to the Course1:34
Introduction and overview to the Data Modeling and DAX Formulas course.
About the Course1:23
Improve your Power BI master class experience by ensuring high-quality video and sound, using Udemy support for certificates, and adjusting playback speed to match your learning pace.
Please download the Training Data Files0:04
Power BI Desktop Configuration0:26
Power BI Desktop Setup2:57
Overview of the Data Model6:20
Step by step instructions to sign up for the Power BI Service and to download the Power BI Desktop.
Basic Data Model4:46
Welcome to Udemy Roleplay0:36
Discuss Power BI data project

Introduction Calculated Columns1:08
Introduction to the Data Model and calculations section of the course.
Creating Calculated Columns9:35
In this lesson we cover how to create calculated columns within the Power BI data model.
Practical Activity - Calculated Columns0:18
In this practical activity you will create three new calculated columns - Sales, Cost and Profit. You will also format these fields.
Creating Calculated Columns of Date Fields6:34
In this lesson we learn how to create additional time intelligence functions such as Year, Month and Day. These fields are added to your data model.
Practical Activity - Calculated Columns with Date Fields0:11
In this Practical Activity you will create fields for Year, Month and Day
Weekday and Weeknum Formulas3:38
Formatting Date Names7:58
In this lesson we learn how to create Month Names and Week Day Names for our data model. We also learn how to correctly set the Sort By option to make sure the names are displayed in the correct order.
Practical Activity - Formatted Date Names0:25
In this activity you will add the Month Name, WeekDay and WeekDay Name to the Data Model.
Using a Date Master Table in the Data Model10:34
In this lesson we learn how to add a Date Master to the Date Model and then to create a relationship between the Date field and the master date.
Practical Activity - Adding a Date Table to the Data Model0:19
In this practical activity you will load and configure the Date Master file to use it for data analysis.
IF Function3:42
A quick review of the Calculated Columns section.
Switch Function5:27
In this lesson you will learn how to use the IF function.
Discuss DAX Calculated Columns in the Data Analysis project

Introduction to the Measures Section1:19
Introduction to the section on Measures
What is a Measure?5:51
Creating Measures8:10
In this lesson we learn how to create Measures to calculate Sums, Averages and Distinct Counts.
Practical Activity - Creating Measures0:12
In this activity you will add a number of Measures to the Data Model.
Practical Activity - Measures5:45
Using the = Calculate Formula8:51
In this lesson we learn how to use the powerful Calculate formula. The = Calculate formula allows the filtering of an aggregation.
Practical Activity - =Calculate Formula0:16
In this practical activity you will practice using the =Calculate formula.
The All and AllExcept Function8:47
In this lesson we review how to return the entire total for a column and how to ignore the evaluation context.
Discuss the usage of Measures in the Data Analysis project

Time Intelligence - Part 111:19
In this lesson you will learn how to create a datesbetween calculation, trailing number of days, Year to Date, Quarter to Date and Month to Date calculations.
Time Intelligence - Part 28:14
In this lesson we will create Previous Month and Previous Year calculations
Time Intelligence - Part 39:13
Create running totals for year-to-date, quarter-to-date, and month-to-date using total and sum of sales. Learn how master date context and filter context, via year and month slicers, shape these calculations.

Using the SUMX function5:35
In this lesson we cover how to use the X functions - SUMX, COUNTX, AVERAGEX,MAXX and MINX. We also review how to manually enter data.
Example of MAXX - Find the Highest Sales Day0:05
Example MAXX Functions using Values function6:03
The conclusion to the Measures section.
RANKX Function7:26
In this lesson you will learn how to use the RANKX function to Rank the customer data.
Customer Segmentation - SWITCH Function6:13
In this lesson you will learn how to do customer segmentation using the SWITCH function.
What If Parameters7:10
In this lesson you will learn how to use the What If Parameter.

Introduction to Virtual Tables0:40
Explore virtual tables to summarize and aggregate data into smaller, faster tables, and apply calculated columns, measures, and relationships for flexible data modeling.
Creating Virtual Tables5:18
In this lesson you will learn how to create a Calculated Table. A Calculated Table aggregates detailed data into summary tables.
Customer Segmentation4:52
Practical Activity - Virtual Tables0:36
In this practical activity you will create two calculated tables. The first table summarizes the Model field and the second the Customer information.
Completed Practical Activity9:50
Meeting to discuss the usage of virtual tables in the data analysis project

Introduction to the Relationships Section1:06
Introduction to the Relationship Section
Download the Training Data Files0:02
Relationships between Tables8:04
In this lesson you will learn how to create relationships between tables in Power BI.
Relationship Calculations4:56
In this lesson we review how to use relationships between tables to create new calculations.
USERELATIONSHIP Function8:40
Practical Activity - Create Relationships and Calculations0:48
In this lesson you will create relationships between 2 tables and also add calculations using the relationship.
Discuss creating Relationships in your data model

Requirements

You will require Power BI desktop and access to the Power BI Service on the Internet
You should be able to work with data in Excel and do basic reporting
Download the Power BI Desktop app which is available free from Microsoft for Windows

Description

Great reports are built on great data models. In this course, learn how to create relationships, create measures, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch! This course will get you up to speed and working in a very short time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert.

COURSE CONTENT AND OUTCOME

Creating Calculated Columns - Basic calculations, using date fields and date tables
Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Time Intelligence, Customer Segmentation and many more
Creating Relationships between tables and using relationship calculations
Creating Virtual Tables and Calculations between Tables
Creating and using hierarchies and data groups
Case Studies on DirectQuery, Star Schemas and Quick Measures

ABOUT THE TRAINER

I am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.

WHAT STUDENTS ARE SAYING

This course is great, it revealed to me functions that I never thought existed. I cannot wait to apply these in real time scenarios. Thanks Ian you are doing a great job.
Coming from Spotfire (after company decided PowerbI is cheaper) with its slightly different approach, this course helped to gain some traction with PowerBI
I felt quite comfortable using Power BI, but this course opened my eyes to many more possibilities the tool offers. I really appreciate the straightforward, no-nonsense and easy to follow teaching style from the instructor. Highly recommended to all who have been using Power BI and are ready for the next step.

DATA ANALYSIS COURSES ROADMAP

The tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.

Microsoft Excel

Introduction to Analyzing Data with Excel Pivot Tables
Complete Introduction to Excel Power Pivot
Complete Introduction to Excel Power Query
Excel Interactive Dashboards and Data Analysis
Complete Introduction to Business Data Analysis
Tables and Formulas with Excel

Microsoft Power BI

Complete Introduction to Microsoft Power BI
Complete Introduction to Power BI Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class - Dashboards and Power BI Service

Google

Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Looker Studio (formerly Google Data Studio)

Amazon QuickSight

Complete Introduction to Amazon QuickSight

ChatGPT

Introduction to Analyzing Data with ChatGPT

Who this course is for:

Excel users who want to learn how to create PROFESSIONAL reports in Power BI
Power BI users who want to learn to build great data models and learn to use the DAX formula language

What you'll learn

Explore related topics

Course content

Introduction to the Course9 lectures • 18min

Creating Calculated Columns13 lectures • 50min

Creating Power BI Measures9 lectures • 39min

Time Intelligence Functions3 lectures • 29min

Additional Measure Calculations6 lectures • 33min

Virtual Tables6 lectures • 21min

Creating Relationships in Power BI7 lectures • 24min

Hierarchies and Data Groups4 lectures • 13min

Case Studies4 lectures • 25min

Conclusion to the Course2 lectures • 1min

Requirements

Description

Who this course is for: