+44 (0) 2080 049141info@londonittraining.co.uk

LONDON IT TRAINING

Find your next course

Explore our training courses by subject, skill or certification.

All courses

Classroom · Live online · Training for teamsFind the right course for your next step.
  1. Home
  2. »
  3. Power BI Advanced
Instructor-led training
Power BI Advanced Training in London and Live Online

Power BI Advanced

Optimise Power BI semantic models, DAX and report performance. Design secure, maintainable analytics solutions and plan controlled deployment and monitoring.

Request Course Information
Price:
Price on request

Contact us for current fees, dates and exam arrangements.

Advanced

Have experience with Power Query, star schemas and DAX measures.

5 days to complete
Available online
& in class

Select your preferred method

Course overview
Course dates
  • In Classroom
  • Live Virtual
  • 1 - 1 Training
  • Corporate Training
  • Onsite Training
Introduction
Optimise Power BI semantic models, DAX and report performance. Design secure, maintainable analytics solutions and plan controlled deployment and monitoring.


This instructor-led course combines clear explanations with guided exercises and practical scenarios. Work through examples relevant to the subject, review alternative approaches and practise checking your results rather than relying on a demonstration alone.
You will develop a structured approach to implementation, troubleshooting and documentation. The trainer can adapt examples to the agreed learning needs and available training environment. Confirm the course duration, software or lab requirements, delivery arrangements and fees with London IT Training before booking.
This is professional development training. It does not automatically award a third-party vendor certification.
What the course covers
Flexible Ways to Learn

Study your way with flexible learning options designed to fit around your schedule.

Small Groups

With small groups of students, our instructors can work closely with each student

Flexible Class Schedules

Our class schedules are flexible on weekdays, weekend or evening to suit your schedule.

Experienced Instructors

Our instructors follow a modified and personalised approach to engage students during class

Hi-Tech lab Facilities

Lab arrangements vary by course. Confirm access and equipment requirements before booking.

Prerequisites
What you’ll gain

Apply semantic model architecture in a practical course exercise.

Apply advanced dax patterns in a practical course exercise.

Apply performance diagnosis in a practical course exercise.

Apply data preparation and refresh design in a practical course exercise.

Develop skills for your next step
Relevant career pathways
Technical Practitioner:

Apply the course skills to relevant technical tasks.

Technical Consultant:

Assess requirements and recommend practical implementation choices.

Syllabus

Course context and practical foundations
Review the course objectives and relevant concepts. Set up a suitable training environment, identify a realistic example and agree how to validate the results.

Evaluate storage and modelling choices, relationship design and reusability. Balance analytical requirements with maintainability.

Use iterators, variables and explicit filter control. Evaluate totals, ranking and context transitions carefully.

Use appropriate analysis tools to investigate visual, query and model bottlenecks. Reduce unnecessary complexity and data volume.

Review query folding, incremental refresh considerations and reliable preparation pipelines. Match the design to the source system.

Plan row-level and object-level security where available. Document ownership, access, lineage and review responsibilities.

Manage changes, validation, release stages and monitoring. Identify feature and licence requirements before implementation.

Complete an integrated exercise using sample data or an isolated training environment. Test the result, document decisions and troubleshooting steps, and identify improvements and next learning objectives.

1
2
3
4
5
6
7

FAQs

Who is this course for?
Optimise Power BI semantic models, DAX and report performance. Design secure, maintainable analytics solutions and plan controlled deployment and monitoring.

Have experience with Power Query, star schemas and DAX measures. Understand refresh and report publishing in Power BI. Confirm access to any required licensed service features.

Semantic model architecture; Advanced DAX patterns; Performance diagnosis; Data preparation and refresh design; Security and governance; Deployment and operations.

No. This is professional development training. It does not automatically award a third-party vendor certification.

Contact London IT Training to discuss classroom, live online and corporate delivery arrangements.

Contact the training team for current duration, available dates, fees and software or lab requirements. Do not assume that licences, materials or examination fees are included.

Need help choosing the right course?

Talk to one of our advisers about dates, delivery options and certification routes. We’ll call you back within 1 working day.

LONDON IT TRAINING

Let’s plan
your next step.

Tell us what you would like to learn.

  • Course guidance
  • Dates and delivery
  • Training for teams

Your details are used to respond to your enquiry. Privacy Policy