Skip to main content

Home Specialist skills Data and Analytics Power BI Mastery: Advanced Analytics and Insights

Power BI Mastery: Advanced Analytics and Insights

  • bullet point
    Build and optimise advanced data models using star schema design
  • bullet point
    Write and apply advanced DAX calculations for complex analytical needs
  • bullet point
    Transform and shape data using Power Query and M language
  • bullet point
    Create dynamic and parameter-driven visualisations
  • bullet point
    Implement row-level security and manage access controls
  • bullet point
    Use Power BI Service features such as workspaces and deployment pipelines.

Overview

Off the shelf (OTS)

This course is designed for experienced Power BI users such as data analysts, report developers, and business intelligence professionals who want to deepen their understanding of complex modelling, advanced DAX functions, and dynamic reporting techniques.

Attendees should have prior experience with Power BI, including building basic reports and data models.

The Power BI Advanced Training Course builds on core Power BI knowledge and introduces more sophisticated capabilities for enterprise-level reporting. It covers advanced DAX, data modelling with star schemas, M language for complex transformations, and deployment strategies using the Power BI Service.

Key Topics Covered:
• Advanced DAX functions and time intelligence
• Complex transformations using Power Query and M
• Data modelling with relationships and star schema design
• Creating dynamic and parameter-driven reports
• Implementing row-level security and data governance
• Power BI Service features and workspace management

The course is delivered over three days and includes hands-on exercises throughout.

Delivery method
Virtual icon

Virtual

Course duration
Duration icon

21 hours

Competency level
Working icon

Working

Pink building representing strand 4 of the campus map
Delivery method
  • Virtual icon

    Virtual

Course duration
Duration icon

21 hours

Competency level
  • Working icon

    Working

chatbotSpark login – Alpha testing