Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Days

* Price is exclusive of VAT.

Tell Me More






First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

Testimonials

South Norfolk Council

"I found the training very engaging, and very well explained with each exercise which was shown. answered any questioned which was asked throughout which was brilliant and very helpful "

AMS Nuclear Engineering Ltd

"I thought the training was good and gave me some helpful tips and best practices to continue my journey in learning power bi. not too fast or slow paced and i was able to go back and ask questions if i needed further clarification"

Next

"Simon was absolutely brilliant in his Power BI training, demonstrating an incredible depth of knowledge and making even the most complex concepts feel easy to understand"

Ridgeway Technologies

"Simon was a brilliant teacher. He answered everything we needed to know & explained things well. As a beginner, there were some things that I did not quite understand but I am hoping we can book some additional training for my level. Cheers, Simon!"

Take this Power BI course in other locations

Fancy taking this Power BI course at a location near you? Below are a few of our selected locations.

View this course in all locations

Microsoft Power BI Intermediate Training Course Intermediate

Intermediate Microsoft Power BI Intermediate Course Overview

Unlock deeper business insights and more advanced reporting capabilities with our Intermediate Power BI Training Course. Designed for delegates who already have a basic understanding of Power BI, this hands-on course will help you build more sophisticated reports, improve your data models, and create interactive dashboards that communicate information more clearly.

Throughout the course, you will explore advanced Power Query techniques, improve the way information is structured and connected, and work with DAX calculations to create more powerful analysis and reporting solutions. Delegates will also learn how to design more dynamic visualisations and optimise reports for better usability and performance.

Perfect for Microsoft 365 professionals, analysts, and reporting teams, this course helps delegates move beyond basic dashboards and develop the skills needed to create more advanced Power BI solutions for real business scenarios.

What You'll Learn in Power BI Intermediate

  • Using Advanced Power Query Techniques - transform, clean, and prepare larger sets of information more efficiently.
  • Optimising Data Models - improve relationships and create calculated columns for better reporting and analysis.
  • Building Interactive Visualisations - create more dynamic dashboards and reports using advanced visual features.
  • Using DAX Calculations - apply DAX formulas to create custom calculations and deeper business insights.
  • Publishing and Sharing Reports - manage, publish, and share reports more effectively using the Power BI Service.

Course Duration: 1 Days

Course Prerequisites

To help you get the most from this intermediate Power BI course, we recommend that delegates already have:

  • Basic Power BI Experience - confidence creating simple reports, charts, and visualisations within Power BI.
  • Familiarity with Data Analysis Tools - experience working with Microsoft Excel or similar tools for organising and analysing information.
  • Understanding of Basic Reporting Concepts - familiarity with tables, filters, and basic reporting workflows will help delegates progress more comfortably through the course.

If you're unsure whether this intermediate course is right for you, you may wish to review the topics covered in our Power BI Beginners Training Course.

Complete Course Outline

Advanced Data Integration and Modelling in Power BI

  • Advanced Data Integration Techniques
    • Connecting Multiple Data Sources - combine information from different systems and files within a single Power BI report.
    • Working with Larger Datasets - understand techniques for managing and analysing larger volumes of information more efficiently.
  • Optimising Data Models
    • Understanding Relationships and Cardinality - improve data models using more advanced table relationships and modelling concepts.
    • Using Calculated Columns and Measures - create calculations that improve reporting flexibility and analysis.

Creating Advanced Visualisations

  • Advanced Visual Customisation
    • Applying Conditional Formatting - highlight trends, targets, and key values automatically within reports.
    • Using Themes and Templates - create consistent report styling and reusable report layouts.
  • Building Interactive Visualisations
    • Using Advanced Slicers and Filters - improve report usability and allow users to explore information dynamically.
    • Working with Bookmarks and Selections - create interactive reporting experiences and navigation controls.
  • Visualising Time-Based Information
    • Creating Calendar Tables - prepare date structures for more effective reporting and time analysis.
    • Using Time Intelligence Features - create Year-to-Date and Month-to-Date style calculations for business reporting.
  • Creating Hierarchies and Drill-Down Reports
    • Designing Reporting Hierarchies - organise information into logical reporting structures.
    • Implementing Drill-Down and Drill-Through - allow users to move from summary information into more detailed analysis.

Effective Data Analysis Techniques

  • Introduction to DAX Formulas
    • Using Basic DAX Functions - work with functions such as SUM, AVERAGE, and COUNT within Power BI models.
    • Creating Calculated Columns - add custom calculations to improve reporting and analysis.
  • Data Transformation with Power Query
    • Applying Advanced Data Cleaning Techniques - improve the quality and structure of imported information.
    • Creating Custom Columns and Calculations - extend and reshape imported information using Power Query tools.

Optimising and Publishing Reports

  • Enhancing Report Interactivity
    • Using Tooltips for Additional Insights - provide users with more detailed information directly within reports.
    • Managing Report Interactions - control how visuals interact and respond to selections within dashboards.
  • Efficient Publishing and Sharing
    • Publishing to Power BI Service - upload and manage reports within the Power BI online environment.
    • Sharing and Collaborating on Reports - distribute reports securely across teams and organisations.
    • Using Power BI Apps - package and share collections of dashboards and reports more effectively.
  • Optimising Report Performance
    • Applying Performance Best Practices - improve report speed and usability through efficient report design.
    • Using Performance Analyzer - identify and troubleshoot performance bottlenecks within Power BI reports.

Navigating Power BI Online

  • Using Advanced Power BI Service Features
    • Creating and Managing Dashboards - organise and maintain online dashboards within Power BI Service.
    • Using Power BI Q&A - explore information using natural language queries and AI-assisted reporting features.
  • Managing Refresh and Security
    • Setting Up Scheduled Refresh - automate report updates to keep information current.
    • Implementing Row-Level Security - control access to information for different users and groups.

Other Related Courses

Ready to progress further with Power BI? Explore Data Analysis Expressions (DAX), the powerful calculation language used within Power BI data models. Our Power BI DAX Training Course covers practical DAX functions including CALCULATE and time intelligence features used for more advanced business reporting and analysis.


Enhance your reporting and data preparation skills further with our SQL Server Fundamentals Course, ideal for:

  1. Preparing and organising information before importing it into Power BI.
  2. Connecting Power BI directly to SQL databases for reporting and analysis.

Post-Course Resources

  • Training Notes and Exercise Files - continue practising using guided examples and course exercises.
  • Online Learning Materials - access video tutorials, shortcuts, and additional support resources.
  • Post-Training Support - receive up to 3 months of follow-up support after your training session.

Discover Live Online Training.

Interactive Live Online Training

Stay informed with our Power BI Training Videos.

Training Locations and Delivery Options

This course is available online instructor-led, at client premises, and at selected training venues across the UK.

View training centres and venue information



Thank you for subscribing. You'll receive our newsletter soon.