Home

All courses

Mastering DAX Calculations in Microsoft Power BI

Business

Business Analytics & Intelligence

DAX

Mastering DAX Calculations in Microsoft Power BI

Harness the power of DAX calculations within Microsoft Power BI to create advanced analytical models

4.7

(2220)

19851 enrolled on this course

Last updated 11/2021

Enterprise DNA

₹ 3499.0

₹ 4999.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

Take your Power BI skills to new heights with "Mastering DAX Calculations in Microsoft Power BI."
This comprehensive Udemy course empowers you to harness the full potential of DAX calculations and unleash advanced analytical models. Whether you're a beginner or an experienced user, this course will guide you through the powerful DAX language, enabling you to create sophisticated reports and solutions with ease.
Starting with the basics, you'll gain a deep understanding of DAX and its capabilities. Learn the difference between calculated columns and measures, explore context, aggregation, and iteration formulas, and discover the importance of a quality data model. Through real-world scenarios, you'll uncover how to leverage DAX effectively and extract valuable insights from your data. With coverage of every major DAX function, you'll learn how to perform calculations, combine functions, and solve common analytical challenges.
The course provides 11 hours of comprehensive training, accompanied by demo data sets for practical exercises. Visualize the inner workings of the DAX calculation engine, understand filter and row context, and master the pivotal CALCULATE function for advanced analysis. Dive into table and filtering functions, explore time intelligence functions, and discover advanced table functions for unique calculation requirements. Gain the expertise to tackle even the most complex DAX topics and become a proficient Power BI user.
Enroll in this course and join the thousands of professionals who have transformed their data analysis capabilities.
Who this course is for:
Data analysts seeking to enhance their skills in DAX calculations within Power BI.
Excel users looking to transition their analytical expertise to Power BI and leverage the power of DAX.
Reporting managers aiming to create more insightful and comprehensive reports using DAX in Power BI.
Business intelligence professionals who want to enhance their expertise in DAX calculations to create advanced analytical models and insightful reports in Power BI.

What you'll learn

Master the art of DAX calculations and unlock the full potential of Microsoft Power BI

Gain expertise in structuring and formatting DAX formulas for optimal performance

Utilize DAX variables effectively to enhance your formulas and achieve advanced analytical insights

Create powerful analytical models by leveraging calculated columns and measures in Power BI

Discover how to write aggregation, iteration, and table DAX functions to perform complex calculations

Visualize the inner workings of the DAX calculation engine and understand the concept of 'context'

Solve real-world analytical scenarios using DAX and unlock actionable insights from your data

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction to DAX

1.1-Learning Tips From Enterprise DNA

1.2-Microsoft Power BI user-interface updates to be aware of

1.3-Course Overview - Let's get started!

1.4-Unlocking Intriguing Insights: Facts about DAX

1.5-Resource Download

1.6-Mastering DAX: Introduction and Learning Path

1.7-Data Types and Operators in DAX

1.8-The Importance of Naming Conventions in DAX Formulas

1.9-Understanding Formula Syntax in DAX

1.10-Working with Measure Groups in Power BI

1.11-Formatting DAX Code for Readability

1.12-Simplifying Formulas with Variables in DAX

1.13-Writing comments in your code

1.14-Harnessing the Power of Quick Measures in Power BI

1.15-Optimizing Data Model and Relationships for DAX

1.16-The only way to learn is to practice

1.17-Introduction to DAX - Review

1.18-Introduction to DAX - Quiz

1.19-Key Insights for Effective DAX and Power BI Use

2-DAX Basics

2.1-Did You Know? Facts about DAX

2.2-Calculated Columns vs. Measures in DAX

2.3-Understanding Context and the DAX Calculation Engine

2.4-Evaluation Context in DAX

2.5-Aggregation Context in DAX

2.6-Iterations or row context in DAX

2.7-Context Transition in Calculated Columns

2.8-Filter Propagation in Data Models

2.9-DAX Basics - Review

2.10-DAX Basics - Quiz

2.11-Principles of DAX Calculations and Context

2.12-Your Feedback Matters!

3-Getting started with DAX

3.1-DAX Uncovered: 3 Facts

3.2-Exploring Different DAX Function Types

3.3-Aggregation Functions: SUM, AVERAGE, MIN, MAX

3.4-More Aggregators - COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT

3.5-Iteration Functions - SUMX/AVERAGEX/MINX/MAXX

3.6-Branching Methodology for Measures

3.7-Combining DAX Functions for Powerful Calculations

3.8-Error Handling with BLANK, ISBLANK, IFERROR

3.9-Logical Functions: IF, SWITCH

3.10-Dividing Numbers with DIVIDE Function

3.11-Exploring Other Function Types in DAX

3.12-Getting Started with DAX - Review

3.13-Getting Started with DAX - Quiz

3.14-Learning DAX Functions for Enhanced Data Analysis in Power BI

4-Introducing Simple Table Functions

4.1-Hidden Powers of DAX: 3 Facts

4.2-Understanding Table Functions and Virtual Tables

4.3-Filtering Tables with FILTER Function

4.4-Utilizing the Versatile VALUES Function

4.5-VALUES vs. DISTINCT: Choosing the Right Function

4.6-VALUES vs. SELECTEDVALUE: Handling Single Values

4.7-Removing Filters with ALL Function

4.8-Removing Filters with ALL and ALLEXCEPT Functions

4.9-Comprehensive Understanding of ALLSELECTED Function

4.10-Introducing Simple Table Functions - Review

4.11-Introducing Simple Table Functions - Quiz

4.12-Deep Dive into DAX Table Functions and Filtering in Power BI

5-Expanding on CONTEXT

5.1-CONTEXT Basic Facts

5.2-Managing Filter and Row Context with Relationships

5.3-Working with Single and Multiple Tables in Context

5.4-Controlling Context with ISFILTERED and ISCROSSFILTERED Functions

5.5-Navigating Relationships with RELATED Function

5.6-Understanding Time-Based Context with EARLIER Function

5.7-Expanding on Context - Review

5.8-Expanding on CONTEXT - Quiz

5.9-Quick Insights on Context Management and Navigating Relationships in DAX

6-CALCULATE statement

6.1-Redefining Data with DAX

6.2-The Importance of CALCULATE in DAX

6.3-Understanding the Role of CALCULATE and Context Interaction

6.4-Expanding Functionality with CALCULATE

6.5-How are formula calculated when you involve CALCULATE?

6.6-Calculating with User Relationships: USERELATIONSHIP Function

6.7-Applying Simple and Advanced Filters with CALCULATE

6.8-Calculate Statement - Review

6.9-Calculate statement - Quiz

6.10-Deciphering the Power of CALCULATE in DAX

7-Time Intelligence Functions

7.1-The Power Time: Quick Facts

7.2-Exploring Time Intelligence Functions in DAX

7.3-Leveraging the Power of Date Tables in Power BI

7.4-Comparing Dates with DATEADD Function

7.5-DATEADD vs. SAMEPERIODLASTYEAR: Analyzing Time Comparisons

7.6-Aggregating Data with YTD, QTD, and MTD Functions

7.7-Analyzing Time Periods with PREVIOUSMONTH and PARALLELPERIOD

7.8-Information about Time with OPENINGBALANCEMONTH, STARTOFMONTH, ENDOFYEAR

7.9-Working with Date Ranges using DATESBETWEEN, DATESINPERIOD, DATEDIFF Functions

7.10-Practical Examples of Time Intelligence Functions in Action

7.11-Time Intelligence Functions - Review

7.12-Time Intelligence Functions - Quiz

7.13-Time Intelligence in DAX for Effective Reporting

8-Advanced Techniques For Variables

8.1-DAX in Depth: Variables

8.2-Understanding how variables are evaluated

8.3-Simplifying Formulas with Table Variables

8.4-Using Variables to Enhance Multiple Measures

8.5-Advanced Techniques for Variables - Review

8.6-Advanced Techniques For Variables - Quiz

8.7-Leveraging Variables for Enhanced DAX Formulas

9-Creating Virtual Relationships

9.1-Good to Know: Virtual Relationships in DAX

9.2-Virtual vs. Physical Relationships: When to Use Each Approach

9.3-Expanding Functionality with TREATAS

9.4-Comparing USERELATIONSHIP with Other Relationship Techniques

9.5-Creating Virtual Relationships - Review

9.6-Creating Virtual Relationships - Quiz

9.7-Relationships and Advanced Techniques in DAX

10-Advanced Table Functions

10.1-Beyond Basics: The Power of Advanced Table Functions in DAX

10.2-Manipulating Virtual Tables with ADDCOLUMNS Function

10.3-Expanding ADDCOLUMNS Function

10.4-Summarizing Data with SUMMARIZE Function

10.5-Combining Table Functions for Advanced Analysis

10.6-Exploring CROSSJOIN Function

10.7-Using ROW Function in DAX

10.8-Performing Set Operations with UNION Function

10.9-Applying Advanced Filtering with CALCULATETABLE Function

10.10-Intersecting and Subtracting Sets with INTERSECT and EXCEPT Functions

10.11-Aggregating Data with SUMMARIZECOLUMNS Function

10.12-Generating Data with GENERATE Function

10.13-Grouping Data with GROUPBY Function

10.14-Advanced Table Functions - Review

10.15-Advanced Table Functions - Quiz

10.16-Harnessing DAX Table Functions for Advanced Data Manipulation

11-Ranking Functions

11.1-Fascinating Facts about DAX Ranking Functions

11.2-Ranking Data with RANKX Function

11.3-Selecting Top N Values with TOPN Function

11.4-Practical Examples of Ranking Functions in DAX

11.5-Ranking Functions - Review

11.6-Ranking Functions - Quiz

11.7-Exploring Data Ranking and Selection Techniques in DAX

12-Advanced DAX Formula Combination Examples

12.1-Facts on Combining DAX Formulas

12.2-Leveraging Measure Branching Methodology for Complex Calculations

12.3-Comparing Quarterly Sales Performance

12.4-Analyzing Data using Virtual Tables and COUNTROWS Function

12.5-Implementing Budgeting Allocation Algorithm in DAX

12.6-Efficient Error Handling in Totals Calculation

12.7-Advanced DAX Formula Combination Examples - Review

12.8-Mastering DAX Calculations - Final Quiz

12.9-Navigating Complex Scenarios with Advanced DAX Formulas

13-Advanced Conditional Formatting with DAX

13.1-Must Read: Additional Content

13.2-Facts on advanced conditional formatting

13.3-Why should you use conditional formatting?

13.4-A brief discussion on color theory

13.5-A demo on advanced conditional formatting

13.6-Creating a table for hex codes

13.7-Using the DAX Editor Pro

13.8-Using custom icons

13.9-Using a Base64 converter tool

13.10-Using visual layering and transparency masks

13.11-Advanced Conditional Formatting with DAX - Review

13.12-Advanced Conditional Formatting with DAX - Quiz

13.13-Insights on Advanced Conditional Formatting with DAX in Power BI

14-Advanced DAX Concepts To Master In Power BI

14.1-Must Read: Additional Content

14.2-Intriguing Facts on Power BI and DAX Techniques

14.3-Resource Download

14.4-Deep Dive: Unlocking the Power of DAX's 'Calculate' Function

14.5-Elevating Your DAX Game: Using Variables and the 'Calculate Table'

14.6-Behind the Scenes: Introduction to DAX Virtual Tables

14.7-Detailed Analysis: Virtual Tables & Identifying Top Customers

14.8-Strategic Insights: Leveraging Virtual Tables and 'TopN' in Power BI

14.9-Streamline Your Workflow: Efficient Power BI Development

14.10-Loop, Aggregate, & Transform: The Art of Iterating Functions in Power BI

14.11-Advanced DAX Concepts To Master In Power BI - Review

14.12-Advanced DAX Concepts To Master In Power BI - Quiz

14.13-Insights to Advanced Power BI Concepts

15-Course Assignments - Mastering DAX Calculations

15.1-Dataset Download

15.2-DAX Table Functions in Power BI

16-Additional Resources - Complimentary guides for your data career

16.1-2024 Data Career Guide - Enterprise DNA

16.2-Congratulations and Next Steps

Course Categories

Popular Courses

Mastering DAX Calculations in Microsoft Power BI

Description

What you'll learn

Requirements

Course Content

You May Like