Leveraging Power BI for Advanced Data Visualisation
Explore advanced data visualisation techniques through the lens of specific use cases, as Gustaw Dudek hosts a 1-day Masterclass diving deep into the ins and outs of interactive reports.
These techniques aim to enhance the efficiency of your reports and elevate storytelling to a new level. You'll navigate through report structure and UI components, including dashboard layout, navigation, and functional panels. The selection of charts will be discussed, along with an explanation of their applications.
What's more, Gustaw delves into a wide range of techniques utilising dedicated DAX applications, field parameters, conditional formatting, and other Power BI functionalities.
By participating, you will have the opportunity to explore a broad spectrum of possibilities for improving the front end of reportage in Power BI. This will increase the usability and clarity of the reports and dashboards you develop, making them more effective for business and non-business applications.
What you'll learn
- Power BI's vast range of visuals
- Best practices in reporting and storytelling
- Real-world examples
- Dashboard layouts, navigation, and functional panels
- DAX, field parameters, conditional formatting, etc.
This class will be delivered in-person at Fora - Chancery House, 53-64 Chancery Ln, London WC2A 1QS, UK.
This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.
Who is it for?
If you create Data Models in Excel or Power BI, then this Masterclass is for you.
- Business intelligence or analytics professionals
- Everyday Power BI users
- Users of other tools looking for advanced techniques and inspiration
- Managers aiming to improve their current reporting systems
Download Course Brochure
What's included?
-min.avif)
-min.png)
✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data
✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Training requirements
Basic knowledge of Power BI is recommended, although not essential. Power BI Desktop should also already be installed on your computer, and the practice files will be shared with you just before the event.
About the trainer
Gustaw Dudek
Gustaw Dudek is the Head Of Business Intelligence at Enterium. He has multiple years of experience in the field of data analytics. He implements and provides business reporting solutions for various industries using BI tools (Excel, Power BI). Gustaw is also one the Enterprise DNA Experts. He developed extensive Power BI Portfolio, which includes diversified array of financial reports and demonstrative dashboards created in the frames of international BI challenges.
What people think of
Gustaw Dudek
★★★★★
Gustaw and his gorgeous Power BI dashboards absolutely won my heart!
I could feel the way these dashboards were crafted to be elegant, neat, telling the right story for the right audience and being ready to respond to selections made by users, also equipped with drill down capabilities when useful. Follow Gustaw for mind-blowing dashboards and impeccable technique!
★★★★★
Thanks for a great session, Gustaw Dudek!
Loving all these PowerBI sessions at the Global Excel Summit!
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
Delve into Excel's advanced features with special in-depth sessions from Microsoft MVPs & experts. Designed to equip you with some of the most sought-after workplace skills.
September 2025
✔︎ 15 & 16 Sep | 18:00-21: 00 BST - Modern Data Analytics in Excel (with George Mount)
✔︎ 16 & 17 Sep | 9:00-12:00 BST - Budget and Forecast Modelling in Excel (with Danielle Stein Fairhurst)
✔︎ 18 & 19 Sep | 9:00-12:00 BST - Automate Your Month End in Excel (with Mark Proctor)
October 2025
✔︎ 9 & 10 Oct | 18:00-21:00 BST - Advanced Charting in Excel (with Ann K. Emery)
✔︎ 14 & 15 Oct | 18:00-21:00 BST - New Ways of Solving Problems in Excel (with Chandoo)
✔︎ 16 & 17 Oct | 09:00-12:00 BST - Power Query in a Day (with Wyn Hopkins)
And don’t worry if you miss one – everything is recorded, so you can catch up any time.
Instantly unlock 35+ hours of premium content from 7 expert-led courses, featured in our 2025 Special Edition May/June Masterclass series.
May 2025
✔︎ Financal Modelling with Dynamic Arrays (with Danielle Stein Fairhurst)
✔︎ Automate Your Month End in Excel (with Mark Proctor)
✔︎ Python in Excel for Enhanced Data Analytics (with George Mount)
✔︎ Building Interactive Data Visualisations (with Carlos Barboza)
✔︎ Automate Excel with Office Scripts and Power Automate (with Mark Proctor)
June 2025
✔︎ Advanced Formulas in Excel Beyond the Basics (with Alan Murray)
✔︎ Building Power BI Reports the Right Way (with Gašper Kamenšek)
The Global Excel Summit has been verified as a CPD-accredited event three years in a row. and so are our in-person and online Masterclasses. This serves as credible proof of its reputation as a premium event.
✔ Gain up to 6 CPD points per Masterclass
✔ Boost your standing in a fiercely competitive job market
✔ Receive a CPD certificate
Get Product
-min.avif){kind=logo}
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
