Master complex DAX, performance tuning and automation to build secure, scalable, enterprise level Power BI reporting solutions.
2 day course 10am - 5pm Live Online or Classroom-based
What you will learn
- Understanding how to design enterprise-level data models, enabling you to build robust, high-performance reporting systems for large organisations.
- Exploring complex DAX techniques, empowering you to create sophisticated calculations that deliver precise results for critical business metrics.
- How to optimise model performance through query folding and aggregations, helping your dashboards load faster and operate more efficiently.
- Mastering advanced Row-Level Security settings, enabling you to manage data access confidently and maintain compliance in professional environments.
- How to enhance visual storytelling with corporate themes and AI-powered visuals, transforming dashboards into insightful business communication tools.
- Integrating Power BI across Teams, SharePoint and cloud platforms, allowing seamless collaboration and automated report sharing within wider workflows.
- How to implement governance and deployment pipelines, helping teams version-control reports safely and streamline enterprise-wide analytics publishing.
- Working through a real-world project challenge, reinforcing advanced modelling, automation and security skills that enhance professional capability immediately.
Related Courses
This Power BI Advanced course includes
-
Authorised Certificate
-
Lifetime support after your course
-
Course materials
-
Live Instructor-led training
-
Refreshments all day
-
Latest Mac or PC ready to go
-
Authorised Trainers
-
Hands-on exercises
Book this course
We offer Power BI Advanced as a private course.
You can select a date which suits you or your team.
The course content can be fully customised to your exact learning requirements.
Request datesCourse Outline for Power BI Advanced
Advanced Data Architecture and Integration
- Implementing composite and incremental data models
- Using DirectQuery vs Import mode strategically
- Managing performance through data view options
- Integrating cloud and on-premises sources via gateways
Mastering Complex DAX
- Working with virtual tables and context transition
- Creating advanced filters using CALCULATE, SUMMARIZE, ADDCOLUMNS
- Leveraging SWITCH, SELECTEDVALUE and dynamic titles
- Building dynamic security expressions for Row-Level Security (RLS)
Performance and Optimisation
- Understanding query folding and its impact
- Using Performance Analyser and DAX Studio
- Optimising datasets and refresh strategies
- Managing large models with aggregations
Enterprise Design and Visual Excellence
- Applying corporate branding, themes and templates
- Developing user-driven reports with parameters
- Using AI visuals: Key Influencers, Decomposition Tree and Smart Narrative
- Creating app-based dashboards with advanced navigation
Automation and Integration
- Using Power Automate to schedule report distribution
- Embedding Power BI in Teams, SharePoint and external web portals
- Creating data-driven alerts and automated tasks
Governance, Security and Deployment Pipelines
- Implementing RLS and sensitivity labelling
- Managing workspaces, model versioning and access control
- Publishing enterprise reports via deployment pipelines
Class Project
- Designing an enterprise-scale report system incorporating advanced DAX, automation and security best practices
FAQs about the Power BI Advanced course
Is this Power BI Advanced course suitable for me?
This course is designed for people who have experience in Power BI or have already attended one of our Power BI training courses or who would like to further their knowledge of best practice in the use of Power BI. If you are have any questions about whether the course could meet your needs, please speak to our customer service team, who will be delighted to advise you.
How is the content taught throughout the Power BI Advanced course?
Our Power BI Advanced course is extremely interactive. You will be using Power BI throughout the day, working through examples and live projects under the guidance of our trainer, who will be inviting questions and supporting you through each step.
How many people are likely to be in the class when I attend the Power BI Advanced course?
For private classes in Power BI Advanced, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.
Should I attend the Power BI Advanced course in person or live online?
For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.
What support is available after I attend the Power BI Advanced course?
We offer ongoing support to our Power BI Advanced course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.
Will I receive a certificate upon completion of my Power BI Advanced course?
Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our Power BI Advanced course. Our certificates note our Authorised Training Centre status.
Power BI Advanced — Team and Bespoke Training
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Book NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Book Now
Our Clients
Latest Blog Articles
From Static to Dynamic: Transforming Your Designs with After Effects
Which Text-AI Should You Use for Your Business?
Easy Motion Graphics Using LottieLabWhy Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact requirements.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.