Power Query, Power Pivot & DAX Training in Dubai
Turn Excel into a proper analytics engine. This hands-on course teaches the three tools behind modern Excel and Power BI: Power Query to clean and combine data, Power Pivot to build a data model, and DAX to write powerful calculations.
For analysts & finance teams • Hands-on with your own data • Intermediate level
What You Will Learn
Power Query
Import, clean, merge and append data from many sources with steps that refresh in one click.
Power Pivot & the Data Model
Load millions of rows, build relationships and design a star schema right inside Excel.
DAX Measures
Write reusable measures with CALCULATE, SUM and filter context — the same DAX used in Power BI.
Time Intelligence
Year-to-date, prior-year and rolling calculations that respond to any date filter.
Refreshable Reports
Build PivotTables and dashboards on the model that update automatically when data changes.
A Bridge to Power BI
Learn the exact skills that transfer directly to Power BI when you are ready to move up.
What You Will Be Able to Do
By the end of the course you will be able to:
- Connect to and clean data with Power Query
- Combine multiple files and tables reliably
- Build a data model with relationships in Power Pivot
- Write DAX measures using CALCULATE and filter context
- Create time-intelligence calculations such as YTD and prior year
- Build PivotTables and charts on the data model
- Refresh an entire report with one click
- Move confidently towards Power BI
Course Curriculum
1. Getting & Transforming Data
Connect to files, folders and databases; clean, split, merge and append with repeatable Power Query steps.
2. Shaping Data the Right Way
Unpivot, group and structure data into a clean, model-ready shape.
3. Building the Data Model
Load tables into Power Pivot, create relationships and design a simple star schema.
4. Introduction to DAX
Calculated columns vs measures, and why measures are the right default.
5. Core DAX with CALCULATE
Filter context, CALCULATE and the patterns behind most business measures.
6. Time Intelligence
YTD, MTD, prior-year and rolling averages with a proper date table.
7. PivotTables & Cube Formulas
Analyse the model with PivotTables, slicers and CUBE functions.
8. Building a Refreshable Report
Assemble a clean, one-click-refresh Excel report on your model.
Is This Course For You?
Who Should Attend
- Analysts who have outgrown standard PivotTables
- Finance and operations professionals working with large data
- Excel users who want Power BI skills without leaving Excel
- Teams that rebuild the same reports every month
- Anyone preparing to move to Power BI
Prerequisites
- Comfortable with Excel formulas and PivotTables
- No Power Query, Power Pivot or DAX experience needed
- A laptop with Excel for Windows (Microsoft 365 or 2016+)
- Optional: a dataset from your work to practise on
How the Training Is Delivered
The course is practical and built around real data:
- Instructor-led, live sessions with a senior practitioner
- Hands-on throughout — you build the model yourself
- Option to train on your own data
- Small groups or private team training
- Follow-up support so the skills stick
Power Query, Power Pivot & DAX — FAQ
Is this an Excel course or a Power BI course?
Do I need any DAX experience?
Which version of Excel do I need?
Will this help me learn Power BI?
Can it be tailored to my team?
Is it available online or in person?
Ready to build real models in Excel?
Book a free consultation and we will tailor a Power Query, Power Pivot and DAX course to your team and your data.