Seminar: Power BI Fundamentals (Course No. 332301)

Objective of the Seminar

This two-day training will teach you how to import, model, and visualize data from various sources using Microsoft Power BI.
The goal is to help you work more efficiently and make data-driven decisions in your day-to-day tasks.

Content and Methodology

The seminar guides you step-by-step through preparing, analyzing, and visualizing data. You will start by importing data from sources such as Excel or databases and learn how to transform and link that data into a structured model.
The training emphasizes hands-on exercises, which you will complete directly on your computer – allowing you to immediately apply and deepen your knowledge.

Another key focus is the use of Power BI in the cloud: you will learn how to share reports online and collaborate with others.
The training concludes with a practical final project, combining the skills you have acquired.

Materials Provided

Participants receive a comprehensive training script (approx. 60 pages) and a sample database including test data, exercises, examples, and solutions for self-paced learning.

Duration

2 days

Format

Live online training or on-site in-house seminar

Prerequisites

Basic computer skills

Agenda

1. Introduction to Power BI

  • Overview and use cases
  • User interface and navigation
  • Key settings and options

2. Data Import and Preparation

  • Connecting various data sources (e.g., Excel, SQL)
  • Working with Power Query
  • Cleaning and transforming data

3. Data Modeling

  • Building effective data models
  • Creating relationships between tables
  • Introduction to DAX: calculated columns and measures

4. Reports and Visualizations

  • Creating reports with tables, charts, and slicers
  • Designing interactive dashboards
  • Using DAX for dynamic analysis

5. Power BI in Teams & Final Project

  • Using Power BI Cloud (Power BI Service)
  • Sharing and collaboration
  • Final project to apply what you’ve learned

Seminar: Power BI Advanced (Course No. 332302)

Objective of the Seminar

This two-day advanced training is designed for Power BI users with basic knowledge who want to deepen their skills.
The focus is on advanced techniques for query optimization, model-based data analysis, and the professional use of DAX functions for complex calculations.

Content and Methodology

You will learn how to use M functions to optimize queries, apply parameters effectively, and significantly improve performance.
A key focus is on star schema modeling – the Microsoft-recommended standard for analytical systems – including the handling of complex relationships (e.g., many-to-many) and the implementation of role-based security.

The second day is dedicated to advanced DAX usage. You will learn how to apply functions like CALCULATE, FILTER, and RELATED to meet complex requirements – such as time series analysis or structured evaluations like ABC classification.
The seminar concludes with practical insights into managing permissions and data refresh in the Power BI Service.

Materials Provided

Participants receive a comprehensive training script and a prepared sample database with tasks, real-world examples, and solutions.

Duration

2 days

Format

Live online training or on-site in-house seminar

Prerequisites

Basic knowledge of databases and Power BI (e.g., from the Power BI Fundamentals course)

Agenda

1. Introduction and Overview

  • Welcome and organizational framework
  • Participant introductions
  • Clarification of individual questions and objectives

2. Advanced Query Techniques with Power Query

  • Creating high-performance queries
  • Using M functions for automation
  • Applying parameters in queries
  • Optimizing performance with large datasets

3. Advanced Data Modeling

  • Building a star schema for analytical reporting
  • Using cross-filtering and custom relationships
  • Managing many-to-many relationships
  • Implementing role-based access control

4. Advanced DAX Calculations

  • Core concepts of advanced DAX functions
  • CALCULATE, FILTER, RELATED, and more
  • Time intelligence: period comparisons, cumulative totals, rolling averages
  • Integrating relationship logic into DAX
  • Real-world calculation examples (e.g., ABC analysis)

5. Power BI Service: Management and Publishing

  • Scheduling and managing data refresh
  • Sharing reports and managing roles
  • Best practices for dashboard management