About the workshop

Power BI is an interactive data visualisation software developed by Microsoft, focusing on business intelligence and part of the Microsoft Power Platform. Organisations of all sizes and industries use it to consolidate data from various sources into a single dashboard, enabling the creation of interactive reports and visuals to identify trends and make informed decisions.

Building on the recent sucess of the Power BI foundations workshop we now advance to the next level.

This workshop is specifically crafted for professionals tasked with data extraction, analysis, visualisation, and the creation of recurring reports and dashboards. If their role involves ensuring accurate, up-to-date, and easily digestible information to initiate and support business decisions, this program is essential.

Intermediate Power BI Workshop

Crafting insights through complex data transformation

- Review basic data transformations and dive deeper into complex transformations

- Delve into Power Query formula language (M) for custom transformations

- Practical exercises in data cleaning, shaping and creating calculated columns

Fine-tuning Power BI data models

- Data modelling concepts

- Strategies for optimising data models for performance

- Explore query folding and query optimisation techniques

Optimising data insights with DA

- Deep dive into Data Analysis Expressions (DAX) language

- Intermediate DAX functions and concepts

- Practical exercises in writing complex DAX measures to answer specific business questions

Designing and customising your reports

- Exploring and creating custom layouts with json files

- Creating visualisations with custom layouts

- Hands-on exercises creating visuals


Going beyond basic charts with custom visuals

- Explore best practices for combining multiple visuals 

- Understand the power of maps and geolocation data

- Utilise forecasting and advanced analytics features to create comprehensive insights 

The importance of security and integration

- Learn how to protect data in Power BI with row-level and data-level security 

- Understand a user of roles and permissions in Power BI

- Integrate PowerBI with other applications

Master data visualisations

- Plan for and create strong visual content that will connect with your audiences

- Select and implement the most appropriate visualisations 

- Apply design principles to ensure dashboards are user-friendly enhance your dashboards

Enhanced dashboard design with storytelling techniques 

- Develop strategies to design captivating and impactful data stories 

- Bringing it all together with interactive storytelling practice

Tailor Your Training Experience

To make sure you get the learning solution that’s right for you, we offer different levels of tailoring to suit your needs. Choose from three levels of customisation:

1.Off the Shelf

Love what you see? Great! Choose this option to take one of our most popular courses and bring it in-house for your team. Includes a pre-course consult session with our facilitator to make sure we hit the mark, and deliver the right learning experience for you.


Make sure you get the most from the course you choose, by tailoring the content to get the right fit for you. Speak to our team, who will work with you to pick and mix from a curated bank of training modules to help customise your learning experience.


Not on the list? Let us know what you’re looking for and we will find the right solution. Our team of learning specialists will work with you to develop a unique training course for your business. Through an in-depth consultation process, we will work with you to profile your learning needs and build a bespoke program from the ground up.

Speak with one of our team today to find which option is right for you.

Who Will Attend

Anyone who wants to boost their skills in Power BI
- Business analysts
- Finance and accounting professionals
- Data analysts
- Data scientists

Find Out More

Request a call
Send enquiry

Upcoming Dates and Locations

Thank you for your enquiry, almost there! Please fill in the form so that we may best cater to your needs

Thanks for submitting your Enquiry! our team will be in contact with you shortly.

Thank you for joining us!

Great! Keep an eye out on our updates and newsletters.