Packt

Advance Power BI DAX

Packt

Advance Power BI DAX

Included with Coursera PlusLearn more

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Build efficient data models using star schema principles

  • Create advanced DAX measures for dynamic reporting

  • Apply time intelligence functions for trend analysis

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

September 2026

Assessments

18 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 19 modules in this course

This module introduces key concepts in data modelling, including the importance of data models, the distinction between fact and dimension tables, and the structure of star schemas. Learners will gain foundational knowledge to create effective data models for reporting and analysis.

What's included

4 videos

This module introduces key concepts in DAX, comparing it with other tools like Power Query and Power Pivot, and exploring how DAX operators enhance data analysis in Power BI. Learners will gain foundational knowledge to effectively use DAX for reporting and data modeling.

What's included

4 videos1 assignment

This module teaches learners how to manipulate and transform text data using DAX functions in Power BI. It covers cleaning, replacing, combining, and working with Unicode characters to ensure data consistency and accuracy. Learners will gain practical skills to enhance data modeling and reporting capabilities.

What's included

4 videos1 assignment

This module teaches learners how to effectively use DAX date functions in Power BI to extract, calculate, and manipulate date-related data. It covers key topics such as date shifting, week identification, and working days calculations, along with best practices for modeling and relationships.

What's included

8 videos1 assignment

This module explores essential DAX math functions used in Power BI, including rounding, division, and random number generation. Learners will gain practical knowledge on how to implement these functions to enhance data accuracy and reporting capabilities. The content includes both theoretical explanations and real-world application scenarios.

What's included

4 videos1 assignment

This module covers the implementation of conditional logic, error handling, and logical operators in DAX. Learners will gain practical skills in using functions like IF, IFERROR, AND, OR, and SWITCH to manage complex data calculations and improve data accuracy in Power BI.

What's included

4 videos1 assignment

This module covers essential DAX functions for identifying errors, validating data types, and retrieving information from data sets in Power BI. Learners will gain the skills to ensure data accuracy and reliability through practical examples and validation techniques.

What's included

3 videos1 assignment

This module explores the fundamental concepts of columns and measures in DAX, including their differences, usage scenarios, and practical applications. It covers counting functions, unique value counting, and techniques for multiplying column values, helping learners enhance their data analysis skills in Power BI.

What's included

5 videos1 assignment

This module explores the use of X functions in DAX for iterating over tables and performing calculations. Learners will gain practical knowledge of how to apply these functions in Power BI for data analysis. The content includes syntax, use cases, and examples to enhance data manipulation skills.

What's included

2 videos1 assignment

This module covers advanced techniques for using DAX functions such as CALCULATE and CALCULATETABLE, including applying multiple conditions, different operators, and creating fiscal year calendars. Learners will gain the ability to perform complex data analysis and reporting in Power BI.

What's included

5 videos1 assignment

This module covers advanced time-based calculations in Power BI using DAX, focusing on techniques to analyze data across different time periods. Learners will gain skills in calculating previous and next time periods, shifting dates, and comparing data across years. The content is designed to enhance sales and performance analysis through precise time-intelligence functions.

What's included

5 videos1 assignment

This module covers essential DAX functions for filtering, aggregating, and calculating data in Power BI. Learners will gain practical skills in managing filters and returning unique or top values from datasets. The content focuses on improving data analysis through efficient DAX techniques.

What's included

6 videos1 assignment

This module teaches how to manipulate and transform data in Power BI using DAX functions. Learners will gain skills in selecting columns, adding calculated columns, and grouping data for aggregation. The content focuses on practical data preparation techniques for enhanced analysis.

What's included

3 videos1 assignment

This module covers essential table operations in Power BI DAX, including combining, merging, and comparing data using Crossjoin, Union, and Except functions. Learners will gain the ability to efficiently manipulate and analyze data across multiple tables. The focus is on understanding and applying these functions to solve real-world data integration challenges.

What's included

3 videos1 assignment

This module focuses on generating and manipulating data using Power BI DAX functions. Learners will gain practical skills in creating dynamic datasets and applying DAX in real-world business scenarios.

What's included

1 video1 assignment

This module explores the fundamentals of building and managing parent-child hierarchies in DAX, with a focus on using key functions like path, path item, and path length to analyze hierarchical data structures. Learners will gain practical skills in organizing and interpreting complex data relationships within Power BI.

What's included

1 video1 assignment

This module covers essential techniques for using Quick Measures in Power BI, including text functions, mathematical operations, time intelligence, and category-based averages. Learners will gain practical skills in applying these functions to real-world data analysis scenarios. The module also includes a knowledge check to reinforce understanding and application of key concepts.

What's included

4 videos1 assignment

This module teaches how to create and use parameters in Power BI for dynamic reporting. Learners will explore numeric parameters, field parameters, and their application in visuals and dashboards. The content empowers users to build more flexible and interactive data models.

What's included

2 videos1 reading1 assignment

This module focuses on using DAX to analyze business data and derive actionable insights. Learners will explore various metrics such as product performance, sales trends, customer behavior, and employee efficiency. By the end, they will be able to apply DAX functions to solve real-world data analysis problems.

What's included

22 videos1 assignment

Instructor

Packt - Course Instructors
Packt
2,393 Courses696,856 learners

Offered by

Packt

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions