Power BI: Go from Zero to Hero (DAX Advanced)

✅ 80+ recorded sessions with lifetime access to recordings.

✅ Basic Power BI Concepts required to enroll for this course

✅ Hand-picked Power BI problems (asked in FAANG and product-based companies) set for practice.

✅ Includes portfolio projects on datasets

✅ Assignments after each class with solutions

Click here to enroll

About the Course:

Our course is a perfect choice for Data Analyst, Power BI Developer, Data Storyteller, and Business Analyst who wants to take their Power BI Skills to the next level. This course will take you from basics of DAX functions to the advanced techniques in Data Analysis Expressions (DAX) and data modelling to improve data analysis and visualization using Power BI.

Kick start your career with mastering the most in demand BI Tool called Power BI.

Advanced techniques in Data Analysis Expressions (DAX)
Creating complex data models and calculations using DAX
Building dynamic and interactive visualizations
Real-world examples and case studies

Recorded Classes Lifetime Access

Watch Anywhere, Anytime

Learn from Basic to Advance

Discuss with the Educator

What you will learn

Create advanced Power BI reports using DAX

Use Data Analysis Expressions (DAX) to create advanced calculations in Power BI and improve data analysis.

Understand data modelling techniques for Power BI

Learn how to create complex data models that capture business metrics and insights.

Design dynamic and interactive visualizations

Create Power BI reports and dashboards that allow end-users to explore data and gain insights.

Course Syllabus

Module 1 (DAX Fundamentals & Getting used to DAX)

1.1 Introduction to DAX
1.1.1 What is DAX?
1.1.2 What is a Data Model?
1.1.3 Components of a Data Model
1.2 Calculated Columns vs Calculated Measures
1.3 Formatting & Comments in DAX
1.4 Aggregate Functions (SUM, AVG, MIN, MAX)
1.5 ‘X’ Aggregators (SUMX,AVGX, etc)
1.6 Exercises on SUMX (Practical use cases)

Module 2 (Context & Time Intelligence in DAX)

2.1 DAX Formula & Storage Engine
2.1.1 What is Vertipaq?
2.1.2 Value & Hash Encoding Concept
2.2 DAX Evaluation Context (Row vs Filter)
2.3 Concept of CALCULATE function in DAX
2.4 Date Functions (Year, Month) & working of DATE Master
2.5 Time Series Analysis (YTD, QTD, MTD, MoM, etc)
2.6 Case Study on Time Series (Sales Analysis)

Module 3 (DAX Advanced Concepts)

3.1 TABLE Functions (Filter, All, Values, Related, etc)
3.2 IF statements and Conditional Logic
3.3 SWITCH statements
3.4 Advanced Variable Structure in DAX
3.5 Filter Functions
3.5.1 ALL vs ALLSELECTED VS ALLEXCEPT with practical examples
3.5.2 LOOKUPVALUE, KEEPFILTERS, EARLIEST with practical examples
3.6 RANKX vs TOPN (With Practical Examples)
3.7 Information Functions
3.7.1 CONTAINSSTRING
3.7.2 HASONEFILTER vs HASONEVALUE3.7.3 ISBLANK

Module 4 (Summarize & Aggregating)

4.1 Summarize Table
4.2 Alternative Relationship
4.3 SUMMARIZECOLUMNS with practical use case
4.4 ADDCOLUMNS
4.5 GROUPBY | CURRENTGROUP
4.6 GROUPBY Double Aggregation

Module 5 (Joins in DAX)

5.1 Introduction to JOINS
5.2 Standard Relationship vs How to Join tables without a Relationship
5.3 CROSSJOIN vs GENERATE Functions
5.4 Concept of Lineage5.5 Understanding of UNION & INTERSECT

Module 6 (Working with External Tools)

6.1 DAX Studio
6.1.1 Purpose & Installation Guide
6.1.2 Debugging Using Variables
6.1.3 Debugging Calculated Measures
6.2 Optimizing Data Models
6.2.1 Performance Tuning Techniques
6.2.2 DAX Optimization Techniques

Module 7 (Getting Better at Visualization using DAX)

7.1 Understanding the importance of DAX for visualisation
7.2 Trend Visual in Stack column charts
7.3 Enhance the Bar Charts using DAX
7.4 Working with Dynamic Titles
7.5 Stock Market Trend line - Visualization

Module 8 (Advanced DAX Case Studies)

8.1.1 Understanding MOVING AVERAGES
8.1.2 How to Calculate Moving Averages for sales.
8.1.3 Moving Average Verification.
8.1.4 Creating Dynamic Moving Averages.
8.2 Two Table comparision to calculate total paid subscribers.
8.3 How to get top 3 products basis sales in a monthly date table.

Course Content

✓ This Course will cover everything about DAX. If you are a beginner or expert in Power BI,

✓ This course will help you ace your DAX journey. Watch this series completely and you don't have to go anywhere for DAX.

Webinar Schedule

Benefits And Bonuses Included In The Courses

Get trained & Certified by Working Professional

Visualization in Power BI

Introduction to Business Intelligence

Live Session where you can clear all your doubts.

Completion Certificate - DAX Advanced

You may also be interested in