Specialist - Power BI

Power BI Training

Power BI allows you to collate data from many sources in order to create interactive, immersive dashboards and reports that helps you to attain actionable business results.

Please select the version that you’re interested in

Please select the level that you’re interested in

Power BI Desktop Introduction

Course Overview

Audience:

This course will benefit those who analyse data and create reports. Getting data from different sources and producing dashboards and reports.

Prerequisite:

Learners should have Intermediate/advanced level of knowledge of Microsoft Excel including knowledge of Pivot Table.

Duration:

This is a two day Power BI Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Power BI course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Power BI Desktop Introduction Course Outline

WHAT IS POWER BI?

Power Query

The Data Model/Power Pivot

Rich interactive visualisations

Power BI Desktop and Power BI Service

THE POWER BI DESKTOP INTERFACE

Different Views

Visualisation and Fields pane

Power BI Desktop Options

GETTING DATA INTO POWER BI

From Text Files

From CSV files

From Web

From Folder

From Excel ranges and sheets

UNDERSTANDING POWER QUERY

Understanding the Power Query interface

Renaming and deleting steps

Cleaning messy data example

Refreshing a query

Power Query Options

COMMON POWER QUERY FEATURES

Unpivot Columns

Setting Data Types

Append Queries

Merge Queries

CREATING THE DATA MODEL

Create table relationships

Edit and delete relationships

Understand filter context

Tables & Columns – Understanding basic
data structure.

Data View – Seeing your underlying
data values

Exploring Data – Easy data profiling

Managing Schema & Data Changes –
Dealing with issues of change control

Connections & Tables – Data lineage.

Data Refresh – Optimising new data acquisition.

Relating Tables – Telling Power BI how your data relates internally.

Rules & Limitations – Filter flow options and consequences.

Auto-Detecting – Pros and cons of saving design time

Relationship View – Working on your data model structure

GETTING STARTED WITH DAX

How is DAX different to Excel Formulas

Calculated Columns vs Measures

Creating a Calculated Column

Creating Measures

Using Common DAX Functions

LOOKUP AND FILTER DAX FUNCTIONS

Why these functions are useful?

RELATED Function

CALCUALTE Function

FILTER Function

INTERACTIVE VISUALISATIONS

Adding tiles to a Report

Creating Charts

Using Geographic Data

Creating Matrixes

Using Slicers

Other Filter tools (Report, Pages,
Visualisations)

Editing Interactions

Highlight vs Filter

Formatting Visualisations

Drill Down

POWER BI SERVICE

Publishing your Report

Mobile Layout

Reports and Dashboards

Bookmarks

Understanding Gateways

Refreshing your Reports

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.