AI & Data

Power BI Training

This training is intended for people who work with processing and analyzing large amounts of data.

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

Ideal for teams that…

1 Analysts, marketers, and everyone working with data
2 People dealing with large-scale data processing and analysis
3 Anyone who wants to learn the DAX library
Outcomes after the program

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

✓

Efficiently acquire and process data for business decision-making

✓

Work with PowerQuery and data preparation techniques

✓

Learn the terminology and tools necessary to extract information from databases and present it in Power BI

✓

Use the DAX library for reporting and data analysis

✓

Tell stories with data using visualization techniques

Program · 6 modules

What we actually do

M01
Module 1: Introduction to Data Analysis with Power BI Desktop
  • · What is business intelligence?
  • · The 5 layers of a BI solution
  • · Power BI as a business intelligence tool
  • · Power BI Desktop – overview and user interface
M02
Module 2: PowerQuery – Data Preparation Tool
  • · Using data connectors: Web, CSV, Excel, SQL
  • · Combining multiple data sources in a single report
  • · Extract, Transform, Load (ETL) concepts
  • · Basic transformation functions
  • · Merging and appending queries
  • · Creating custom functions
  • · Introduction to the M language
  • · Using the Advanced Editor
  • · Best practices in data preparation
  • · Dataflows – PowerQuery Online
  • · Query folding in PowerQuery
M03
Module 3: Data Modeling in Power BI
  • · Star schema and snowflake schema
  • · Preparing fact and dimension tables with PowerQuery
  • · Building a calendar table
  • · Working with hierarchies in Power BI
  • · Best practices in data modeling
  • · Analyzing model performance
  • · Imported vs DirectQuery reports
M04
Module 4: Data Analysis with DAX
  • · Introduction to DAX
  • · Calculated columns, calculated tables, measures, and queries
  • · Basic DAX functions
  • · Iterators in DAX
  • · Row context, evaluation context, and filter context
  • · Changing calculation context with CALCULATE()
  • · Advanced time intelligence functions
  • · Best practices for writing advanced DAX queries
M05
Module 5: Storytelling with Data – Visualization Techniques
  • · Storytelling with data – concepts and principles
  • · Correct use of visualization types
  • · Working with visualizations in Power BI
  • · Filtering data at the visualization level
  • · Managing interactions between visualizations
  • · Advanced formatting of reports and visuals
  • · Drill-through functionality
  • · Using bookmarks in report building
  • · Working with field parameters
  • · Using tooltips for additional insights
  • · Best practices for visualization design
M06
Module 6: Publishing and Sharing Reports
  • · Introduction to Power BI Service
  • · Publishing rules and best practices
  • · Data security: Row Level Security (RLS) and Object Level Security (OLS)
  • · Refreshing data in Power BI Service
  • · Using Power Automate to streamline workflows with Power BI
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 →