AI & Data

Power Query – Beginner Level Training

The Power Query – Intermediate Level training is an intensive course for people who already have basic knowledge of Power Query and want to expand their skills with advanced techniques in data processing and visualization.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 The target group includes people working with data in Excel, business analysts, reporting specialists, and anyone who wants to use data analysis tools more effectively in their work.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

As a result, participants will gain skills that enable advanced analysis, processing, and visualization of data in Excel, allowing for more effective decision-making and visual communication of information.

Program · 3 modules

What we actually do

M01
Importing Data from Various Sources
  • · Databases
  • · Text files
  • · Folder import
  • · Web pages
  • · Excel workbooks
M02
Managing Queries
  • · Refreshing queries
  • · Different ways of loading data from queries
  • · Appending queries
  • · Merging queries
  • · Working with multiple queries
M03
Data Transformation and Cleaning in Power Query Editor
  • · Working with columns
  • · Working with rows
  • · Defining and changing data types
  • · Unpivoting columns
  • · Pivoting columns
  • · Grouping and summarizing data
  • · Text, numeric, and date transformations
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced Power BI Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced RPA Developer Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →