Self Service Business Intelligence Boot Camp (Munich, Germany)

Prepare to change your company’s reporting game forever, as 18x Microsoft MVP Ken Puls joins us in Munich for a 3-day exclusive Self-Service BI boot camp.

We know that data is not usually stored in nicely curated databases. And often — even when it is — the data analyst doesn’t have access to it. Instead, we must piece together data provided in text files, Excel files, web pages, and even the body of emails to build the business intelligence solutions we need. Until now this has been a painful process. That stops with this workshop!

The Self-Service BI Boot Camp begins with a deep exploration of Power Query. Built into Excel and Power BI, you'll learn to use it for cleaning, reshaping, and combining data with ease. Converting ASCII files into tables, combining multiple text files in one shot, and even un-pivoting data is not only simple, but an investment in the future, as you step closer to creating dynamic business intelligence models that are refreshable with a single click.

Next, we'll dive into Dimensional Modelling, which is based on the Power Pivot Data model and used to design and link parent tables correctly. You'll learn key Power Query patterns to solve common table relationship challenges.

Finally, get stuck into DAX, a powerful formula language for creating advanced measures, as well as calendar intelligence for year-end reporting.

Throughout this 3-day workshop, you’ll be working with both Excel and Power BI. Why? Because the tools and concepts you’ll be learning work in both places. So how do you know which one is right for the job?

‍

What you'll learn?

• Excel Pivot tables
• Importing Data with Power Query
• Creating Table relationships with the Data Model
• Dimensional Modelling
• Introduction to DAX formulas
• Calendar Tables
• Calendar intelligent measures
• Dashboarding with Power BI
• Excel vs Power BI use cases

‍

Time Commitment

This course is a hands-on course and runs over 3 days. Each day will run approximately 7 hours in length, depending on the class size and attendees’ experience in working with the tools.

‍

Pricing

• Early bird (20% OFF) offer ends on 31 July 2025 at 23:59 BST.
• To pay by invoice, please contact us at info@globalexcelsummit.com. We will send you an invoice which you can submit to your accounts payable system.

‍

‍

This 3-day course will be delivered in-person in Munich, Germany on 27, 28 and 29 October 2025. I will also be delivered on 18, 21 and 22 May 2026 in London, UK.