Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number 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:

Num 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

AEA

"I had previously finished a similar course and felt that I hadn't learnt enough from it, this course however was perfect and I now feel much more confident to work on Power BI. The course was run extremely well via Zoom with details being given if we asked for in depth on certain areas but usually the trainer explained everything so clearly there was little need for more questions. I am looking forward to the next level of training on it now as well."

Belkin

"Informative and well paced. Instructor demonstrated a good knowledge of the subject matter throughout the course."

Buster + Punch

"Simon makes the training an easier task by approaching his public first, in order to know their level of knowledge, and then he presents the BI functions in an understandable and patient way. Excellent introduction for beginners and an overview of the amazing tools Power BI provides for creating reports, data analysis and decision making."

Eaton

Power BI Live Online "From speaking to the course leader Simon, Computer Tutoring only started recently to offer online training courses. From taking today's Bi Training course you would not be able to tell. Simon was well prepared for the meeting and was able to guide the class through all his examples clearly and concisely. The course was well led, interesting and at the pace which will suit most people. I am already ploughing through my data to clean it up to be able to use it in BI I have also just been told i can go onto Simons next level of training which I will be doing soon"

Microsoft Excel Power BI Training Course Beginners

Microsoft Excel Power BI Overview

A Power BI training course is essential to understand how to use this powerful self service data analysis tool effectively. Being able to handle the onslaught of data we receive in today's world can make or break your business. In fact, getting any specific, meaningful answers from the data is difficult. Presenting that data in a manner simple to understand for various people is nearly impossible.

Power BI is the answer to all of the above. Allowing you to import data from pretty much any source. This course focuses on using data in Excel to produce Charts and other visualisations including interactive dashboards. You will then learn how to use the Power BI web service to share these reports with others.

Power BI DAX Training Course

On completion of the course the delegates will be able to:

  • Use Excel to produce interactive Charts and Visualisations that can be easily shared
  • Organise and Analyse vast amounts of data with ease
  • Create Interactive Dashboards
  • Learn how to use the Power BI Web Service to share these reports with others

Click on the below image and have a play about with with an example dashboard. Select Time, Colour, Customer or Geographic Analysis to explore a wide variety of dashboard options that you will be able to create on completion of this course.


Power BI Example Dashboard.

Power BI interactive dashboard

Scheduled Live Online Power BI Beginners Classes Available

Course Duration: 1 Day

Course Prerequisites:

Power BI desktop is a separate application to Excel, but knowledge of Excel is really a must before undertaking this course.

Before the course it might be an idea to take a look at:

  • Formatting ranges as a Table
  • Slicers
  • Various Charts

Although not absolutely essential an understanding of data storage, fields and how data should be stored would put you at an advantage.

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

Classroom based Beginners Power BI Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

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



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

So where do you go from a beginners Power BI course? Well one of the aspects we touched upon was the DAX language. DAX stands for Data Analysis Expressions and is a Data Modeling language.

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



Microsoft Excel Power BI Training Course Beginners