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

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

Microsoft Power BI Intermediate Training Course Intermediate Kensington

Kensington Intermediate Microsoft Power BI Intermediate Course Overview

Microsoft Power BI Intermediate Training Course Intermediate training course Kensington - Peter Pan Statue in Kensington gardens

We are pleased to be able to support businesses or even private households in Power BI at a Intermediate level.

Located in the heart of London, Kensington is a thriving hub for businesses and residents alike. Whether you're a small local company or a private individual looking to enhance your skills, we’re here to help you succeed in Power BI. Known for its rich cultural history and prestigious institutions, Kensington provides an excellent backdrop for learning and growth.

Let us come to your business – we can bring laptops and can squeeze into the tiniest spaces. So basically, if you can find a space, we can train you. We can also provide:

  • Laptops with software if required
  • Power BI Training Notes
  • Post-training support

Beyond the training, Kensington offers a range of great amenities and attractions for visitors. Take a stroll through Hyde Park or explore the renowned museums like the Natural History Museum and the Victoria and Albert Museum. After your training session, why not enjoy one of Kensington’s many charming cafes and restaurants?

Please take the time to check out the various other computer training courses in Kensington. We are sure that you'll find one that suits you.

Visit Kensington, home to world-famous museums and beautiful Victorian architecture.


Course Duration: 1 Day

Course Prerequisites for your training in Kensington

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.