To wersja testowa nowego serwisu infoShare Academy — wyświetlane treści i oferta nie są wiążące ani kompletne

Data

Power Query – Intermediate Level

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

Duration
8h · 1 day
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

How we handle your data

We process your business data (name, work e-mail, phone number, company, job title) in order to handle your corporate training inquiry and prepare an offer. The data controller is infoShare Academy Sp. z o.o., Al. Grunwaldzka 472B, 80-309 Gdańsk. Providing the data is voluntary but necessary to receive a response. You have the right to access, rectify, erase or restrict the processing of your data and to object to it. Full information is available in our data processing notice.

Optional marketing consents

The controller of your personal data is infoShare Academy sp. z o.o. The rules for processing personal data are set out in the Privacy Policy and the Data Processing Notice.

Other programs for teams

See all →
Data

Active Directory

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

16h · 2 days →
Data

AI SQL Developer

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

24h · 3 days →
Data

Amazon Redshift - Introductory Training

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

16h · 2 days →