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

Belkin

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

Network Rail

"Very good, pitched at the right level. Simon was very engaged, enthusiastic and knowledgeable and was left plenty of time at the end for specific queries.

Buster + Punch

"Simon makes the training an easier task by approaching his pupil 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."

West Midlands Fire Service

"It was great - delivered at our pace with lots of chances to ask questions. It was really useful to develop some reports using some of our real data, not just "training" data."

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

Power BI Online Training - All you need to know.

Live Online Training - All you need to know

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

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


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