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
- 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
- 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.
- 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)
- 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)
- 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