The BI Analyst combines structured data analysis with insightful reporting.
In this training course, you will gain a solid understanding of SQL and learn how to effectively visualize data in Power BI. As a result, robust data models are created to serve as the basis for reports, dashboards, and informed decisions.
What to ExpecT
- Introduction to relational databases and structured data analysis with SQL
- Querying, linking, and processing business data from multiple sources
- Best practices for data quality, structure, security, and performance
- Introduction to Power BI, Power Query, and data modeling
- Creating interactive reports and dashboards based on structured data
- Practical exercises for immediate application in everyday work
- Blended learning
-
44h / 11 sessions
(2 sessions of 4h/week) - EUR 3,900 plus 19% VAT
LEARNING OBJECTIVES
After completing this training, you will be able to
- understand relational databases and use them effectively for analysis;
- use SQL queries to perform structured analysis of business data;
- logically link data from multiple sources and prepare it consistently;
- provide cleaned data models as a basis for reporting;
- create and publish interactive reports and dashboards using Power BI.
Target group & Prior Knowledge
This training is designed for everyone who wants to not only visualize data, but also organize and analyze it in a structured way. If you are working in a department such as Controlling, Accounting, and Operations, or a related business role, you will particularly benefit from the combination of SQL-based analysis and Power BI reporting.
No in-depth prior technical knowledge is required to participate. A basic interest in working with data and some initial experience with Excel or reports are helpful but not mandatory.
Training Content at a Glance
Relational Databases and SQL Basics
- Structure of a relational table
- Basic SQL commands and queries
- Conditional queries and sorting
- Simple calculations with SQL
Aggregation, Subqueries and Joins
- Aggregate functions in SQL and conditional queries
- Nested queries
- Correlation in subqueries
- Joining tables
- Nested joins and subqueries
Views and Window Functions
- Using views as stored queries
- Introduction to window functions
Normalization and Security
- Introduction to normalization
- Database security (e.g., user rights and roles)
- Encryption and data protection in relational databases
Power BI Basics
- Importing files and the Power Query interface
- Transformations
- Views and the Power BI interface
Visuals and Data Modeling
- Visuals, filters, and more
- Getting started with DAX
Reports
- Bookmarks, buttons, and page navigation
- Creating a report
- Publishing a report
Program DATES
- 8 Sep 2026 – 13 Oct 2026
- Live Sessions (duration: 4h)
- Tue, 8 Sep 2026, 8:30 – 12:30
- Thu, 10 Sep 2026, 8:30 – 12:30
- Tue, 15 Sep 2026, 8:30 – 12:30
- Thu, 17 Sep 2026, 8:30 – 12:30
- Tue, 22 Sep 2026, 8:30 – 12:30
- Thu, 24 Sep 2026, 8:30 – 12:30
- Tue, 29 Sep 2026, 8:30 – 12:30
- Thu, 1 Oct 2026, 8:30 – 12:30
- Tue, 6 Oct 2026, 9:00 – 13:00
- Thu, 8 Oct 2026, 9:00 – 13:00
- Tue, 13 Oct 2026, 9:00 – 13:00
- Live Sessions (duration: 4h)
Further dates are being planned.
PRICE PER PERSON
- EUR 3,900 excl. VAT