DAX Course

S No. Module Topic Use Case of Business Problem Statements
1 Course Introduction Course Overview  
2 Unfold DAX 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?  
   
Difference Between Calculated Columns & Measures
 
3 Understand The Data Data Introduction  
4 Demonstrations Calculated Columns  
    Measure  
    What is Filtering?  
    Filtering: Demo  
    Evaluation Contexts: Filter Vs Row (Iterators)  
    Evaluation Contexts: Demo  
    Nesting Evaluation Contexts  
5 Business Problem Statements Region Profitability
Understand geographic clusters with high profits, create zonal sales teams
    Sales Equate Profitability
Reach out to State heads and identify reason for low performance
Rewards for high performing states and customer
Avoid over-reliance on top customers
    Region Growth Identify profitable/ lean periods
Identify trends
    Seasonality
Align marketing plans coordinating with seasonality effects
    Customer Clusters
Customer segmentation and profiling
Marketing plan for different clusters
    Trellis Chart
High level view of entire business
Identify and compare multiple channels
    Ship Mode And Segment Combination
Prioritize the combination that works well
Divest from combinations that do not have customer acceptance
    Customer Churn
Identify customer churn over the year
Check if customer churn follows a seasonal/ other pattern
Check if customer churn impacts sales and profitability
    Tx Over 10000 Identify high ticket orders
Plan customer loyalty offering
    West: East Multiple Tx
Compare two regions on normalized data
    West: East Multiple Sales
Compare two regions on normalized data
    Customer Churn
Identify same-store/ Like-to-like growth
Identify customer attrition
Calculate Customer Lifetime Value
    Profit Margin Increase Compare bottom-line Vs top-line
    Compare Item Against Others Calculate Pareto analysis
Identify Must Sell SKUs
Devise divestment strategy
Realign marketing activities
    Rank Subcategories Identify top selling SKUs
    Show Top N Subcategories Identify top selling SKUs
Present dynamic control to end-user
    Market Basket Analysis Inventory control
Stock replenishment planning
    Daily Movement Of Cumulative Sales
Do granular week-wise planning
Understand weekday frequency of sales
Plan discount / offers for Trade Marketing
    Same Period Analysis
Identify yoy growth for each quarter and month
Isolate problem areas
Identify business seasonality
    Basket Size Proportioning Proportion basket size
    Visual Appeal Create management-friendly reports
Visually interactive reports
6 Bonus Content List Of 328 DAX Functions With Description  
    Most Useful Characters Codes  
7 Capstone Project DIY - Project  
    Practice Material  

Practical Learning

Practice Sheets

Recording

Certification by Edu4Sure

Any Payment Method (Please pay as per discussion with the team for the required course)

1) Net Banking

TestFormula Education Pvt. Ltd.        
Account Number: 33729473635            
State Bank of India, Delhi           
IFSC: SBIN0001573

2) Pay through Payment Gateway (International transactions acceptable)