Advance Power BI DAX

Packt via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

19 weeks, 1 hour a week
Sessions

Self-Paced
Level

Intermediate
Subtitles

English

Found in

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

Build advanced analytical models using Power BI and DAX. Learn to create dynamic calculations, optimize data models, and apply time intelligence. Gain practical skills through real-world scenarios and challenge-based learning. Gain the ability to transform raw data into meaningful insights by mastering advanced DAX and data modeling techniques. This course focuses on building strong analytical foundations, enabling you to create efficient models, write optimized calculations, and deliver impactful business intelligence solutions. From understanding relationships to implementing complex measures, you will develop the confidence to handle real-world data challenges. You will begin with core concepts such as data modeling, star schemas, and the distinction between fact and dimension tables. As you progress, you will explore DAX fundamentals, including operators, functions, and context handling. Each module builds progressively, ensuring a structured and practical learning journey. The final sections emphasize advanced analytics, including time intelligence, filtering techniques, data transformation, and table functions. You will also explore quick measures, what-if parameters, and parent-child hierarchies to enhance reporting flexibility. A comprehensive challenge section reinforces your understanding by applying concepts to real business scenarios, helping you transition from learning to practical implementation with confidence. This course is designed for data analysts, Power BI developers, and business intelligence professionals looking to advance their DAX skills. It is also suitable for professionals working with data who want to improve reporting and analytics capabilities. A basic understanding of Power BI, data modeling, and fundamental Excel concepts is recommended. This course follows a structured, hands-on approach to learning advanced DAX concepts. Each topic is explained with practical examples to reinforce understanding. Real-world challenges ensure that concepts are applied effectively in business scenarios. This course is based on Advance Power BI DAX, by Pavan Lalwani. This Course is licensed and distributed by Packt. All rights reserved. Packt is one of the world's most prolific publishers of cutting-edge technical content. For over two decades we've made it our mission to curate and publish the knowledge of only the very best technical experts. We focus on real-world courses that help our customers get the job done, with coverage that extends across a wide range of established and cutting-edge technical topics. If you're an individual or an organisation that embraces learning by doing, Packt is the perfect fit for you.

Syllabus

Introduction to Data Modelling
- 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.
Introduction to DAX Functions
- 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.
Text Functions
- 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.
Date Functions
- 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.
Math Functions
- 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.
Logical Functions
- 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.
Information & Validation Functions
- 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.
Aggregation Functions
- 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.
Iterator Functions
- 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.
Calculate Functions
- 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.
Time Intelligence
- 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.
Filter Data
- 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.
Add Data Functions
- 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.
Join Functions
- 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.
Create Data
- 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.
Parent-Child Functions
- 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.
Quick Measures
- 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-If Parameters
- 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.
21 Days Challenge Solution
- 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.