Introduction

Build your Power BI skills fast on this 1-day introduction to Power BI training course.

This is a hands-on course. We give you plenty of time to play with what you are being taught and ask questions.

Our expert instructors break the course into easily digestible sections so that we can make sure that no-one is left behind.

By the time you finish, you’ll be a comfortable, capable Power BI user.

✔ A complete introduction to Power BI.
✔ Plenty of time to ask questions and one-to-one attention.
✔ Friendly expert trainers who make sure no-one is left behind.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support for 6 months after the course.

What Will I Learn?

We’ll have you confidently analysing data in Power BI in no time.

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

Connect to a variety of data sources using Power BI
Manipulate and transform your data.
Create a wide variety of different data visualisations.
Create reports which you can publish via the web or PDF.

The Trainer

Oakley is our usual trainer for this course. He has been a Microsoft certified trainer for 8 years.

He has been training Microsoft applications for 19 years, and focuses on Power BI and Project.

Am I Ready For This Course?

You don’t need any prior knowledge of Power BI to come on this course.

It is recommended that you have completed our Excel Advanced level course, or have equivalent experience (particularly of Pivot Tables) before you attend this course.

Once you have completed this course you will be ready for our more advanced Power BI training course.

What will I need to attend remotely?

You will need the following installed and fully working to be able to participate in the training.

PowerBI
64bit version of Excel
microphone
webcam

Course Details

What is Power BI and when do I use it?
Power BI installation and versions.

Different data sources: Files, Databases and the Web.
Repointing to Moved Data Source

Removing Columns/Rows
Data Type Changes
Filters

Group
Split
Duplicate
Combine: Append and Merge
Pivot/Unpivot
Columns: Add Column, Custom Function, Conditional Column
Index
Extract

Model View and Relationship management
Join Kinds
Hierarchies
Working with Related Tables

Formula
Measures
Quick Measure

Date Table Rules
Setting the Date Table
External and Internal
Automatic Date Table
Time Intelligence Formulas and Measures

Matrix
Conditional Formatting
Chart
KPI (Key Performance Indicator)
Spatial Intelligence

Filter: Basic and Advanced
Top 10
Slicer
Drill Through

The Training Day

We include everything that you need for a really fun, productive day of training. You don’t need to bring anything with you.

Our courses run from 9.30am to roughly 4.15pm with refreshments and biscuits throughout the day and a break for lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.

Classroom training now available

Power BI Training: 1 Day Introduction