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
This course will benefit those who analyse data and create reports. Getting data from different sources and producing dashboards and reports.
Learners should have Intermediate/advanced level of knowledge of Microsoft Excel including knowledge of Pivot Table.
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.
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?
The Data Model/Power Pivot
Rich interactive visualisations
Power BI Desktop and Power BI Service
THE POWER BI DESKTOP INTERFACE
Visualisation and Fields pane
Power BI Desktop Options
GETTING DATA INTO POWER BI
From Text Files
From CSV files
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
Setting Data Types
CREATING THE DATA MODEL
Create table relationships
Edit and delete relationships
Understand filter context
Tables & Columns – Understanding basic
Data View – Seeing your underlying
Exploring Data – Easy data profiling
Managing Schema & Data Changes –
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
Using Common DAX Functions
LOOKUP AND FILTER DAX FUNCTIONS
Why these functions are useful?
Adding tiles to a Report
Using Geographic Data
Other Filter tools (Report, Pages,
Highlight vs Filter
POWER BI SERVICE
Publishing your Report
Reports and Dashboards
Refreshing your Reports
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
What Our Clients Say
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.