CUSTOMISED
Expert-led training for your team

Dismiss

Copy of Power BI training course

Name: Power BI Data Analysis Training Course
Start: 2026-01-28 00:00
End: 2026-01-30 00:00
Location: Copy of Power BI training course

On our Microsoft Power BI training course you will gain new skills for data visualization, data modeling, and data analysis, and how to apply these to create compelling data stories that drive business value.

“I liked these topics: The filters, Relative data Book marks, Cross filtering, Tool Tips. The instructor was very patient, helpful, friendly and answered all questions"
LI, Service Support officer, Power BI Intro, April 2021

Public Courses

09/05/23 - 2 days

£1150 +VAT

Enrol

19/06/23 - 2 days

£1150 +VAT

Enrol

31/07/23 - 2 days

£1150 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates Related Courses

Public Courses

Highlights

Understand the fundamentals of Power BI
Learn to use the Power BI Desktop environment
Query Editor -Import & Transform Data from sources such as Excel
How to build Reports, Dashboards & Visualisations
Using DAX to perform simple calculations and to manipulate data
Publish and Share Dashboards & Reports
Understand Security & User Access principles

Course Details

Power BI Introduction

Power BI - What is it and why use it?
Desktop vs Services
Power BI vs other BI tools (Gartner Magic Quadrant)
Power BI User Interface
Customising Visuals vs Theme vs Data Model

Power BI Desktop

Data Models - How to structure your data
Schemas - Data structure definition
Relationships - How data in one table relates to another
Connectivity - Connection options, e.g. real-time or stored/refreshed
Design Environment - Learning how to build reports.
Importing Data - How to get data into a data model.
Dashboards in Desktop
Get data from different sources
Custom Colours
Desktop Three views
Data View: Column Sort, formatting, hiding columns
Relation ship view: create and manage relationships
Create and format visuals
Slicers
Control Filter interaction
Drilldown data through hierarchies
Drilldown through Auto dates
Publish reports/Dashboards
Monthly Updates

Importing & Transforming Data

Queries & the Query Editor - Controlling the data import process
Shaping & Cleansing Data - Making real-world data usable.
Combining Datasets - Appending, merging data from different sources.
Functions - The M library of powerful data manipulation capability.
Loading Transformed Data - Populating the Power BI data model.

Query Editor in brief
Query Design explained
Query editors tabs and menus
Best Practice for Queries
Applied Steps
Advanced Query Editor
Data Transformations
Data cleaning
Dataset merges
Accessing Excel and csv data
Merging techniques
Managing Columns

Dashboards, Reports & Visualisations

Reading View - Seeing what users see.
Editing View - Customising user experience.
Visualisations and Custom Visualisations - Telling a compelling story.
Creating visuals
Choosing the best visual
Interactivity between visuals
Formatting visuals
Types of Conditional Formatting
Show matrix values on Rows vs Side by side
Customise matrix column subtotals
Matrix Drill-Down tools
Viewing the Underlying Data Driving a Visualization

DAX & Calculations

Data Analysis Expressions - Powerful versatility at your command.
Calculated Columns - Extending data tables.
Measures - How your data is summarised.
DAX Syntax - Learning the basic grammar of formula writing.
DAX Functions - Building blocks for data manipulation.
Dax Operators
Implicit Vs Explicit measures
Measures vs Calculated Columns
Commonly Used DAX Functions
DAX Aggregate functions
IF conditional statements
Evaluating Context in the relationship

Publishing & Sharing Dashboards & Reports

Dashboards - The easy-read overall summary ‘at a glance’
Creating & formatting Dashboards
Sharing Dashboards - Who gets to see what?
Creating Workspace - Organising structure around people.
Security - Restricting access to the ‘need to knows'
Publishing Models to the Cloud Service

Adding Users to Security Deﬁned Roles
Basic Sharing of Dashboards & Reports
Multiple ways of sharing reports and Dashboards
Creating App Workspaces
Collaborating on Reports
Publishing Organisational Apps for Distribution of Content
Adding Users & Editing Workspaces
Connecting to Apps

Who should attend

Business Analysts, Financial Analysts, Quants, Data Scientists and Staff who need to use Power BI for producing reports from Excel, SQL Server and other databases.

Note : This course requires delegates to run Power BI Desktop. Mac users must make arrangements to use a PC

Feedback

4.8 out of 5 average

______________________________________________

“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and it was nice to see some really good examples of how it can be used to present your work. The presenter was very helpful and had great knowledge of Power BI."
AG, Business Analyst, Power BI Advanced, February 2021

Sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

Our UK-based Microsoft Power BI training course shows Data Analysts how to use the latest collection of on-premise and online tools to find, clean, model and visualize data, share discoveries, and collaborate in intuitive new ways.

On this training course we will show you how to build dashboards to visualise financial data gathered from corporate data sources such as Excel.

Empower your team to discover insights hidden in your data with Microsoft Power BI and use your own data on customised courses....

FAQs

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

Copyright © 2025 JBI Training. All Rights Reserved.
JB International Training Ltd - Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us