Back
Responsive image

Power BI Business Analytics | Training Course

Learn to analyse and publish data from a variety of sources using this powerful software.
Create boards, visualisation and dashboards that can then be published.

EXCEL EXPERTS   |   PROFESSIONAL TRAINING   |   SMALL COURSE SIZES   |   LONDON LOCATION

Power BI Business Analytics | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Connect to data sources
  • Use power query to transform data
  • Create dashboards with tables/charts
  • Perform custom calculations
  • Create, format and shape reports
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 4.8 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 20 reviews

Getting Started with Power BI Desktop

• Power BI Concepts and Overview

• Introduction to Main Features

• Imports

• Visualizations

• Filters and Queries

• Reports

Connecting to Data Sources with Power BI Desktop

• Data Sources Power BI Desktop will connect to

• Data Types and Properties in Power BI Desktop

• Import and Enter Data

• Get Data and Query Editor

• Introducing the Query Editor

• Using the Query Editor to Connect to Data

• Combining Data Sources as a Mash Up

• Working with Relationships in Data

Data Visualizations

• Overview of Data Visualizations

• Tables and Matrix Views

• Applying Conditional Formats

• Charts

• Interactive Data and Date Slicers

• Drill Visualizations to see underlying data

• Create Reusable Field Hierarchies

• Record Grouping and Binning in Visualizations

• Drill Visualizations with using Dates

• Clustering

• Analytics and Forecast Lines in Visualizations

• Creating Role Based Views

• Data Categories, Geo-Data and Maps

Querying and Shaping the Data

• Common Activities using Query Editor

• Filters

• Transforms

• Pivot and Group By

• Creating Custom Calculated Columns

• Adding Conditional Columns

• Introduction to DAX Expressions Histograms

Reports and Output Options

• Report Elements and Options

• Working with Pages

• Adding Graphics

• Visual and Filter Settings

• Export Power BI Data to CSV

• Create a Power BI Template

  Course Dates Venue   Price  
London Bridge £299 + VAT save £150
Online £349 + VAT save £100
London Bridge £399 + VAT save £50

You Might Like These Too

Microsoft Excel Intermediate

from £129 + VAT

1 day course
Learn in-depth functionality and commands to analyse your data or finances in detail.

Gain the confidence to complete complicated Excel tasks efficiently.

  • Refresher on basic formulas
    Work with multiple worksheets
    Use advanced formulas
    Use conditional formatting
    Analysis tools to present data visually

Microsoft Excel Adv

from £129 + VAT

1 day course
Automate and streamline your workflow to boost your productivity.

Gain time-saving hints and tips from professional Microsoft Excel experts.

  • Use VLOOKUP functions
    Formula auditing tools
    Adv Pivot tables
    What If analysis
    Reducing your audit risk

Microsoft Powerpoint Intro

from £129 + VAT

1 day course
Quickly and easily create professional, engaging presentations using Powerpoint.

Learn tips and tricks from experts to make your presentations shine.

  • Understand the interface
    Create the perfect slide
    Work with text
    Visual enhancements
    Transitions, animations and notes

What Do Our Learners Think About Our Courses?

Tom Interview
Premiere Intro

 Learner Stories

Tom's Course

Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.

Meija Interview
Social Media Marketing Intro

 Learner Stories

Meija's Course

Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.

Katie Interview
Social Media Marketing Intro

 Learner Stories

Katie's Course

Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.



"Everything was well run and very organised."
Daiwa Capital Markets
15th September - Power BI : Business Analytics

Latest Reviews



"Tom knew a bit about our business which was helpful. I also found the examples were really good ones which is not always the case. I learnt a lot and feel very confident now in Power BI and keen to try out more."
Ofsted
  • 21st December


"Really friendly trainer, went the extra mile to answer additional questions not covered by the course examples but were relevant to my day job."
Ofsted
  • 21st December


"Excellent interaction, good examples and an excellent instructor with excellent knowledge"
TCD Limited
  • 7th October