Award Winning
Award-winning 7 years in a row
Expert Trainers
Average experience: 12 years
Small Classes
Average 4 people per class
Moneyback Guarantee
100% money-back guarantee

Power BI Courses

Power BI Training: 1 Day Introduction

Power BI Introduction

Length : 1 Day
Format : Classroom & Live Online
From : £ 425 (+VAT)

For beginners looking for a thorough grounding in the basics.

  • Introduction to Power BI
  • Importing data (various sources)
  • Ways to manage your data
  • Creating data visualisations
  • Publishing & sharing reports
Power BI Training: 2 Day Advanced Course

Power BI Advanced

Length : 2 Days
Format : Classroom & Live Online
From : £ 995 (+VAT)

Become a Power BI power user and learn to use its most powerful tools.

  • Measures & calculated columns
  • Creating & optimising reports
  • Drill-through & date reports
  • Automatically updating data
  • Managing security & permissions
Power BI Training: Combined Course (SAVE £100)

Power BI Combined

Length : 3 Days
Format : Classroom & Live Online
From : £ 1320 (+VAT)

The fastest way to go from beginner to Power BI expert.

Save £100 when you book our Introduction and Advanced Power BI courses at the same time.

Power BI Training: 1 Day Introduction To DAX Course

Power BI Introduction To DAX

Length : 1 Day
Format : Classroom & Live Online

Start controlling your data with DAX

  • Using common DAX functions
  • Implementing time intelligence
  • Calculated columns & measures
  • Specifying cross table lookups
  • Filters using tables functions
Power BI Training: 1 Day Advanced DAX Course

Power BI Advanced DAX

Length : 1 Day
Format : Classroom & Live Online

Learn to use DAX’s most powerful functions.

  • Using variables
  • Creating a Measures table
  • Time intelligence calculations
  • Working in DAX studio
  • Parameters & what-if scenarios

Your Power BI Trainer

Our usual Power BI trainer is Oakley.

 

Choosing The Right Course

 

If you are unsure which course is most appropriate for you, please call us and we’ll be very happy to advise you.

Our Power BI introduction training course is for complete beginners, you do not need any previous experience with Power BI to attend.

It is designed for people who will be:

  1. Using complex dashboards and reports which have been prepared by other analysts
  2. Creating simple data visualisations from scratch.
  3. Going on to attend our Advanced course and need to master the basics.

By the end of this course, you will be able to:

  1. Connect to a range of data sources using Power BI
  2. Prepare and transform your data.
  3. Create data visualisations like KPIs and charts.
  4. Publish reports that you have crated via the web or PDF.

This course gives you a high-level overview of Power BI and introduces basic best practices and its drag and drop functionality.

Our advanced training course is for people who are already Power BI users and want to develop their skills further.

It is designed for people who will be creating complex dashboards and reports from scratch.

By the end of this course, you will be able to:

  1. Customise a report.
  2. Use the query editor to interrogate the data in a data model, data relationships and hierarchies.
  3. Build interactivereports like drill-through reports and relative date reports.
  4. Creating a wide variety of compelling visualisations including maps, bullet and scatter charts.
  5. Set security and data permissions, and control when your data is updated.

The combined course is a combination of our Introduction to Power BI course and our Advanced course.

We offer a discount when these two courses are booked at the same time.

You do not need to be an advanced Power BI user to attend our introduction to DAX course.

The pre-requisite to attend is that you are comfortable using Power BI and understand it to at least the level that you would if you had attended our Introduction course.

This course covers creating basic DAX formulas using M langugage.

Our Power BI courses can be at your offices, at one of our training centres in London and Guildford or online.

Our online courses can be run using either Zoom or Microsoft Teams.

Yes we do.

We frequently run in-house courses for companies, and individuals who want to focus on a specific part of Power BI.

Clancy Docwra Logo
EA Games Logo
Legal & General Logo
NHS Direct Logo
Rentokil Initial Logo
Shell Logo
NatWest Logo
Mercedes Benz Logo
Three UK Logo
BHPBilliton logo

Training Locations

London Training Courses
Fleet House, 8-12 New Bridge St
London, EC4V 6AL
Tel: 0203 603 0150

Directions


Guildford Training Courses
Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

Directions

The Training Day

Course Times

9.15 - 9.30
Arrival
9.30 - 11.00
Training Session 1
11.00 - 11.15
Break
11.15 - 12.30
Training Session 2
12.30 - 13.30
Lunch
13.30 - 14.45
Training Session 3
14.45 - 15.00
Break
15.00 - 16.30
Training Session 4

What's Included?

Everything you need for a great day's training.

A full-colour manual A full-colour manual
A USB stick to take the exercises you've been working on home A USB stick to take the exercises you've been working on home
Pens and pads to take notes Pens and pads to take notes
Plenty of tea, coffee and biscuits Plenty of tea, coffee and biscuits
6 months post course support 6 months post course support
A comfortable, modern air-conditioned training room A comfortable, modern air-conditioned training room

Power BI FAQs

Yes, our classrooms are Covid compliant.

As we limit our classes to a maximum of 4 there is plenty of room for everyone.

If you have any specific questions please contact us.

Yes, we provide everyone who completes one of our courses with a certificate of completion.

We do not provide Microsoft certification.

We provide certificates of completion to everyone who completes one of our Microsoft Power BI programmes as proof of the knowledge that they have.

Our training is designed to prepare your staff for certification as an MCSA in BI Reporting, which is achieved by passing these two exams:

  • 70-778 Analyzing and Visualizing Data with Power BI
  • 70-779 Analyzing and Visualizing Data with Microsoft Excel

Please note, the actual exams will need to be organised separately, at an exam centre, and cost approximately £130, plus VAT.

Learning Power BI is no more difficult than other data analysis software.

It is very powerful software that can combine data from a number of data sources. That data can then be used for business analytics, to produce reports and dashboards.

As with other big data software, learning Power BI for straightforward analysis of simple datasets is not difficult.

Learning to use the full suite of big data tools that Power BI contains for more complex data analysis is obviously more complex and time-consuming.

Business intelligence (BI for short) refers to the collection of technologies involved in collecting and analysing data and then presenting the information generated in dashboards and Power BI reports.

The aim of business intelligence is to make sense of the vast amounts of data that organisations hold. It allows the data to be analysed to guide business decision-making and management.

For example, many retail businesses use Power BI to sort and report their POS data, especially when that data is held in Azure Cloud. As another Microsoft product, they interface very simply with each other.

Power Pivot is an Excel add-in and part of Power BI.

It is used to create data models. It allows you to combine large amounts of data from a variety of data sources, and create reports and dashboards with custom visuals.

A data model is a collection of tables with relationships. A data model that you can see in Excel is available in Power Pivot and vice versa.

Power BI is Microsoft’s data analytics and business intelligence platform.

It was launched in 2014 and its main competitors are Tableau, Google Data Studio and Qlik.

It comes in a range of versions from Power BI Desktop which is free through to Power BI Premium which is a full enterprise business intelligence solution hosted in the cloud.

Power Query allows you to retrieve, extract, and transform (ETL) data prior to bringing it into Excel (and/or into a Power Pivot data model). It allows you to insert & remove columns, filter and sort tables, and change data types.

It runs on the M  Language (short for Mashup) and is labelled as “Get and Transform,” in the “Data” Ribbon in Excel, and is an optional tool. When importing data into Power Pivot can import it directly into Power Pivot, or you can channel it first through Power Query if your data is noisy.

Also known as the DAX Engine (Data Analysis Expression), Power Pivot is an Excel feature that allows you to build a data model with relationships, create calculated columns and measures.

Power Pivot allows Excel to import larger data sets from a variety of sources and create more sophisticated data models using DAX.

Power Pivot allows you to create visualizations using Power View and Power Map. Power Maps is a geographic visualization tool, while Power View allows you to present data in interactive dashboards.

Power Pivot is a free add-on for Excel 2010 and Excel 2013. From Office 2016 onwards, it can be found in Excel.

Power BI works on top of the Power Pivot and Power Query engines. You can shape and analyse your data, either using Get Data in Power Query or Data Model in Power Pivot. You can then Power BI reports and interactive dashboards using Power BI’s wide variety of data visualisations.

Data Analysis Expressions (DAX) is the native language for PowerPivot, Power BI Desktop and SQL Server Analysis Services (SSAS).

It is quick and simple to use and includes some of the functions that Excel uses to work with relational data.

You can find our more about how to learn DAX here: Beginners DAX training course and here: Advanced DAX training course.

Power BI is a different tool to Excel.

They are both great so long as they are used for the right job.

Excel is great for quick, simple ad-hoc analysis. It is very widely used and understood. Sharing your analysis can be a little fiddley, however.

Power BI is a business analytics and data analysis tool, designed to work with large amounts of data.

It was designed with collaboration in mind and makes sharing your work to mobile apps or over the internet straightforward.

We have a detailed blog post about this which you can find here: Power BI: Desktop VS Pro VS Premium. If you would like more details.

Very briefly however the differences are as below.

Power BI Desktop:

Power BI Desktop (free) gives you access to Power BI’s basic features and is where you create data models and carry out data cleansing and analysis. It is also how you access the full cloud-based version of Power BI – Power BI Service – if you are a subscriber.

Power BI Pro:

Power BI is the full version of Power BI. It includes the ability to build and share dashboards and reports that you have built which you can’t with BI Desktop.

Power BI Service or Premium:

Power BI Service is designed for large organisations. It gives your company access to its own dedicated capacity and allows for analysis of very large scale datasets.

A Microsoft Power BI training course is ideal for professionals, such as business analysts,
accountants, sales executives, marketers, and those in managerial roles.

Adding it to your CV will improve your
career prospects.

Our courses show you how to transform data
to generate insights and make intelligent decisions from your datasets.