Computer Tutoring Logo

Cost Calculator

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

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

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!"

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! "

University of Suffolk

"Training was excellent. Really enjoyed the opportunity to see what Power BI can offer to us."

Next

"It was very informative session. All the topics have been covered that is required for you to jump on the power bi for the first time. Crystal clear explanation with real time examples"

Microsoft Power BI Intermediate Training Course Intermediate Reading

Reading Intermediate Microsoft Power BI Intermediate Course Overview

Intermediate Intermediate training course Reading - Town Hall

A relatively new training location for us however we are eager to get to know and help local businesses in the area.

Reading is a bustling town with a strong literary heritage and vibrant arts scene.

Equipped with laptops with the software loaded on. Also a projector along with a mouse for each laptop as we know how difficult it is to use that little touch pad thingy.

However should you want to get out of your office for your Intermediate Microsoft Power BI Intermediate Training Course training course then why not come to a local one that we use.

200 Brook Drive
Green Park
Reading
RG2 6UB

In your busy life the convenience of a Microsoft Power BI Intermediate Training Course Intermediate training course by the M4 near Reading could be the ideal solution.

The Microsoft Power BI Intermediate Training Course Intermediate in the The Green Park business centre Reading is a stunning building with a full-height atrium and large open-plan reception area. It is one of a group of individually designed landmark buildings attractively positioned around Longwater Lake just outside Reading. With handy access to the M4 this is the ideal location for those coming from the south west or if they simply want to get out of London for the day.

Apart from Microsoft Power BI Intermediate Training Coursetraining, we also conduct many other computer training courses in Reading. Have a look and see if we can accomodate.


Course Duration: 1 Day

Course Prerequisites for your training in Reading

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.