Excel BI: Power Query, Power Pivot & DAX
Stop merging files by hand. In two or three days your team builds a real BI process inside Excel: automated data loading and cleaning in Power Query, a proper data model in Power Pivot and DAX measures — with AI supporting the daily work.
Key facts
Prices are in EUR, excluding VAT, for the whole group. Contact us to confirm the teaching language, dates and time zone.
For teams drowning in manual data work
Multi-file reporting
Teams that combine data from many exports, systems and Excel files — and repeat it manually every month.
Cyclic reports
Anyone who rebuilds the same reports each period and wants a one-click, refreshable process instead.
Advanced analysis
Analysts who need a real data model and measures, not a hundred helper columns and fragile VLOOKUPs.
No new BI system
Companies that want BI-grade reporting but on the tool the whole organization already has: Excel.
What participants learn
Power Query ETL
Import, clean and transform data with repeatable queries — no formulas, no manual steps.
Merging data sources
Append and merge queries: many files, many sheets, many systems — one clean table.
Data model
Build relations between tables in Power Pivot and stop fighting with lookup columns.
DAX measures
Write calculations that scale: sums, ratios, time intelligence — one measure, every report.
AI support
Copilot and ChatGPT woven into the process: faster transformations, formula help, error hunting.
Refreshable reports
A report that updates itself: change the source, click Refresh, done — month after month.
Three modules, day by day
In the 2-day format modules 1–2 share the first day; the 3-day version adds a full day of DAX practice. Final agenda is agreed with you before the training.
- Classic Excel vs the BI approach: why reports break and how to fix the process
- Data sources: files, whole folders, exports, systems
- The core idea of Excel BI: one data model, many reports
- Workshop: planning your own BI process on your team's real reports
- Importing data: single files, whole folders, sheets, systems
- Cleaning and shaping: removing errors, splitting, pivoting, data types
- Appending and merging queries: many tables — one clean dataset
- Parameters and error handling: refreshable, robust queries
- Workshop: automated ETL for one of your monthly reports
- Building the data model: relations, star schema basics, calendar table
- DAX measures step by step: sums, ratios, time intelligence
- KPI reporting on top of the model — the management view
- AI block: Copilot & ChatGPT woven into the BI workflow
- Workshop: a complete, refreshable reporting solution
The training program is flexible. Before the workshops, we can adapt the scope, difficulty level, examples and training duration to your team’s needs.
Frequently asked questions
The program core is the same. The 3-day version adds a full day of deeper DAX practice and more workshop time on your own data. If your team will build measures regularly — choose 3 days.
No. Everything happens inside Excel — we confirm that your Windows Excel edition includes Power Query and Power Pivot before booking.
No VBA and no coding. Power Query transformations are point-and-click; DAX is a formula language similar to Excel formulas, taught from scratch.
A Windows laptop with desktop Excel, Power Query and Power Pivot available in your Office edition. We check the exact edition and required features with you before booking.
Before the training, every participant receives access to the complete 13-hour online Excel course “Formulas, Pivot Tables & Maps”.
Participants also receive workshop files with solutions, ready-to-use query and report templates, and certificates of completion.
Both work. Online runs via Teams or Zoom; onsite takes place at your office — travel outside Poland is agreed individually.
Book by phone or email
Ask about available dates, agenda details or group pricing — a short call or an e-mail is all it takes.
+48 500 196 861 Mon–Fri, 9:00–17:00 Warsaw time (CET/CEST) contact@maps-for-excel.com