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 Brentwood

Microsoft Power BI Intermediate Training Course Intermediate Brentwood

Brentwood Intermediate Microsoft Power BI Intermediate Course Overview

Microsoft Power BI Intermediate Training Course Intermediate training course - Brentwood Station

Brentwood, located in Essex, offers a mix of charming countryside and modern amenities.

Brentwood Training Facilities

3 The Drive
Jubilee House
Great Warley
Brentwood
CM13 3FR
United Kingdom

This is located on the Warley Hill Business Park, which is just one mile from Brentwood town center and the railway station from which a direct link to London departs every 15 minutes. Brentwood is situated in the north east sector of the M25. An ideal location for your Intermediate Microsoft Power BI Intermediate Training Course.

Alternatively if you live in and around Brentwood and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

Apart from Microsoft Power BI Intermediate Training Course training, we at Computer Tutoring are happy to conduct many other training courses in Brentwood.

Course Duration: 1 Day

Course Prerequisites for your training in Brentwood

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.