Loading Excelerate Logo
EXCELERATEINSIGHTS
INITIALIZING SECURE ENVIRONMENT...
Logo EXCELERATEINSIGHTS
Data Engineering Intermediate Level Strictly Prepaid Only

Power Query M-Code & Automated ETL Big Data Pipelines

Unravel advanced M-Code functions, parameterized API web requests, automated batch data cleaning, unpivoting complex matrices, and building enterprise ETL architectures.

12 Total Hours
4 Recorded Modules
Thumbnail
Enrollment Fee
KES 6,000.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.

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