Loading Excelerate Logo
EXCELERATEINSIGHTS
INITIALIZING SECURE ENVIRONMENT...
Logo EXCELERATEINSIGHTS
B
Brian Kiprop
LEARNER PORTAL
Dashboard Exit
DAX & Modeling Advanced Level Pay Later Eligible

Advanced DAX & Tabular Modeling for Enterprise Decision Systems

Master the inner workings of the DAX Formula Engine and Storage Engine. Unlock the real power of CALCULATE, filter context transition, virtual table manipulations, and semi-additive calculations.

16 Total Hours
4 Recorded Modules
Verified Exam & QR Certificate
Thumbnail
Enrollment Fee
KES 8,500.00
Instant Access

Prepaid Masterclass • Instant Safaricom M-PESA STK Push

Full Lifetime Access • Verified Certificate Included

Curriculum & Video Modules

1

Module 1: Evaluation Context Transition & The Magic of CALCULATE

42 mins Free Preview

In-depth conceptual breakdown of row context versus filter context, context expansion, and row-to-filter transition in Power BI.

2

Module 2: Virtual Tables in DAX — SUMMARIZE, ADDCOLUMNS & TREATAS

55 mins Locked

Constructing in-memory table expressions for dynamic segmentations, cohort analytics, and complex variance benchmarking.

3

Module 3: Custom Financial Time Intelligence & Non-Standard Calendars

48 mins Locked

Implementing customized 4-4-5 accounting calendars, Year-To-Date (YTD), Quarter-Over-Quarter (QoQ), and Rolling 12-Month metrics.

4

Module 4: Performance Analyzer, DAX Studio & Storage Engine Optimization

60 mins Locked

Identifying bottlenecks with VertiPaq engine metrics, query plans, xmSQL traces, and eliminating high-cardinality performance killers.

Enterprise DAX & Tabular Modeling Certification Exam

Passing score: 75%. Earn an official verifiable certificate with live QR code verification.

Your Lead Instructor

F

Faith Mutheu

Senior BI & DAX Performance Specialist
4.95 / 5.0 Rating 150 Students

Expert in tabular data modeling, star schema architecture, and complex DAX pattern formulation.

1-on-1 Consultation Rate
KES 4,500.00 / Hr
Book Consultation