Power BI Intermediate

Building upon the foundational knowledge gained in the basic training, this course teaches participants to delve deeper into the capabilities of Power BI.

*Please contact us for the course schedule.

Course Objectives

You will learn how to optimise data models for performance and scalability, write advanced DAX formulas to solve complex analytical problems, and design compelling visualisations that effectively communicate insights to stakeholders. Additionally, you will discover advanced features of the Power BI Service, such as data integration, security settings, and sharing options.

With hands-on exercises, real-world examples, and expert guidance, this training will empower you to leverage the full potential of Power BI and elevate your data analysis capabilities.

Course Content
  • Advanced Data Modelling: Creating relationships between tables, defining measures, and calculating columns.
  • DAX (Data Analysis Expressions): Introduction to DAX functions for advanced calculations and analysis.
  • Advanced Visualisations: Creating custom visuals, using slicers, and implementing drill-down functionality.
  • Power BI Service: Publishing reports to the Power BI Service, scheduling data refresh, and managing workspaces.
  • Data Integration: Integrating data from cloud services, APIs, and live data sources.
  • Advanced Querying Techniques: Writing advanced queries using Power Query M language.
  • Advanced Sharing and Collaboration: Setting up row-level security, creating and managing apps, and sharing reports externally.
Course Information

Format: Online, Instructor-led using a combination of demonstrations and scenario-based hands-on exercises
Duration: 2 Days
Target Audience: Super Users, Business Analysts, Developers, Data Architects
Cost: R6,300 excl. VAT (RSA) / £300 (UK) per person

If you’d like to attend, please register your details below and we will contact you:

Power BI Intermediate