Introduction

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

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

Our expert instructors break the course into easily digestible sections and ensure 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?

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

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

Am I Ready For 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.

It is also helpful if you have a basic understanding of relational databases.

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
  • Publishing to the Web
  • PDF

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared 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.