Data Analysis Expressions
DAX Material
Demo DAX
1 Topic
Profit Margin Increase: YoY, QoQ, MoM
Course Introduction
1 Topic
Course Overview
Unfold DAX
7 Topics
What Is DAX?
Why Should You Learn DAX?
Prerequisites
What Is DAX Good At?
What Is DAX Not Good At?
Learning Curve
What Makes DAX Hard To Learn?
Understand The Data
2 Topics
Data Introduction
Get Data & Follow Star Schema, Cardinality
Demonstrations
10 Topics
Calculated Columns: Demo
Measure: Demo, Move Measures to Another Table
Difference Between Calculated Columns & Measures
Scalar Functions: Demo
Tabular Functions
Filtering: Demo
Iterators: Demo
Evaluation Contexts: Row Vs Filter Vs Query Context: Demo
Calculate Function: Changing Filter Context: Demo
Difference between Related & Related Table Functions: Demo
Business Problem Statements
21 Topics
Tx Over 10000 using Countx
Tx Over 10000 using Countrows
West: East Multiple Tx
West: East Multiple Sales
Customer Retention Rate
Profit Margin Increase: YoY, QoQ, MoM
Calendar Table, WoW Change
Are My Top 5 Customers Profitable
Compare Item Against Others – Static
Compare Item Against Others – Dynamic
Rank Subcategories
Make Top N Dynamic
Market Basket Analysis
Same Period Last Year Analysis
Same Period Beyond Last Year Analysis
Parallel Period & Difference among three
Making Chart Title Dynamic
Visual Appeal
Currency Slicer
Pareto Analysis
Bonus Content
2 Topics
List Of 328 DAX Functions With Description
Most Useful Characters Codes
Capstone Project
1 Topic
Submit Your PBIX File
Additional Projects
3 Topics
Business Problem: How to bring Liquidity into the business? (Finance Domain)
Business Problem: How to control high attrition rate? (HR Domain)
Business Problem: How to control high number of customer complaints? (Operations/ Customer Service)
0% Complete
0/58 Steps
Previous Lesson
Demo DAX
Data Analysis Expressions
Demo DAX
In Progress
Lesson Content
0% Complete
0/1 Steps
Profit Margin Increase: YoY, QoQ, MoM
Previous Lesson
Back to Course
Next Lesson
error:
Content is protected !!
WhatsApp us