No items found.

Leveraging Power BI for Advanced Data Visualisation

3 February 2025
10:00–17:00 GMT
Central London, UK

What to expect?

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 in central London, 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

Full Course Brochure

Download Now →

What's included?

Check Icon
One day in-person training with Power BI guru Gustaw Dudek
Check Icon
Claim up to 6 hours of CPD (Continuing Professional Development) hours/points
Check Icon
All working files
Check Icon
Coffee, tea and biscuits throughout the day
Check Icon
Certificate of attendance
Check Icon
100% money-back guarantee
Check Icon
Missing Item
Missing Item
Missing Icon
Missing Icon
Check Icon
Missing Item
What you'll learn?
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Data profiling with Power Query

✔︎ What is “extract, transform, load,”?
✔︎ We’ll look at how this process works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data.

Right Arrow Icon
Efficient reporting with Power Pivot

✔︎ How do you avoid memory-draining “Frankentables” and build relational data models and reports right from Excel?
✔︎ We’ll look at Power Pivot and DAX for data analysis in Excel

Right Arrow Icon
Efficient analysing with dynamic array functions

✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.

Right Arrow Icon
Augmented analytics and the future of Excel

✔︎ Where is data analytics headed, and can Excel keep up?
✔︎ Learn how to use predictive analytics and artificial intelligence inside and outside of Excel to make the most of your data

Right Arrow Icon
Interfacing with Python

✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn how to automate boring processes with Python
✔︎ Learn how to build compelling analyses with this programming language

Right Arrow Icon
6x expert-led Masterclasses
Course content
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
Lesson 1 - Getting Started with Power Query

✔︎ What is Power Query?
✔︎ Basic data loading
✔︎ Power Query editor overview
✔︎ Type of values


Right Arrow Icon
Lesson 2 - Data Transformation Fundamentals

✔︎ Exploring queries and steps
✔︎ Basic data cleaning and transformation (removing columns & rows, filtering data, sorting, etc.)
✔︎ Practical example


Right Arrow Icon
Lesson 3 - Transforming Data in Real Life

✔︎ Removing duplicates and handling nulls
✔︎ Text transformation
✔︎ Date and time values
✔︎ Query load
✔︎ Practical example


Right Arrow Icon
Lesson 4 - Beyond Basic Data Transformation

✔︎ Data aggregation
✔︎ Merging and appending queries basics
✔︎ Different options for adding columns
✔︎ Pivoting and unpivoting data
✔︎ Practical example


Right Arrow Icon
Summary and Q&A

✔︎ Key takeaways
✔︎ Addressing frequently asked questions
✔︎ Interactive Q&A session


Right Arrow Icon
6x expert-led Masterclasses

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

Profile Pic

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!

Mihaela Stancu

Managing Owner and Trainer, Data Management by WOW Factor Concept

★★★★★

Thanks for a great session, Gustaw Dudek!

Loving all these PowerBI sessions at the Global Excel Summit!

Ann K Emery

Data Visualization Designer, Depict Data Studio
Full ticket details:
Click on the topics below to see exactly what you get as part of this package:
Right Arrow Icon
3x Expert Masterclasses

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

Right Arrow Icon
Tech & Innovation Track

Check out the introductory keynotes from Microsoft and world-renowned MVP Leila Gharani. Software developers showcase add-ins that transcend Excel's limitations, plus robust panel discussions and expert insights complete the Tech & Innovation Track!

✔︎ Keynote by Microsoft: Transforming Excel through research and AI
✔︎ Keynote by Leila Gharani
✔︎ Actionable Data Storytelling in Excel with Zebra AI
✔︎ AI: Sorting fact from fiction
✔︎ Python in Excel: First Steps
✔︎ Teaching Excel with AI
✔︎ Is AI taking over the role of the data analyst?
✔︎ How to build re-usable Excel automations with AI
✔︎ Empowering learners to Excel with digital skills certifications
✔︎ Kids meet spreadsheets
✔︎ Corporate charts inspired by social media
✔︎ ChatGPT: Match Made in Heaven or Hell..?
✔ Turn Excel models into Web apps: features, sharing, monetization
✔ Panel discussion: The future of Excel in an AI world
✔ Panel discussion: Does being Excel-certified matter?

Right Arrow Icon
Finance & Accounting Track

Harness the power of Excel and Power BI for budgeting, forecasting, and modelling. You'll master dashboards, P&L statements, and learn to build bullet-proof models that won't disintegrate!

✔ Client's perspectives on quality — lessons from a career in financial modelling and what that means for the future
✔ Dynamic Arrays - A financial modelling game changer
✔Upgrading financial modelling — how, who, and why?
✔ Fivecasting: One Better than Forecasting
✔ A bank’s perspective on Excel and AI

Right Arrow Icon
Data Visualisation & Analytics Track

Showcase your data with insightful visuals and learn the secrets of presenting it for effective communication. You'll also create custom charts, intuitive analytic experiences, and write DAX expressions for true flexibility!

✔ Is this an Excel chart?!? - 5 ways to take your boring charts to the NEXT Level
✔ Interactive Data Visualisation for decision support using Excel
✔ How to create an intuitive analytic experience in Excel using Script Labs
✔ Dynamic dashboard creation for KPI reporting using Power BI

Right Arrow Icon
The Power Stack Track

Expand your understanding of Power Query, Power Pivot, Power BI, and Power Automate. You'll arm yourself with the latest time-saving functionalities, powerful visualisations & expert techniques.

✔ Why use Power Query to solve practical data cleaning problems?
✔ 5 Things every Excel user should know about Power BI
✔ Using Git in Power BI for effective teamwork and version control
✔ Overcoming real-world problems with Power BI
✔ Power Query on Excel for Mac

Right Arrow Icon
Formulas & Automation Track

Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!

✔ Optimising the Monetisation of Spreadsheets
✔ LAMBDA - There is no stopping you
✔The *NEVER SEEN* Tips & Tricks by Bob Umlas
✔ Converting spreadsheets into web apps; 3 apps in fifteen minutes
✔ 5 ways for analysts to leverage 'Analyze Data’ in Excel
✔Combine Data in Excel Like A Pro
✔ Why VLOOKUP when there is Power Query?

Right Arrow Icon
3x Masterclasses

Discover the Excel hacks and best practices that empower you to do more with less. Whether it's formulas, keyboard shortcuts, or named ranges, you'll turbocharge your workflow!

✔ Excel Analytics 2.0 with George Mount
✔ Designing and Building Interactive Dashboards in Excel with Ann K. Emery
✔ Advanced Data Cleaning Using M in Power Query with Chandeep Chhabra

Get Ticket

Please submit proof of student status  before proceeding to checkout.
Max file size 10MB.
Uploading...
fileuploaded.jpg
Upload failed. Max size for files is 10 MB.
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
Only 3 tickets left
Total (incl. VAT):
SAVE 30% - Early bird
SAVE 20% - Early bird
SAVE 30% - EARLY BIRD TICKET
£ 315.00 GBP

£ 450.00 GBP

✔︎ Free cancellation before 4 January 2025
✔︎ 30% Early Bird discount applied
✔︎ Recordings and downloadable files included
✔︎ Free cancellation before 4 January 2025
✔︎ 30% Early Bird discount applied
✔︎ Switch to a different class if you change your mind
✔︎ 20% Early Bird discount expires on 31 Jan 2024 at midnight.
✔︎ Free cancellation before 18 Feb 2025.
✔︎ Adigital copy of Kenny's best-selling Financial Modelling Handbook included.
An icon that shows a camera or video.
Expert Footage: 13 hours
An icon that shows a camera or video.
Expert Footage: 34+ hours
An icon that shows a camera or video.
Expert Footage: 21+ hours
An icon that shows a lock.
Access to all speaker files
An icon that shows a star.
Watch any time, from anywhere
An image that shows CPD accreditation.
CPD accredited content
Calendar Icon 22 June
3 February 2025
Schedule Icon - Time
10:00–17:00 GMT
Location Icon
Central London, UK
Level icon
Level:
Money back guarantee
Money back guarantee
3 February 2025
10:00–17:00 GMT
Central London, UK

Beat the rush: Early Bird bargains!

Enjoy incredible Early Bird discounts of up to 30% on Global Excel Summit 2025 conference tickets and exclusive Masterclasses.

Get Early Bird Tickets
Close Cookie Popup
Cookie Preferences
By clicking “Accept All”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage and assist in our marketing efforts as outlined in our privacy policy.
Strictly Necessary (Always Active)
Cookies required to enable basic website functionality.
Cookies helping us understand how this website performs, how visitors interact with the site, and whether there may be technical issues.
Cookies used to deliver advertising that is more relevant to you and your interests.
Cookies allowing the website to remember choices you make (such as your user name, language, or the region you are in).