Power BI Desktop - Fundamentals

Unternehmensübergreifende Weiterbildung

An wen richtet sich die Weiterbildung?

Managers, employees, project managers wishing to learn about Power BI

Dauer

12,00 Stunde(n)

Sprache(n) der Dienstleistung

EN

Nächster Termin

23.02.2026
Ort
Luxembourg

Preis

840,00€

Voraussetzungen

Knowledge of the Windows work environment

Ziele

At the end of the training, the participant will be able to:

  • create reports with Power BI Desktop
  • manipulate data in Power Query
  • manipulate a data model in Power Pivot

Inhalt

Interface

  • What is Power BI?
  • Basic Concepts
  • Components of Power BI Desktop:
    • Power Query
    • Power Pivot
    • Power View

Import data

  • Load data from different sources:
    • Excel files
    • Text files
    • Relational Databases
    • Web Pages
  • Updating Data

Data Model

  • Create relationships in the data model
  • Add measures (aggregate calculations) to a table
  • Unidirectional and bidirectional filters
  • Add a column of data
  • Using date and time data
  • Introduction to DAX (Data Analysis eXpressions)

Visualisations

  • Create a simple report
    • Charts
    • Tables
    • Matrixes
    • Slicers
  • Add visualisations
  • Filter a page
  • Filter a report
  • Explore data from a visualisation (drill down)

Power Query

  • Transform Data:
    • Sort
    • Filter
    • Exclude rows depending on their positions
    • Data types
    • Pivoting data
    • Unpivoting data
    • Group Data
  • Duplicate a query
  • Create a reference to an existing query
  • Add columns:
    • Use the automatic features
    • Use functions
  • Combine queries:
    • Append a query to another query
    • Merge queries
  • Add parameters
  • Create a function
  • Overview of the advanced editor

Online Power BI

  • Share data by using the Microsoft Power BI services

Zertifikat, Diplom

At the end of the training, the participants will receive a certificate of attendance delivered by the House of Training.

Nächster Termin

Datum
Stadt
Sprache und Preis
23.02.2026

24.02.2026
Luxembourg
EN 840,00€
23.04.2026

24.04.2026
Luxembourg
EN 840,00€

Diese Weiterbildungen könnten Sie interessieren