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 DAX

- 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