Microsoft Power Query training is for teams that want to take full control of the data preparation process in Power BI. Participants explore the Power Query editor in depth — learning to automate data ingestion, clean data from sources ranging from Excel and SQL databases to PDF files, and combine data from multiple heterogeneous sources without manual intervention.
Basic knowledge of Microsoft Excel and Power BI
Who is this for
- Teams regularly working with Power BI who need tools for advanced data transformation
- Departments looking to automate data preparation from multiple heterogeneous sources
- Analysts working with incomplete or unstructured datasets
- Teams that want to eliminate manual data cleaning from Excel
What you'll gain
- Confident use of the Power Query editor and all its transformation tools
- Automating data loading and combining from Excel, CSV, databases and PDFs
- Effective data cleaning and standardisation — filling gaps, grouping and merging
- Combining and analysing data from local and cloud folders
- Understanding the M language and independently modifying queries
- 01
Materials
Presentations and exercise files to keep.
- 02
Workshops
Hands-on tasks using real business data.
- 03
Certificate
In Polish and English, print and digital.
- 04
Consultations
Post-training questions via LinkedIn.
Czym różni się Power Query w Power BI od Power Query w Excelu?
Silnik zapytań jest identyczny – ten sam język M, te same transformacje i kroki. Różnice dotyczą integracji z narzędziem: w Power BI dane trafiają bezpośrednio do modelu, a w Excelu możesz ładować je do arkusza lub modelu Power Pivot. Umiejętności z tego szkolenia są w pełni przenośne między oboma aplikacjami.
Czy muszę znać język M przed szkoleniem?
Nie. Szkolenie omawia język M od podstaw – zaczynamy od graficznego edytora zapytań, a dopiero potem przechodzimy do ręcznej edycji kodu. Większość uczestników nie pisze ani jednej linii M przed szkoleniem.
Czy otrzymam materiały szkoleniowe?
Tak – każdy uczestnik otrzymuje prezentacje, zestawy ćwiczeń oraz pliki warsztatowe. Po szkoleniu udostępniam listę sprawdzonych źródeł do samodzielnej nauki.
Can the training be delivered at our company premises?
Yes, I run closed-group corporate Power BI, Excel, SQL and VBA trainings across Poland. By default, sessions are delivered on participants' own equipment. On request, I can provide laptops for every participant and a multimedia projector.
Do participants need to bring their own laptops?
By default, yes — participants use their own devices. If the company does not have the required hardware or software (Power BI Desktop, Excel, SQL Server Management Studio) — on request, I can provide computers for each participant for the duration of the training.
How do I choose the right level for my team?
I offer a skills assessment test that evaluates the team's current competencies and helps select the right Power BI, Excel or SQL training level — from beginner through to advanced.
Are the sessions practical or theoretical?
Every Power BI, Excel and SQL training combines solid theoretical foundations with hands-on business exercises. The greatest value comes from tasks based on real analytical scenarios — the kind teams actually face day to day.
Will participants receive certificates?
Yes — every participant receives a completion certificate in both Polish and English. Because I am a Microsoft Certified Trainer (MCT), the certificates carry real weight in the job market and are widely recognised by employers.
How many people can attend a single training session?
The optimal group size for a corporate Power BI, Excel or SQL training is up to 12 people. Smaller groups allow for a more personalised approach; larger groups are possible by arrangement. Pricing is structured per group, not per person.
Do you offer online Power BI and Excel training?
Yes — all trainings (Power BI, Excel, SQL, VBA, DAX) are available both on-site and online via Microsoft Teams or Zoom. Online sessions follow the same hands-on, workshop format as classroom training.
Can the training programme be tailored to our specific needs?
Absolutely. I regularly design fully bespoke training programmes built around your team's tools, actual data and real-world challenges. If your company works with specific Power BI reports, Excel dashboards or SQL queries — I can structure the entire training around those. This is the most effective approach for teams with clear, defined goals.