Self Service Business Intelligence Boot Camp (Munich, Germany)

27-29 October 2025

10:00–17:00 CET

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.

‍

FIRST 5 TICKETS AT 30% OFF!

Be among the first people to secure your place and take advantage of our 30% OFF offer.

‍

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, 19 and 22 May 2026 in London, UK.

Who is it for?

Anyone who needs to build reports based on data. Experience working with Excel PivotTables is highly encouraged. Experience with Power BI is optional.

Download Course Brochure

Download Now →

What's included?

Three days in-person training with Excel Guru Ken Puls

All working files

Lunch + Coffee, tea and biscuits throughout the day

Claim up to 21 hours of CPD (Continuing Professional Development) hours / points

One year of access to the online version of the Self Service BI Academy (including access to semi-monthly “Ask Ken Anything” sessions)

A free Monkey Tools Pro License and a free digital copy of Ken’s Master Your Data e-book

Certificate of attendance

100% money-back guarantee

Course contents

Click on the topics below to see exactly what you get as part of this package:

Training requirements

You must bring a laptop with both of the following installed:

Excel 2016 or higher (Office 365 recommended)
Power BI Desktop version 2.119.x (July 2023) or higher

‍

Notes on Software Requirements

1. Don’t have Excel 2016 or higher? You can sign up for a free one-month trial of Office 365 Business Premium. (Click here to learn more.)

2. If you are running Excel 2016, please go to Windows Update -> Advanced and make sure you’ve checked the box to receive updates for other products when you update Windows!

3. If you do not yet have Power BI Desktop installed, we recommend installing it from the Microsoft Store, as it stays up to date. To do this, press your  key, type “Store” and open the Microsoft Store App. Search for “Power BI Desktop” and choose to install it.

4. If you do have Power BI Desktop installed, but you are not automatically receiving updates, you can get the most recent version of Power BI Desktop here.

5. This course is taught on the Windows platform. Mac versions of Excel are not supported, and Power BI Desktop does not have a Mac version. (Running a Windows instance in a Fusion or Parallels is fine, but we cannot provide support to set this up, as we are not Mac users.)

About the trainer

Ken Puls, FCPA, FCMA

Ken Puls is a world-renowned business intelligence expert, author, blogger, and trainer. Before stepping into Excelguru Consulting Inc. full time in May 2015, Ken spent over twenty years working in public practice accounting and industry as both Controller and an IT Director.

Awards & Recognition

Ken is regarded as one of the world’s leading experts in Microsoft Excel, Power Query, and Power BI. In recognition of his contributions to the online community Ken has been recognized with the prestigious Microsoft Most Valuable Professional award every year since 2006. In 2013 Ken was also recognized as one of the “Top 20 Under 40” Business and Community Leaders on Vancouver Island, and in 2014, he was also recognized as a Fellow in the CMA Society, an honour given to less than 2% of CMA’s in their lifetime.

What people think of

Ken Puls, FCPA, FCMA

★★★★★

This course completely transformed the way I use the software!

I am a daily Excel user for over 10 years. This course completely transformed the way I use the software. It has improved my efficiency, enabled me to solve problems that I didn't know was possible, and opened doors for my career. Overall, I highly recommend this course. Thank you Ken Puls!

Stephen Ng

★★★★★

I've highly recommended it to others already.

This course is a complete end-to-end exploration of Power BI, including data modeling, reporting, integrating with Excel, improving performance, and building usable reports and dashboards. Very thorough while remaining approachable for new users. I've highly recommended it to others already.

Ken Muse

Full product details:

Click on the topics below to see exactly what you get as part of this package:

Get Product

Please submit proof of student status before proceeding to checkout.

Thank you! Your file has been attached successfully.

Oops! Something went wrong while attaching your file. Please try again.

If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com

Type of Ticket

Reserve Your Spot!‍
Cancel or pay full price by 1 October 2023.

Total (incl. VAT):

SAVE 30% - Early bird

£ 945.00 GBP

£ 1,350.00 GBP

✔︎ Recordings and downloadable files included
✔︎ CPD Certificate of attendance included
✔︎ Free cancellation up to 30 days prior to the event

✔︎ 2 Masterclasses included
✔︎ CPD Certificate of attendance included
✔︎ Free cancellation up to 30 days prior to the event

✔︎ 1 Masterclass included
✔︎ CPD Certificate of attendance included
✔︎ Free cancellation up to 30 days prior to the event

✔︎ 30% Early Bird discount expires on 30 June 2025 at midnight (BST).
✔︎ Free cancellation before 15 August 2025.
✔︎ Event Recording and all speaker files included.

Run this Course In-House

✔︎ 30% Early Bird discount expires on 31 July 2025 at midnight (BST).
✔︎ Free cancellation before 15 September 2025.
✔︎ Event Recording and all speaker files included.

Run this Course In-House

✔︎ CPD-accredited by CPD Standards Office.
✔︎ Event Recording and all speaker files included.
✔︎ Join from anywhere in the world.

Run this Course In-House

Quantity:

Join the Master Club

Your exclusive all-access pass to our entire digital learning experience for a whole year.

Join the Master Club