CUSTOMISED
Expert-led training for your team
Dismiss

Power BI training course

Learn Microsoft Power BI - Craft impressive dashboards, visualisations & reports - Gain better insights into your corporate data

JBI training course London UK

"Our tailored "Power BI course" provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away."  Brian Leek, Data Analyst, May 2022

Public Courses

24/02/25 - 2 days
£1195 +VAT
07/04/25 - 2 days
£1195 +VAT
19/05/25 - 2 days
£1195 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

Power BI Training:

  • Learn the fundamentals of Power BI and Business Intelligence (BI)
  • Navigate the Power BI Desktop environment
  • Use Query Editor to import and transform data from sources such as Excel
  • Build reports, dashboards, and visualisations with Power BI
  • Use DAX to perform calculations and manipulate data
  • Publish and share Power BI dashboards and reports
  • Understand Power BI security and user access principles
  • Explore Power BI features and functionalities
  • Discover the dynamic world of Power BI through expert-led instruction
  • Gain practical experience, unlock powerful insights, and master data visualisation
  • Enhance your skills and drive data-driven decision-making

Power BI Training Course Introduction

  • Power BI: What is it and why use it?
  • Power BI Desktop vs Services - What is best for your use case?
  • Power BI vs other BI tools (Gartner Magic Quadrant)
  • Power BI User Interface Training
  • Customising Visuals vs Theme vs Data Model
  • Power BI Course contents review 

 

Power BI Training for Desktop  

  •  Data Models - How to structure your data using data science
  •    Power BI's 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
  •     Relationship 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
 

 

More on Power BI Training 

  • Power BI Training with your data
  • 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
 

Power BI Dashboard, Reports & Visualisations

  • Power BI Reading View - Seeing what users see.
  • Editing View - Customising user experience.
  • Visualisations and Custom Visualisations - Telling a compelling story.
  • Creating visuals (with no programming)
  • Choosing the best visual
  • Interactivity between visuals
  • Formatting visuals and charts
  • 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 Visualisation

Importing & Transforming Datasets

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

DAX & Calculations in POWER BI

  •     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, Report & Features with Power BI

  • Power BI 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 Defined 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
 
 
JBI training course London UK

  • Business Analysts
  • Financial Analysts
  • Quantitative Analysts (Quants)
  • Data Scientists
  • Financial Traders
  • Data Engineers
  • Professionals who need to create reports from sources such as Excel (Power Pivot), SQL Server, Python, and other databases or datasets.

 


5 star

4.8 out of 5

"Our tailored "Power BI course" provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away."  Brian Leek, Data Analyst, May 2022


“In this Power BI Training Course, Learning more about the query editor and power query 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".
AG, Business Analyst, Power BI Advanced, February  2021


 


Watch Live Client Feedback : JBI Power BI & Python Data Analytics courses

JBI training course London UK

Newsletter


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



What is Power BI and Why Should We Use It?

One of the first questions that comes to mind is: What is Power BI and why should we use it?  We’ll answer this and help you understand Power BI’s advantages over other BI tools, including its position in the Gartner Magic Quadrant. We also compare Power BI Desktop vs Power BI Services, helping you determine which best suits your needs.

In-Depth Power BI Desktop Training

If you're unsure how to structure your data using Power BI’s schemas, create and manage relationships between tables, or understand the various connection options available for your data, our Power BI Desktop section covers it all. We address key queries about the design environment data import, dashboard creation, and report publishing to ensure you achieve proficiency with the tool.

Importing & Transforming Datasets with Power BI Training

Transforming raw data into actionable insights is a cornerstone of BI. Our course covers how to control the data import process, make real-world data usable, and combine datasets from multiple sources. You’ll gain expertise in Power BI’s powerful M library functions and techniques for managing columns efficiently.

Power BI Dashboards, Reports & Visualisations

We tackle questions such as: How do I create compelling dashboards and reports? or Which visual is best suited for specific data? Our course guides you through customising user experiences and creating interactive visualisations—no programming skills required.

Understanding Power BI DAX & Calculations

Data Analysis Expressions (DAX) can be challenging for beginners. In this section, we address key questions like: How do I write a basic DAX formula? or What’s the difference between measures and calculated columns?  We simplify DAX syntax, functions, and operators, ensuring you become proficient in its use.

Power BI Publishing, Sharing Dashboards, Reports & Features

This section addresses how to publish and share dashboards, create workspace structures, and manage security-defined roles. We provide a comprehensive understanding of how to share reports and dashboards effectively, and distribute content via app workspaces.

How is the Power BI course structured?
Our course starts with the fundamentals of Power BI, progressing to data modelling, DAX, and Power Query. Towards the end, we cover creating dashboards, sharing reports and integrating with other Microsoft tools.

Do you offer certification for completing the course?
Yes, upon completion, you will receive a Certificate of Completion, enhancing your credibility in data analysis and visualisation with Power BI.

How long does the course take to complete?
The course typically spans 2-5 days, depending on your team’s proficiency level. It’s designed to provide a strong foundation in Power BI.

What level of expertise will my team achieve?
After completing the course, your team will be proficient in data modelling, visualisations, report generation, and advanced features like DAX and Power Query.

Can you customise the course for our company’s needs?
Yes, we can tailor the course to focus on specific aspects of Power BI or use your own data for practical exercises.

Which companies have you trained?
We’ve worked with leading organisations such as BBC, ITV, Sony, Cisco, BNP Paribas, NHS, Sky, HSBC, Marks & Spencer, and various government departments.

Which sectors benefit from Power BI?
Power BI is valuable across sectors including:

  • Finance & Banking: Financial analysis and reporting.
  • Retail & E-commerce: Sales, customer behaviour and inventory management.
  • Healthcare: Health data analysis and operational efficiency.
  • Manufacturing & Supply Chain: Production tracking and supply chain optimisation.

Will I receive a certification after the course?
Yes, you'll receive a certificate upon completion, recognising your skills and participation in the training.

What is Power BI training, and do I need it?
Power BI training teaches you how to use Power BI for data visualisation, modelling, analysis, and report creation. As the demand for data insights grows, training is essential for mastering Power BI.

What are the learning options for Power BI?
We offer both in-person and online courses. In-person classes provide direct interaction, while online classes offer flexibility. Both options cover key Power BI features and techniques.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2024 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

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course