DAX Made Easy
Turbocharge Your Power BI & Excel Skills
Why Settle for Basic When You Could be a Pro?
Let's get straight to the point. You've heard of Power BI. You might have even played around with it. Great start! But let's face it, unless you master DAX (Data Analysis Expressions), your Power BI reports will be as exciting as a Monday morning meeting.
So what's DAX?
DAX stands for Data Analysis Expressions and it's the formula language of Power BI and Excel Power Pivot.
With formulas, you'll be able to discover more complex data insights. It's the secret sauce that takes your data stories from "meh" to "WOW!"
Why DAX Made Easy?
Clear Steps, No Jargon: Learn DAX the XelPlus way - no tech-speak. Just easy, fun lessons.
Hands-On Challenges: Forget pointless exercises. Tackle challenges that mirror real business scenarios, ensuring you not only learn but truly understand DAX.
From Zero to Pro: Never touched DAX before? Perfect! We start from the ground up.
Learn DAX in Your Comfort Zone:
Excel Power Pivot or Power BI, Your Choice! 💡
Do you love Excel? Great, we'll explore DAX using Excel's Power Pivot, making it super easy for you to get started.
If you're more of a Power BI enthusiast, no worries, every exercise and challenge in this course can be directly applied to Power BI as well.
Why is this awesome?
Because you get to learn DAX in the environment you're most comfortable with. Master DAX once, and you're set to dazzle in both Excel Power Pivot and Power BI. It's a win-win, giving you the freedom and flexibility to shine wherever you work!
Course Curriculum
- Workbook Info & Notes
- Setup the Model with a Separate Measures Table (Hidden Tip) (7:54)
- Handling Drill To for Separate Measures Table
- DAX Columnar Database & the Advantages it Brings (5:38)
- Data Compression: How to Optimize Your Data Model with Smart Decisions (4:26)
- 🤔 Quiz
- 📝 Key Takeaways: Data Compression
- Filter Context, Relationships & Grand Totals (9:00)
- 💪 CHALLENGE: Filter Context - Calculate Last Day of Sales for Each Month (4:45)
- Concept of Expanded Tables (Become Pro) (7:01)
- RELATED & RELATEDTABLE (When to Use These) (7:15)
- Iterator Functions: When to Iterate & Use Related (SUMX vs SUM) (6:34)
- Row Context: The Skeleton Underneath (6:54)
- 💪 CHALLENGE: Find the Mistake! DAX Function is Wrong! (6:39)
- 📝 Key Takeaways: Evaluation Context
- Filter Function to Restrict the Filter Context (7:49)
- 💪 CHALLENGE: How Many Orders Below Retail Price? (5:55)
- ALL Function with FILTER to Unfilter (8:32)
- FILTER Function & Filter Context Interaction (Become Pro) (9:56)
- Use Variables for More Clarity
- VALUES & HASONEVALUE Function (8:55)
- CONCATENATEX Function to Show Slicer Selection (Become Pro) (7:58)
- 💪 CHALLENGE: Get a List of Sales Dates for Each Product (4:45)
- 📝 Key Takeaways: DAX Functions
- CALCULATE Function: Let's Review the Basics (4:34)
- How to Visualize the Behavior of CALCULATE (8:06)
- How CALCULATE Overwrites Existing Filters - KEEPFILTERS & FILTER(ALL) Combo (7:03)
- OR, AND Conditions in CALCULATE (7:40)
- CALCULATE with OR Condition from Multiple Columns (5:16)
- Behavior of ALL in CALCULATE & Why Context Matters (Become Pro) (9:04)
- ALLEXCEPT & ALLSELECTED in CALCULATE (Become Pro) (6:04)
- Measures Based on Dynamic Thresholds (Disconnected Tables) - Become Pro (9:39)
- Using Aggregation Functions in CALCULATE Filter (Unique Customers To Date) (9:00)
- Using Variables for Complex Calculations (7:30)
- 💪 CHALLENGE: Find Last Follower Count (Value for Last Date) (6:54)
- 🤔 Quiz
- 📝 CALCULATE: Key Takeaways (8:21)
- Context Transition Explained with a Simple Example (Become Pro) (7:15)
- When and How to Avoid Context Transition (3:38)
- Where You NEED Context Transition (5:04)
- 💪 CHALLENGE: Maximum & Average Daily Sales (5:52)
- Hidden Secret of Measures & Context Transition in Calculated Columns (6:36)
- 💪 CHALLENGE: Explain Why this Measure Returns Wrong Results (7:05)
- 📝 Key Takeaways: Context Transition
- What you Learn: Practical Advanced Calculations (1:26)
- DAX Studio & Visualizing Tables (7:55)
- TOPN Function (Sales of Top 3 Products) (7:25)
- TOPN - Differentiate Between Ties (5:47)
- Find Date with Highest Sales (CONCATENATEX & TOPN) (5:57)
- 🎁 BONUS: ADDCOLUMNS Function in DAX Studio (2:43)
- Get Product Name with Highest Sales (5:53)
- 💪 CHALLENGE: Get the Customer Number with Highest Sales
- RANKX Function for Dynamic Ranking (10:36)
- Ranking Multiple Columns: CROSSJOIN Function (Become Pro) (3:25)
- Many to One Side Calculations: Distinct Count of Sales City by Month (6:01)
- 💪 CHALLENGE: Distinct Count of Product Category by Month (Based on Sales)
- 📝 Key Takeaways: Advanced Calculations
Unlock the Next Level of Your Power BI Adventure with Leila Gharani
Hi, I'm Leila Gharani! You may know me as a Microsoft MVP, but today, I'm your personal guide on this incredible journey to mastering DAX in Power BI and Excel. With 400,000+ students transformed, I've perfected the art of breaking down the complex into bite-sized, actionable steps.
Why DAX is Your Power BI Game-Changer
DAX allows you to customize your data stories in ways you've never imagined. Think of it as Excel formulas, but turbocharged to a whole new level.
Stop settling for ordinary when extraordinary is within reach. With DAX, you’re not just creating reports: you’re elevating your status in every meeting. Showcasing custom KPIs, tailor-made functions, and reports that turn heads - that's what DAX mastery brings to your table.
Ready to leap into your next level of Power BI mastery? Your transformation awaits. Let's get started!
❓ Frequently Asked Questions
When does the course start and finish?
The course is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
Any other questions?
Send us an email to info@xelplus.com and a member of my team will get back to you ASAP.