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
Course Description
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.
Delivered live by a senior practitioner, online or on-site, every module is practical and, where possible, uses your own data. Because these are the exact engines behind Power BI, the course is also one of the best ways to prepare to move up to it.
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.
Course Curriculum
Getting & Transforming Data
- Connect to files, folders and databases
- Clean, split, merge and append
- Change data types and remove errors
- Repeatable Power Query steps
- Refreshing with one click
Shaping Data the Right Way
- Unpivot and pivot data
- Group and aggregate
- Structure into a model-ready shape
- Clean, consistent columns
- Merging and appending queries
Building the Data Model
- Load tables into Power Pivot
- Create relationships
- Design a simple star schema
- Fact vs dimension tables
- Hiding and organising fields
Introduction to DAX
- Calculated columns vs measures
- Why measures are the right default
- Your first measures
- Basic aggregations
- Formatting and organising measures
Core DAX with CALCULATE
- Filter context
- CALCULATE and context transition
- Filter modifiers like ALL
- Patterns behind business measures
- Common mistakes to avoid
Time Intelligence
- A proper date table
- YTD, QTD and MTD
- Prior-year comparisons
- Rolling averages
- Marking the date table correctly
PivotTables & Cube Formulas
- Analyse the model with PivotTables
- Slicers and timelines
- CUBE functions for free-form layouts
- Building a report grid
- Formatting for print and sharing
Building a Refreshable Report
- Assemble a clean Excel report
- One-click refresh
- Connecting visuals to the model
- Maintainable structure
- Sharing and handover
How the Training Is Delivered
The training is practical, hands-on and flexible — delivered live by a senior practitioner, online or on-site in Dubai.
- 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?
Both, in a sense. Power Query, Power Pivot and DAX live inside Excel but are the same engine behind Power BI, so the skills transfer directly.
Do I need any DAX experience?
No. We start from the basics of measures and filter context and build up to CALCULATE and time intelligence.
Which version of Excel do I need?
Excel for Windows (Microsoft 365 or Office 2016 and later) with Power Pivot. We confirm requirements before the session.
Will this help me learn Power BI?
Yes. It is one of the best ways to learn the Power BI data model and DAX, using a tool you already know.
Can it be tailored to my team?
Yes. We can run it privately on your own data and focus on the calculations your reports need.
Is it available online or in person?
Both. We deliver in-person across Dubai and the UAE, and remotely for distributed teams.
Ready to build real models in Excel?
No reviews yet — be the first to share your experience.