Loading page

Data Visualisation

Duration
2 days / 16 hours

Net price per group

up to 5 people
4,700 PLN
up to 7 people
5,600 PLN
up to 10 people
6,600 PLN

The price covers a closed training, training materials and certificates for all participants.

Microsoft Excel BI training shows that Excel is capable of much more than a spreadsheet — it is a full Business Intelligence platform available without additional licences. The team will learn to combine Power Query, Power Pivot and advanced charts into a single cohesive ecosystem, building interactive analytical dashboards directly in Excel. Think of it as 'Power BI inside Excel' — no separate tool to deploy.

Prerequisites

Good knowledge of Microsoft Excel (advanced level or completed Power Query training)

Who is this for

  • Advanced Excel teams wanting to build professional analytical dashboards
  • Analytical and controlling departments reporting to management without access to Power BI
  • BI teams looking for a way to rapidly prototype reports in Excel
  • Companies and departments wanting to implement BI without additional licensing costs

What you'll gain

  • Full command of the data lifecycle: import (Power Query) → model (Power Pivot) → report
  • Building relational data models from multiple tables without VLOOKUP
  • Writing DAX measures in Power Pivot: calculations impossible with standard Excel formulas
  • Interactive dashboards with slicers, timelines and dynamic charts
  • Automatic data refresh — report up to date with a single click

    • Power Query, Power Pivot and pivot tables as one ecosystem
    • When Excel BI is enough and when you need Power BI
    • Enabling add-ins: Power Pivot and Power Query in different Excel versions
    • Designing a BI solution from query to dashboard

  1. 01

    Materials

    Presentations and exercise files to keep.

  2. 02

    Workshops

    Hands-on tasks using real business data.

  3. 03

    Certificate

    In Polish and English, print and digital.

  4. 04

    Consultations

    Post-training questions via LinkedIn.

Your question is not here? Write to me and I will give you a straight answer.

Czym różni się Excel BI od Power BI – kiedy wybrać jedno, a kiedy drugie?

Excel BI to rozwiązanie dla firm, które dobrze znają Excela i nie chcą wdrażać osobnego narzędzia. Power BI oferuje więcej opcji publikacji, współpracy online i obsługi bardzo dużych zbiorów danych. Jeśli raporty trafiają głównie do pliku XLSX lub PDF – Excel BI w zupełności wystarczy.

Czy muszę wcześniej przejść szkolenie z Power Query lub Power Pivot?

Nie jest to wymagane, ale znacznie przyspiesza naukę. Szkolenie Excel BI omawia oba narzędzia w kontekście całego ekosystemu BI. Osobne kursy Power Query i Power Pivot pozwalają zgłębić każde z nich bardziej szczegółowo.

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.

Use the form to tell me which tools your team works with and what you want to improve. I will match the training and the level.