dax-course
transparent
600
#12bece
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)