Contents
The basics of the Business Intelligence (BI) tool "Power BI"
- Presentation of the individual components of Power BI: The ETL process Power Query, the data model with DAX, visuals and the sharing of reports via the Power BI web service.
- The differences and advantages and disadvantages between Power BI solutions and Excel solutions.
- Introduction to the basic principles of Power BI using Excel: "Format as table" and analyze data with "Pivot table incl. data slices".
- BI terms such as dimensions, facts, measures, etc. explained in an understandable way.
The ETL process within Power BI: Extracting and transforming data from different sources
- Import of data from external sources such as Excel and CSV files, web data, etc.
- The query editor and its advantages.
- Import more than 1 million data records.
- Append data from several tables to each other.
Data visualization with Power BI using practical examples
- Visualization of e.g. temporal progressions with line and bar charts.
- The "Card" visual for visualizing individual numbers.
- The "Matrix" visual with its various settings.
- Interact with data (data section, filter and cross filter).
- From the rough to the detailed - using drill-through hierarchies.
- Integration of external visuals.
Importance of the data model
- The necessity and usefulness of the Star Scheme.
- Combine tables into a data model.
Share reports in the Power BI (web) service
- Set up workspaces.
- Differences between direct sharing and via app.
Please bring your own laptop to the training . You can find more detailed installation instructions under Methods.
Learning environment
Your benefit
- You know the most important terms and use cases of Power BI Desktop and can implement this knowledge in your company.
- You will learn how to create data models and hierarchies with Power BI and how to prepare dynamic reports.
- You will get to know the most important transformation steps of the ETL process within Power BI and apply them using an example.
- You know the basic operation of Power BI.
Methods
Presentation, practical examples and independent exercises on the PC, sample solutions, tips and tricks.
Due to the workshop nature of the seminar, questions, tasks and your own suggestions for solutions are very welcome and practical relevance is guaranteed.
You will need your own laptop to participate.
Please observe the following installation instructions:
Microsoft Excel (Office 365 is recommended) and with integrated Power BI (free version is sufficient).
Recommended for
controllers and user:in from other areas who want to import, process, analyze and visualize large amounts of data from different sources.
A good basic knowledge of MS Excel is required for the training . The training is not suitable for Excel newcomers . No prior knowledge of Power BI necessary.
Further recommendations for "Power BI: The modern business intelligence tool"
Attendees comments
"PowerQuery mega! Very good approach and preparation of the topics. Structure of the topics very well explained with examples. In addition, relaxed approach and super exciting preparation. Sympathetic presentation style."

"I was able to take away a lot. The speaker was very knowledgeable and responded to the needs of the participants."

"The webinar was convincing due to the very good content and the speaker Johannes Curio. Absolutely recommendable!"

"I particularly liked the fact that the trainer responded to questions and took time for each participant."

"I found the course very informative, the days were well structured and the lecturer was very competent. I can recommend the quality of the training and the amount of content that was taught."

"Very competent and humorous communication of the content. The 2 days were very entertaining!"

"I liked the detailed and appropriate introduction to the tool."

"The interactivity and flexibility of the trainer were very good. Problems were explained simply."

"There were good explanations, lots of examples and opportunities to practise."

"I particularly liked the scope, the appropriate speed and the individual approach to questions. Simply an all-round successful training."

"Practical, good workshop character and a nice atmosphere."

"I liked the common thread and the practical examples."

"The way in which the complex topic was conveyed in a competent and entertaining manner was particularly impressive. Johannes Curio is a great trainer on this topic!"

"I liked the overview of all the functions and the engaging manner of the trainer! His relaxed manner was very engaging for the participants and he has great specialist knowledge. He also responded very well to all questions and provided examples. Full marks."

"I really liked the topics of data modeling and transformation."

"My expectations were met and I can take some things with me into practice. I particularly liked the interactive nature of the training and the practical examples."

Seminar evaluation for "Power BI: The modern business intelligence tool"







Excel has become a powerful tool and can also cope with complex requirements. The sister system PowerBI Desktop (PBID) has been available since 2013. We will show you which solution approaches you can take from Excel to PowerBI and how you can also go beyond the limits of Excel with PBID. These two programs become an unbeatable team in controlling.
PBID enables you to complete your controlling tasks faster and more efficiently. You can retrieve data from almost any source, such as databases, CSV files, etc., insert it, have it automatically transformed and display it graphically in dashboards in a matter of seconds. Many Excel users also want to import the data prepared in Excel into PBID for further processing. This is also possible.
PowerBI's visuals make it easy to present data and evaluations in an appealing way in order to create meaningful reports, charts and data analyses. These reports can be shared with employees and other organizations and can then be changed or redesigned by users on a multivariate basis. If required, this can even be done using mobile devices such as tablets or smartphones.
30196
Start dates and details

Wednesday, 04.06.2025
09:00 am - 5:00 pm
Thursday, 05.06.2025
09:00 am - 5:00 pm
Thursday, 05.06.2025
09:00 am - 5:00 pm
Friday, 06.06.2025
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 16.06.2025
09:00 am - 5:00 pm
Tuesday, 17.06.2025
09:00 am - 5:00 pm

Tuesday, 01.07.2025
09:00 am - 5:00 pm
Wednesday, 02.07.2025
09:00 am - 5:00 pm
Monday, 14.07.2025
09:00 am - 5:00 pm
Tuesday, 15.07.2025
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Thursday, 24.07.2025
09:00 am - 5:00 pm
Friday, 25.07.2025
09:00 am - 5:00 pm

Monday, 11.08.2025
09:00 am - 5:00 pm
Tuesday, 12.08.2025
09:00 am - 5:00 pm
Thursday, 11.09.2025
09:00 am - 5:00 pm
Friday, 12.09.2025
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 29.09.2025
09:00 am - 5:00 pm
Tuesday, 30.09.2025
09:00 am - 5:00 pm

Monday, 06.10.2025
09:00 am - 5:00 pm
Tuesday, 07.10.2025
09:00 am - 5:00 pm
Tuesday, 21.10.2025
09:00 am - 5:00 pm
Wednesday, 22.10.2025
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 10.11.2025
09:00 am - 5:00 pm
Tuesday, 11.11.2025
09:00 am - 5:00 pm
Tuesday, 25.11.2025
09:00 am - 5:00 pm
Wednesday, 26.11.2025
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Thursday, 04.12.2025
09:00 am - 5:00 pm
Friday, 05.12.2025
09:00 am - 5:00 pm
Monday, 15.12.2025
09:00 am - 5:00 pm
Tuesday, 16.12.2025
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Tuesday, 20.01.2026
09:00 am - 5:00 pm
Wednesday, 21.01.2026
09:00 am - 5:00 pm
Thursday, 05.02.2026
09:00 am - 5:00 pm
Friday, 06.02.2026
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 23.02.2026
09:00 am - 5:00 pm
Tuesday, 24.02.2026
09:00 am - 5:00 pm
Tuesday, 03.03.2026
09:00 am - 5:00 pm
Wednesday, 04.03.2026
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 09.03.2026
09:00 am - 5:00 pm
Tuesday, 10.03.2026
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.