In this Power BI training you learn to turn raw data into clear, interactive reports, and it is aimed at users with Excel experience who want to build reports themselves. You prepare data with Power Query, model tables in a star schema, write first measures in DAX and design visuals so the message is grasped quickly. Finally you publish the report and control who may see it. The examples come from sales and controlling.
What you’ll take away.
- Load and clean data from Excel, CSV and databases with Power Query
- Build a data model with a fact table, dimensions and relationships
- Write measures using CALCULATE, filter context and time intelligence in DAX
- Design visuals, slicers and drillthrough for a clear message
- Publish, refresh and secure reports in the Power BI service with row-level security
Your training in detail
- Who is it for?
- Controlling, sales, project offices and business departments who want to build reports from their own data, plus aspiring data analysts.
- Prerequisites
- Solid Excel skills including formulas and pivot tables. Access to Power BI Desktop, which we clarify beforehand.
- Format & planning
- Suggested format: 3 days (about 7 hours each) live online or on site by arrangement. Scope depends on prior knowledge.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
Power Query: connecting sources, splitting columns, setting data types, appending and merging tables, tracing applied steps.
Data model: star schema, relationships with cardinality and filter direction, and a dedicated date table.
DAX fundamentals: measures versus calculated columns, SUM, DIVIDE, CALCULATE, variables and filter context.
Time intelligence with prior-year comparison, running totals and year-to-date based on the date table.
Report design: suitable chart types, matrix and cards, slicers, bookmarks, drillthrough and accessibility.
Publishing in the Power BI service with workspaces, scheduled refresh, sharing and row-level security.
Suggested exercise: From three sample tables on sales, products and customers, build a model with a date table and a report comparing revenue with the prior year.
Exams, licences & credentials
The Microsoft exam PL-300 (Microsoft Certified: Power BI Data Analyst Associate) relates to this topic. Attending alone awards no vendor certification. Exam fees and Power BI licences are only included if confirmed in the offer.
Vendor references & review date
Sources checked on 2026-11-03. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
Your learning content
These objectives describe the training topic. The specific syllabus, duration, dates, trainer and price are agreed before booking.
Frequently asked questions
Do I need Excel skills for the Power BI training?
Yes, solid Excel basics are sensible, especially formulas and pivot tables. Many Power BI concepts, such as filtering and grouping, build on them. You do not need to know databases or programming languages. You learn DAX step by step, starting from simple measures.
Power BI or Excel: which fits my analysis?
Excel is enough for manageable, one-off analyses. Power BI pays off when several data sources are linked, the data is refreshed regularly and many people should use interactive reports. Both tools share Power Query, so your Excel knowledge is a good start.
Is DAX hard to learn?
DAX looks like Excel formulas at first but follows filter context, which takes practice. With a clean star schema most measures become simpler. We start with SUM and DIVIDE, move on to CALCULATE and practise time comparisons. For deeper topics a follow-up session makes sense.
Does Power BI: tell the data story include a certificate?
The Microsoft exam PL-300 (Microsoft Certified: Power BI Data Analyst Associate) relates to this topic. Attending alone awards no vendor certification. Exam fees and Power BI licences are only included if confirmed in the offer.