| 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: Demo | |
| Measure: Demo | |||
| What is Filtering? | |||
| Filtering: Demo | |||
| Evaluation Contexts: Filter Vs Row (Iterators) | |||
| Evaluation Contexts: Demo | |||
| Nesting Evaluation Contexts | |||
| 5 | Business Problem Statements | How to identify profit clusters using a map for states from all regions? | Understand geographic clusters with high profits, Create zonal sales teams |
| Are my top states by sales volume in every region also commensurately profitable? Who are my top 5 customers in every state? | Reach out to State heads and Top customers and identify reasons for low performance Rewards for high performing states and customer Avoid over-reliance on top customers Customer Value Modeling | ||
| How much have regions grown since the first year of operations? | Identify profitable / lean periods Identify trends | ||
| Is there a seasonal pattern in sales between the regions? | Align marketing plans coordinating with seasonality effects | ||
| How do I assign customer clusters basis the Sales vs. Profit plot? | Customer segmentation and profiling Marketing plan for different clusters | ||
| What is an overview of all seasonality for all our regions presented side by side? | A high-level view of the entire business Identify and compare multiple channels | ||
| Which is the best combination for the business? | Prioritize the combination that works well Divest from combinations that do not have customer acceptance | ||
| How many individual transactions are over 10000? | Identify high ticket orders Plan customer loyalty offering | ||
| How are transactions in one region better than than the other as a multiple? | Compare two regions on normalized data Create a baseline | ||
| How are sales in one region better than than the other as a multiple? | Compare two regions on normalized data Create a baseline | ||
| What is my customer churn? | Identify same-store / like-to-like growth Identify customer attrition Calculate Customer Lifetime Value | ||
| What is my increase in profit margin YoY? | Compare bottom-line vs. top-line | ||
| How does one SUBCategory compare against others? | Calculate Pareto analysis Identify Must Sell SKUs Devise divestment strategy Realign marketing activities | ||
| Which are my Top 3 selling SUBCategories in each category? | Identify top-selling SKUs | ||
| What is the basket size for a contingency? | Inventory control Stock replenishment planning | ||
| What is my YoY growth? | Identify yoy growth for each quarter and month Isolate problem areas Identify business seasonality | ||
| How do I showcase my results as custom icons? | Create management-friendly reports Visually interactive reports | ||
| Make N of top N dynamic through a slicer | Easy slice & dice | ||
| Show dynamic title as selected in the slicer | Easy report understanding | ||
| Connect all the slicers with a single button and create a panel | Space-saving & multiple-filtering | ||
| 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)