+233 54 123 9290
support@festman.io
English flag
English
Select a Language
English flag
English
GH₵
GHS
Select a Currency
Ghanaian cedi
GH₵
Euro Member Countries
€
Nigeria Naira
₦
United States Dollar
$
0
Login Create Account
Categories
Home Courses Career Tracks Live Bootcamps Pricing
Start Learning
Analyzing Data with DAX for Power BI
Courses Power BI

Analyzing Data with DAX for Power BI

66 Students
91 Lectures
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Instructor

About the Course
Content
Comments 0
Reviews 0

About This Course

This course is designed to provide participants with a
comprehensive understanding of Data Analytics using DAX for Power BI. The course will cover a range of topics, including
time intelligence calculations, creating tables using table functions, creating
date tables, and mastering DAX concepts such as Evaluation Context, Filter
Context, and Row Context.

 

The course will begin by introducing the basic concepts of
DAX and how it can be used to perform complex analysis and computations in
Power BI. Participants will learn how to create calculations such as running
totals, year-over-year growth, month-over-month growth, and prior period
analysis using DAX.

 

The course will then cover table functions such as VALUES,
DISTINCT, FILTER, and ADDCOLUMNS. Participants will learn how to create tables
using these functions and how to manipulate data using DAX.

 

Participants will also learn how to create Date Tables using
the CALENDAR and CALENDARAUTO functions. The course will cover how to use Date
Tables to perform time intelligence calculations and how to create
relationships between tables using DAX.

 

The course will then focus on mastering DAX concepts such as
Evaluation Context, Filter Context, and Row Context. Participants will learn
how to use these concepts to create powerful calculations and data models in
Power BI.

 

Finally, the course will cover how to perform HR Analytics
using DAX. Participants will learn how to use DAX to analyze HR data and create
HR dashboards in Power BI.

 


By the end of the course, participants will have a thorough
understanding of Data Analytics using DAX for Power BI. They will be able to
use DAX to perform complex analysis and computations, create tables using table
functions, create date tables, and master DAX concepts. Participants will also
be able to perform HR Analytics using DAX and create HR dashboards in Power BI.

Thomas Festus Cudjoe
Thomas Festus Cudjoe
(20)
36 Courses
2202 Students
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence. He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics. At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.
Thomas Festus Cudjoe Book a Meeting
Curriculum Overview

This course includes 11 modules, 91 lessons, and 0:27 hours of materials.

WELCOME TO THE COURSE
5 Parts | 0:02 Hours
Welcome to the course

Welcome to the course.

Study Duration 2 Minutes
Attachments 0
Download dataset
Volume 27.33 MB
Dataset walkthrough
Volume 12 bytes bytes MB
Connecting and Transforming the Data
Volume 0 bytes MB
Data Modeling
Volume 0 bytes MB
INTRODUCTION
11 Parts | 0:03 Hours
Introduction to DAX
Volume 0 bytes MB
DAX Calculations

DAX Calculations in Power BI

Study Duration 2 Minutes
Attachments 0
DAX Functions in Power BI
Volume 0 bytes MB
DAX Operators
Volume 0 bytes MB
Referencing Model objects
Volume 0 bytes MB
Using Variables
Volume 0 bytes MB
Using Variables

Using Variables

Study Duration 1 Minutes
Attachments 0
Using variables Demo
Volume 0 bytes MB
Adding Comments in DAX
Volume 0 bytes MB
Adding Comments in DAX Demo
Volume 0 bytes MB
Adding Comments in DAX Demo
Volume 0 bytes MB
CALCULATED TABLES
12 Parts | 0:02 Hours
Introduction to calculated tables
Volume 0 bytes MB
Using the VALUES Function
Volume 0 bytes MB
Using the VALUES Function with Table Input
Volume 0 bytes MB
Using the DISTINCT Function

Using the DISTINCT Function

Study Duration 2 Minutes
Attachments 0
Combine multiple Tables with the UNION Function
Volume 0 bytes MB
Create Date Table with the CALENDAR Function
Volume 0 bytes MB
Create Date_Table with CALENDARAUTO
Volume 0 bytes MB
Add Columns to a Table with ADDCOLUMNS Function
Volume 0 bytes MB
Create a Table with the FILTER Function
Volume 0 bytes MB
Using the FILTER Function with Logical operators
Volume 0 bytes MB
Summarize Data with the SUMMARIZE Function
Volume 0 bytes MB
Calculated Tables Review
Volume 0 bytes MB
CALCULATED COLUMNS
5 Parts
Introduction to Calculated Columns
Volume 0 bytes MB
Add Calculated Column with the IF Function
Volume 0 bytes MB
Understanding Row Context
Volume 0 bytes MB
Using the RELATED Function to retrieve Data
Volume 0 bytes MB
Using the RELATEDTABLE Function
Volume 0 bytes MB
MEASURES AND AGGREGATE FUNCTIONS
8 Parts | 0:05 Hours
Introduction to Measures

Introduction to Measures

Study Duration 5 Minutes
Attachments 0
Creating Measures Table
Volume 0 bytes MB
Introduction to AGGREGATE Functions
Volume 0 bytes MB
Using the SUM Function to aggregate values
Volume 0 bytes MB
Using the COUNTROWS Function
Volume 0 bytes MB
Using the AVERAGE Function
Volume 0 bytes MB
Aggregate values using the MIN and MAX Functions
Volume 0 bytes MB
Difference between Measures and Calculated Columns
Volume 0 bytes MB
CONTEXT
4 Parts
Understanding Evaluation Context
Volume 0 bytes MB
Understanding FILTER Context
Volume 0 bytes MB
How FILTER Context works in Power BI
Volume 0 bytes MB
FILTER Context and Cross Filter Direction
Volume 0 bytes MB
ITERATORS
5 Parts | 0:04 Hours
Introduction to Iterators(X-Aggregators)
Volume 0 bytes MB
SUMX
Volume 0 bytes MB
AVERAGEX
Volume 0 bytes MB
MINX

Working with MINX

Study Duration 4 Minutes
Attachments 0
MAXX
Volume 0 bytes MB
THE CALCULATE FUNCTION
17 Parts | 0:11 Hours
Introduction to the CALCULATE Function
Volume 0 bytes MB
Understanding the CALCULATE Function
Volume 0 bytes MB
Using the CALCULATE Function Demo 1
Volume 0 bytes MB
Using the CALCULATE Function Demo 2
Volume 0 bytes MB
Using the CALCULATE Function Demo 3
Volume 0 bytes MB
Creating a virtual table with the FILTER Function
Volume 0 bytes MB
Introduction to Filter Modifiers
Volume 0 bytes MB
Introduction to REMOVEFILTERS
Volume 0 bytes MB
Using REMOVEFILTERS with CALCULATE
Volume 0 bytes MB
Introduction to the ALL Function
Volume 0 bytes MB
Using the ALL Function with CALCULATE
Volume 0 bytes MB
ALLSELECTED Introduction
Volume 0 bytes MB
ALLSELECTED Demo
Volume 0 bytes MB
ISINSCOPE Function
Volume 0 bytes MB
CalculatedTable Function
Volume 0 bytes MB
Calculated Table Demo 1

CalculatedTable in Action.

Study Duration 4 Minutes
Attachments 0
Calculated Table Demo 2

Calculated Table Demo 2

Study Duration 7 Minutes
Attachments 0
RANKING FUNCTIONS
5 Parts
Introduction to RANKX
Volume 0 bytes MB
RANKX Demo
Volume 0 bytes MB
TopN Function Introduction
Volume 0 bytes MB
Creating table with TopN Function
Volume 0 bytes MB
Highlight Top N items on a visual
Free
Volume 0 bytes MB
Play
TIME INTELLIGENCE CALCULATIONS
16 Parts
Introduction to Time Intelligence
Volume 0 bytes MB
Using the PREVIOUSYEAR Function to perform YoY Analysis
Volume 0 bytes MB
Using the PREVIOUSMONTH Function
Volume 0 bytes MB
Performing MoM Analysis
Volume 0 bytes MB
Using the PREVIOUSDAY Function
Volume 0 bytes MB
Using the DATEADD Function
Volume 0 bytes MB
Using DATEADD for MoM Analysis
Volume 0 bytes MB
Using SAMEPERIODLASTYEAR Function
Volume 0 bytes MB
Calculating Running Total with TOTALYTD Function
Volume 0 bytes MB
Running Totals with different Fiscal Year
Volume 0 bytes MB
Using the TOTALMTD Function
Volume 0 bytes MB
Using the DATESYTD Function
Volume 0 bytes MB
Using the DATESMTD Function
Volume 0 bytes MB
Continuous Running Totals Method 1
Volume 0 bytes MB
Continuous Running Totals Method 2
Volume 0 bytes MB
Time Intelligence Review
Volume 0 bytes MB
WORKING WITH RELATIONSHIPS
3 Parts
Additional Dataset
Volume 31.55 KB MB
Create virtual relationships with TREATAS
Volume 0 bytes MB
Working with inactive relationships with USERELATIONSHIP
Volume 0 bytes MB
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type Course Certificate
Leave a Comment
Please log in to leave a comment.
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Reply to Review
Submit Reply

Your reply to this review will be visible to all users.

Analyzing Data with DAX for Power BI
GH₵299
Enroll with Pro Account

This Course Includes

Downloadable Content
Official Certificate
Instructor Support
Course Forum
Favorite
Share
Report Content

Course Specifications

Sections
11
Lessons
91
Capacity
Unlimited
Duration
5:00 Hours
Students
66
Created Date
16 Apr 2023
Updated Date
5 Jun 2025
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Founder & Lead Instructor

(20)
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert
Profile

Send Course as Gift

Send as a gift to friends

Tags

Microsoft Power BI DAX Data Analytics
Analyzing Data with DAX for Power BI
You are viewing
Analyzing Data with DAX for Power BI
footer cta btn icon
Let’s get started now!

Take the First Step in Tech!

Explore courses

Learn

Self paced courses Career tracks Bootcamps Certificate Validation Pricing

Explore

Microsoft Excel Power BI SQL Generative AI Python

Contact Us

1st Floor, World Trade Centre, Accra
+233 54 123 9290
+233 54 123 9290
support@festman.io
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
LinkedIn Facebook Instagram Whatsapp
Cart
Subtotal
View Cart