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

Locations outside Heathrow

Microsoft Excel Power BI Training Course Beginners Heathrow

Heathrow Beginners Microsoft Excel Power BI Course Overview

Microsoft Excel Power BI Training Course Beginners training Heathrow

Situated near one of the world’s busiest airports, Heathrow connects travelers to a global network of destinations.

London - (Heathrow)
450 Bath Road
Longford
Heathrow
London, UB7 0EB

In your busy life the convenience of a Microsoft Excel Power BI Training Course Beginners training course near Heathrow airport could be the ideal solution.

The Microsoft Excel Power BI Training Course Beginners course in the 3 storey Heathrow Airport training centre is five minutes from Heathrow's Terminal 5. Set in secluded grounds, the building has an impressive high-ceilinged reception and there are views of the planes taking off and landing from some offices. Close by car from Terminal 5, there is also easy access to the London Underground, Heathrow Express and the M25 and M4 motorways. It is a short drive to cafes, restaurants, bars and shopping in West Drayton.

If a Beginners Power BI training course isn't what you need. Then please take the time to look at other computer training courses in Heathrow.


Course Duration: 1 Day

Complete Course Outline

Introduction to Excel Power BI

  • Business Analysis
  • Installing Power BI
  • Check your version of Office

Getting Data

  • Excel

Creating Calculated Columns

  • Concatenation
  • Date Formulas

Visualisations with Power BI

  • Formatting Visualisations
  • Adding a Slicer
  • Sorting the Month Order Problem
  • Multiple Labels on Axis
  • Drilling Down
  • Creating Hierarchies - Multiple Labels on the same Axis
  • When to use a Tree Map

Filters

  • Adding Arrows and Comments

Edit Interactions

Calendar Table

Relationships and Keys

  • Showing Rows with no Data
  • Using Excel Tables

Laying out a Page

DAX

  • YTD - Year to Date
  • Previous Year
  • HASONEVALUE
  • The Process of RANKING

Importing Visualisations

  • Importing Custom Visual from the Web
  • Timeline Slicer Visualisation

Publishing

  • Signing in

Navigating Online Power BI

  • Pinning Dashboards
  • Asking Questions of your Data
  • Custom Q&A Questions
  • Removing a Visualisation from the Dashboard

Insights

  • Importing Custom Visuals

Power Query

  • Removing Errors
  • Applied Steps
  • Removing the Rows Entirely
  • Custom Columns and Try
  • Adding an Index Column

This course is suitable for those using Microsoft Office 365 (O365).

Microsoft Excel Power BI training is also available for online training via Zoom or Teams.

All you need to know about our Live Online Training.

Live Online Training

Comprehensive coverage of DAX is covered in our Power BI DAX Training Course where we cover more of the functions in Detail, including the Calculate function and multiple time analysis functions.


One other course you might be interested in taking in conjunction with this would be the SQL Server Fundamentals course. By taking this course you will be able to either:

  1. Prepare your data before loading into Power BI
  2. Type SQL directly into Power BI.

Microsoft SharePoint 365 Training Course Beginners

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel Pivot Tables Training Course Beginners

Keep yourself updated with our Free Power BI Training