Power BI

Microsoft Power Query

Duration

2 days / 16 hours

Net price per group

up to 5 people

4,200 PLN

up to 7 people

5,200 PLN

up to 10 people

6,000 PLN

Contact Frequently asked questions

About the training

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.

Prerequisites

Basic knowledge of MS 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

Training programme

—Overview of the data modelling process
—Identifying and analysing errors before editing
—Reference tables, dimension tables and date calendars
—Normalisation and denormalisation of datasets

What you get

Materials

Presentations and exercise files to keep

Workshops

Hands-on tasks using real business data

Certificate

In Polish and English, (print and digital)

Consultations

Post-training questions via LinkedIn

Frequently asked questions

Ready to get started?

Contact me via the form or send an email.

Ask a question Send email

About the training

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