Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

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

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

Locations outside Hammersmith

Microsoft Power BI Intermediate Training Course Intermediate Hammersmith

Hammersmith Intermediate Microsoft Power BI Intermediate Course Overview

Microsoft Power BI Intermediate Training Course Intermediate training course in Hammersmith and Fulham

If you're wanting to book your Microsoft Power BI Intermediate Training Course and are wondering about the following:

You don't know what course to take!
You have no idea of your skill level.
You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Microsoft Power BI Intermediate Training Course then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Microsoft Power BI Intermediate Training Course Intermediate training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Course Prerequisites for your training in Hammersmith

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

Advanced Power Pivot Tables 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:

Pre-data loading preparation in Power BI.
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.