IIRF Online > Business > Business Analytics & Intelligence > Data Analysis Expressions (DAX) > Mastering DAX Calculations in Microsoft Power BI
Mastering DAX Calculations in Microsoft Power BI by Udemy
Harness the power of DAX calculations within Microsoft Power BI to create advanced analytical models
Course Highlights
- 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
Skills you will learn!
Curriculum
19 Topics
Learning Tips From Enterprise DNA
Microsoft Power BI user-interface updates to be aware of
Course Overview - Let's get started!
Unlocking Intriguing Insights: Facts about DAX
Resource Download
Mastering DAX: Introduction and Learning Path
Data Types and Operators in DAX
The Importance of Naming Conventions in DAX Formulas
Understanding Formula Syntax in DAX
Working with Measure Groups in Power BI
Formatting DAX Code for Readability
Simplifying Formulas with Variables in DAX
Writing comments in your code
Harnessing the Power of Quick Measures in Power BI
Optimizing Data Model and Relationships for DAX
The only way to learn is to practice
Introduction to DAX - Review
Introduction to DAX - Quiz
Key Insights for Effective DAX and Power BI Use
12 Topics
Did You Know? Facts about DAX
Calculated Columns vs. Measures in DAX
Understanding Context and the DAX Calculation Engine
Evaluation Context in DAX
Aggregation Context in DAX
Iterations or row context in DAX
Context Transition in Calculated Columns
Filter Propagation in Data Models
DAX Basics - Review
DAX Basics - Quiz
Principles of DAX Calculations and Context
Your Feedback Matters!
14 Topics
DAX Uncovered: 3 Facts
Exploring Different DAX Function Types
Aggregation Functions: SUM AVERAGE MIN MAX
More Aggregators - COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT
Iteration Functions - SUMX/AVERAGEX/MINX/MAXX
Branching Methodology for Measures
Combining DAX Functions for Powerful Calculations
Error Handling with BLANK ISBLANK IFERROR
Logical Functions: IF SWITCH
Dividing Numbers with DIVIDE Function
Exploring Other Function Types in DAX
Getting Started with DAX - Review
Getting Started with DAX - Quiz
Learning DAX Functions for Enhanced Data Analysis in Power BI
12 Topics
Hidden Powers of DAX: 3 Facts
Understanding Table Functions and Virtual Tables
Filtering Tables with FILTER Function
Utilizing the Versatile VALUES Function
VALUES vs. DISTINCT: Choosing the Right Function
VALUES vs. SELECTEDVALUE: Handling Single Values
Removing Filters with ALL Function
Removing Filters with ALL and ALLEXCEPT Functions
Comprehensive Understanding of ALLSELECTED Function
Introducing Simple Table Functions - Review
Introducing Simple Table Functions - Quiz
Deep Dive into DAX Table Functions and Filtering in Power BI
9 Topics
CONTEXT Basic Facts
Managing Filter and Row Context with Relationships
Working with Single and Multiple Tables in Context
Controlling Context with ISFILTERED and ISCROSSFILTERED Functions
Navigating Relationships with RELATED Function
Understanding Time-Based Context with EARLIER Function
Expanding on Context - Review
Expanding on CONTEXT - Quiz
Quick Insights on Context Management and Navigating Relationships in DAX
10 Topics
Redefining Data with DAX
The Importance of CALCULATE in DAX
Understanding the Role of CALCULATE and Context Interaction
Expanding Functionality with CALCULATE
How are formula calculated when you involve CALCULATE?
Calculating with User Relationships: USERELATIONSHIP Function
Applying Simple and Advanced Filters with CALCULATE
Calculate Statement - Review
Calculate statement - Quiz
Deciphering the Power of CALCULATE in DAX
13 Topics
The Power Time: Quick Facts
Exploring Time Intelligence Functions in DAX
Leveraging the Power of Date Tables in Power BI
Comparing Dates with DATEADD Function
DATEADD vs. SAMEPERIODLASTYEAR: Analyzing Time Comparisons
Aggregating Data with YTD QTD and MTD Functions
Analyzing Time Periods with PREVIOUSMONTH and PARALLELPERIOD
Information about Time with OPENINGBALANCEMONTH STARTOFMONTH ENDOFYEAR
Working with Date Ranges using DATESBETWEEN DATESINPERIOD DATEDIFF Functions
Practical Examples of Time Intelligence Functions in Action
Time Intelligence Functions - Review
Time Intelligence Functions - Quiz
Time Intelligence in DAX for Effective Reporting
7 Topics
DAX in Depth: Variables
Understanding how variables are evaluated
Simplifying Formulas with Table Variables
Using Variables to Enhance Multiple Measures
Advanced Techniques for Variables - Review
Advanced Techniques For Variables - Quiz
Leveraging Variables for Enhanced DAX Formulas
7 Topics
Good to Know: Virtual Relationships in DAX
Virtual vs. Physical Relationships: When to Use Each Approach
Expanding Functionality with TREATAS
Comparing USERELATIONSHIP with Other Relationship Techniques
Creating Virtual Relationships - Review
Creating Virtual Relationships - Quiz
Relationships and Advanced Techniques in DAX
16 Topics
Beyond Basics: The Power of Advanced Table Functions in DAX
Manipulating Virtual Tables with ADDCOLUMNS Function
Expanding ADDCOLUMNS Function
Summarizing Data with SUMMARIZE Function
Combining Table Functions for Advanced Analysis
Exploring CROSSJOIN Function
Using ROW Function in DAX
Performing Set Operations with UNION Function
Applying Advanced Filtering with CALCULATETABLE Function
Intersecting and Subtracting Sets with INTERSECT and EXCEPT Functions
Aggregating Data with SUMMARIZECOLUMNS Function
Generating Data with GENERATE Function
Grouping Data with GROUPBY Function
Advanced Table Functions - Review
Advanced Table Functions - Quiz
Harnessing DAX Table Functions for Advanced Data Manipulation
7 Topics
Fascinating Facts about DAX Ranking Functions
Ranking Data with RANKX Function
Selecting Top N Values with TOPN Function
Practical Examples of Ranking Functions in DAX
Ranking Functions - Review
Ranking Functions - Quiz
Exploring Data Ranking and Selection Techniques in DAX
9 Topics
Facts on Combining DAX Formulas
Leveraging Measure Branching Methodology for Complex Calculations
Comparing Quarterly Sales Performance
Analyzing Data using Virtual Tables and COUNTROWS Function
Implementing Budgeting Allocation Algorithm in DAX
Efficient Error Handling in Totals Calculation
Advanced DAX Formula Combination Examples - Review
Mastering DAX Calculations - Final Quiz
Navigating Complex Scenarios with Advanced DAX Formulas
13 Topics
Must Read: Additional Content
Facts on advanced conditional formatting
Why should you use conditional formatting?
A brief discussion on color theory
A demo on advanced conditional formatting
Creating a table for hex codes
Using the DAX Editor Pro
Using custom icons
Using a Base64 converter tool
Using visual layering and transparency masks
Advanced Conditional Formatting with DAX - Review
Advanced Conditional Formatting with DAX - Quiz
Insights on Advanced Conditional Formatting with DAX in Power BI
13 Topics
Must Read: Additional Content
Intriguing Facts on Power BI and DAX Techniques
Resource Download
Deep Dive: Unlocking the Power of DAX's 'Calculate' Function
Elevating Your DAX Game: Using Variables and the 'Calculate Table'
Behind the Scenes: Introduction to DAX Virtual Tables
Detailed Analysis: Virtual Tables & Identifying Top Customers
Strategic Insights: Leveraging Virtual Tables and 'TopN' in Power BI
Streamline Your Workflow: Efficient Power BI Development
Loop Aggregate & Transform: The Art of Iterating Functions in Power BI
Advanced DAX Concepts To Master In Power BI - Review
Advanced DAX Concepts To Master In Power BI - Quiz
Insights to Advanced Power BI Concepts
2 Topics
Dataset Download
DAX Table Functions in Power BI
2 Topics
2023 Data Career Guide - Enterprise DNA
Congratulations and Next Steps
Mastering DAX Calculations in Microsoft Power BI
Related Data Analysis Expressions (DAX) Courses
Thank You!
Your review has been submitted successfully.