Power BI Deep Logic: Think in DAX, Transform with M

Advanced Power BI course for professionals ready to master complex logic, modeling, performance optimization, and automation using DAX and M

Duration 15 Hours
Level Advanced
Format In-Person/Online
Hours 15 Hours
Power BI Deep Logic

Course Overview

This course is designed for Power BI professionals who already know how to build reports and are ready to go deeper into logic, modeling, performance, and automation. Participants will learn to write optimized DAX, build smart queries in M, handle real-world data issues, and master advanced features like custom functions, multiple relationships, and dynamic visual controls.

By the end of the course, participants will be able to:

  • Build logic-rich reports that go beyond visuals
  • Write reliable, readable DAX using best-practice patterns
  • Automate messy data flows using custom M functions and parameters
  • Troubleshoot and reverse-engineer existing PBIX files confidently
  • Deliver smart, interactive dashboards using field parameters, dynamic titles, and custom visuals

Target Audience

Experienced Power BI Users

Ready for advanced modeling and logic

DAX Analysts

Who write DAX regularly and want to master it

BI Developers

Facing messy data, slow models, or complex reporting needs

Dashboard Teams

Delivering high-stakes, dynamic dashboards to business stakeholders

Course Curriculum

Module 1: Advanced Power Query (M) for Automation & Cleanup

+
  • Custom Functions for Folder Imports
  • Parameterized Web Pagination
  • Handling Multi-Row Headers
  • Cleaning Non-Printable and Unstructured Data
  • Editing M Code for Refresh-Safe Logic
  • Error Trapping with try...otherwise

Module 2: Relationships, Calendars, and Time Intelligence

+
  • Understanding Inactive Relationships
  • Applying USERELATIONSHIP() in Measures
  • Handling Multiple Date Columns (e.g., Order vs. Delivery Date)
  • Writing Dynamic Measures Across Multiple Dates
  • Creating Custom DAX Calendar vs. CALENDARAUTO
  • Deep Dive: DATESYTD, SAMEPERIODLASTYEAR, DATESBETWEEN, etc.

Module 3: Core DAX Patterns for Thinking in Logic

+
  • CALCULATE() and Context Transition
  • Row Context vs. Filter Context Simplified
  • Using VAR for Clean and Performant Code
  • Iterator Functions: SUMX, AVERAGEX, MINX, etc.
  • Using VALUES, SELECTEDVALUE, ALL, REMOVEFILTERS
  • Dynamic Conditional Columns (e.g., Score Buckets, Ranges)

Module 4: Reverse Engineering, Debugging & Performance Tuning

+
  • Reverse Engineering Existing PBIX Files
  • Detecting Logic Errors, Slow Measures, and Heavy Visuals
  • Cleaning up Dirty Models and Broken Logic
  • Using Performance Analyzer and DAX Studio
  • Best Practice Model Layout & Column Pruning
  • Zebra BI and Advanced Variance Reporting (Waterfall, Actual vs. Plan)

Module 5: Dynamic Dashboards and Interactive UX Enhancements

+
  • Field Parameters for Switching Dimensions and Measures
  • Dynamic Titles using SELECTEDVALUE() and ISFILTERED()
  • Creating Custom Tooltip Pages (Mini Dashboards on Hover)
  • Drillthrough Pages with Context Filters
  • Building HTML-based KPI Cards using HTML Viewer
  • Using Buttons, Bookmarks, and Conditional Formatting

Course Information

📅 Schedule

Dates: November 16-20, 2025

Time: 6:00 PM - 9:00 PM daily

Location: Hijaz Towers-Mecca Street-Amman-Jordan or Online via MS Teams

💰 Investment

280 JOD 350 JOD 20% OFF

Early bird pricing - Limited time offer

✅ What's Included

  • 15 hours of expert instruction
  • Course materials and resources
  • 120-day access to recordings
  • Hands-on practical exercises
  • Post-training support

🚀 Ready to Enroll?

Terms & Conditions

  • 100% payment required prior to course start
  • Full refund available 7+ days before start date
  • 50% cancellation fee applies after 7 days
  • Course materials are proprietary and confidential
  • Recording access valid for 120 days post-completion