Data Visualisation

MS Excel BI

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

Contact Frequently asked questions

About the training

MS 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 MS 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

Training programme

—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

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

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