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.

Power BI testimonials from Peterborough

The TBA

"Just finished my training with Simon and couldn't be more delighted with how it went - it exceeded all my expectations. It's a daunting subject but from the moment the training began, Simon put me at ease and just made everything to easy to understand. He's obviously well versed on the software and so keen to pass on his knowledge and experience. He was patient and understanding if I ever got lost and was kind enough to share some ideas on how I could make Power BI work for us. I can wholeheartedly recommend Simon and Computer Tutoring to anyone looking to master Power BI - If you have the opportunity to learn from him, seize it - you won't be disappointed! I'm off to put my new found skills and knowledge to the test! "

AEA

"I had previously finished a similar course and felt that I hadn't learnt enough from it, this course however was perfect and I now feel much more confident to work on Power BI. The course was run extremely well via Zoom with details being given if we asked for in depth on certain areas but usually the trainer explained everything so clearly there was little need for more questions. I am looking forward to the next level of training on it now as well."

Buster + Punch

"Simon makes the training an easier task by approaching his pupil first, in order to know their level of knowledge, and then he presents the BI functions in an understandable and patient way. Excellent introduction for beginners and an overview of the amazing tools Power BI provides for creating reports, data analysis and decision making."

Foster Refrigeration

"The training was pitched at exactly the right level and Simon Cubbin tailored the course to fit the requirements of our company. After a 2 day course we had a working sales analysis model with all the correctly structured measures in place ready for deployment across the business. Simon's level of knowledge and teaching style were excellent. Highly recommended.

Microsoft Power BI Intermediate Training Course - Intermediate Training in Peterborough

Peterborough Intermediate Microsoft Power BI Intermediate Course Overview

Microsoft Power BI Intermediate Training Course Intermediate training in Peterborough

Peterborough is a practical location for businesses that want focused, instructor-led Microsoft Power BI Intermediate Training Course training with straightforward access from across the surrounding area.

The venue provides a focused setting for reporting and analytics training, giving delegates time to work through dashboards, calculations and data models in a structured way.

Stuart House - East Wing
St John's Street
Peterborough PE1 5DD
United Kingdom

The venue is close to transport links and central amenities, which makes it a convenient setting for training. This is particularly helpful for teams building reporting skills or working with larger datasets.

If you are also looking at other options, take a look at our training courses in Peterborough.


Microsoft Power BI Intermediate training for Peterborough teams

We can deliver Microsoft Power BI Intermediate Intermediate training for organisations in Peterborough and nearby areas such as Stamford, Spalding, Huntingdon, Wisbech, March and Cambridgeshire. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

The Peterborough venue at Stuart House on St John's Street is close to central amenities and transport links, making it a convenient option for focused training days.

Local training use cases

Microsoft Power BI Intermediate training in Peterborough is useful for teams who want skills they can apply quickly in real work. The venue provides a focused setting for reporting and analytics training, giving delegates time to work through dashboards, calculations and data models in a structured way. This is particularly helpful for teams building reporting skills or working with larger datasets. It suits users who need practical experience with business reporting and data analysis.

Peterborough is a strong setting for Microsoft Power BI Intermediate Training Course Intermediate training. The venue provides a focused setting for reporting and analytics training, giving delegates time to work through dashboards, calculations and data models in a structured way. It suits users who need practical experience with business reporting and data analysis.

Unlock deeper insights and advanced capabilities with our Intermediate Power BI Training Course. Designed for those who have a foundational understanding of Power BI, this course will elevate your skills to the next level. Dive into advanced data integration techniques, optimise your data models, and create compelling visualisations that tell a story.

Perfect for professionals using Microsoft 365, this course ensures you gain the skills to create sophisticated reports and dashboards, touching on DAX to uncover deeper insights. Are you ready to take your Power BI expertise to new heights?

What You'll Learn in Power BI Intermediate

  • Transform large datasets with advanced Power Query
  • Optimise data models with calculated columns and relationships
  • Build dynamic, interactive visualisations
  • Use DAX for advanced calculations
  • Publish and share reports effectively

Course Duration: 1 Days

Course Prerequisites for your training in Peterborough

To make the most of this intermediate course, we recommend that participants have:

  • A basic understanding of Power BI, including creating simple reports and visualisations
  • Are familiar with working in Microsoft Excel or similar tools for data analysis

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

Complete Course Outline

Advanced Data Integration and Modelling in Power BI

  • Advanced Data Integration Techniques
    • Connecting to multiple data sources
    • Handling large datasets
  • Optimising Data Models
    • Understanding advanced relationships and cardinality
    • Leveraging calculated columns and measures

Creating Advanced Visualisations

  • Advanced Customisation of Visuals
    • Conditional formatting
    • Using themes and templates
  • Interactive Visualisations
    • Advanced slicers and filters
    • Using bookmarks and selections
  • Visualising Time-Based Data
    • Creating and utilising calendar tables
    • Time intelligence basics (Year to Date, Month to Date)
  • Creating Hierarchies and Drill-Downs
    • Designing effective hierarchies
    • Implementing drill-down and drill-through

Effective Data Analysis Techniques

  • Introduction to DAX Formulas
    • Basic DAX functions (SUM, AVERAGE, COUNT)
    • Introduction to simple calculated columns
  • Data Transformation with Power Query
    • Advanced data cleaning techniques
    • Creating custom columns and measures

Optimising and Publishing Reports

  • Enhancing Report Interactivity
    • Using tooltips for deeper insights
    • Configuring and managing report interactions
  • Efficient Publishing and Sharing
    • Publishing to Power BI Service
    • Sharing and collaborating on reports
    • Using Power BI apps for report distribution
  • Optimising Performance
    • Best practices for optimising report performance
    • Using Performance Analyzer in Power BI

Navigating Power BI Online

  • Advanced Features of Power BI Service
    • Creating and managing dashboards
    • Utilising Power BI Q&A for natural language queries
  • Managing Data Refresh and Security
    • Setting up scheduled refresh
    • Implementing row-level security

Other Related Courses

Progressing beyond beginners' Power BI, delve into Data Analysis Expressions (DAX) - a key Data Modeling language. Our Power BI DAX Training Course covers DAX functions, including the Calculate function and time analysis functionalities in detail.


Enhance your skills further with our SQL Server Fundamentals Course, perfect for:

  1. Pre-data loading preparation in Power BI.
  2. Direct SQL integration into Power BI.

Post-Course Resources

  • Training notes & exercise files
  • Online materials: video tutorials & shortcuts
  • 3 months post training support

Discover Live Online Training.

Interactive Live Online Training

Stay informed with our Power BI Training Videos.

Location FAQs for Peterborough

Where can this training take place in Peterborough?

We can deliver this Power BI training at your premises in or around Peterborough, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Peterborough?

Yes. We regularly deliver on-site training for teams in Peterborough and can usually tailor the session to your team, your documents and the way you work.

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.