Power BI Reporting

Business Intelligence Training Course

Face to face / Online public schedule & onsite training. Restaurant lunch included at STL venues.

From £460 List price £700

Who is this course for?

This one day course is ideal for those looking to gain a firm understanding of how to produce and publish powerful visual reports by using the Power BI desktop. Confident Power BI users looking to understand data modelling and further visualisation should attend our “Power BI Modelling, Visualisation and Publishing” course.

Prerequisites

An intermediate knowledge of MS Excel and Power Bi Desktop installed

Benefits

Learn to use Power BI (Business Intelligence) Desktop to create highly visual reports and dashboards that can easily be shared with others.
Get an understanding of how the reports and dashboards can interact with each other and the great level of interactivity the audience can use to drill, filter, and sort the reports.

Course Syllabus

Power Bi Desktop basics

What is Power Bi Desktop
Introducing the Power BI Ecosystem
Getting started with Power BI Desktop

Digital Storytelling

Purpose of creating dashboard/reports
Planning Reports & Dashboards
Structure Reports & Dashboards
Simple Data connections
Connect to Excel data (single table)
Connect to a data model created in Power Bi Desktop

Simple Calculations

Sum
Average
Divide
Multiply

Power Bi standard visuals

Chart
Table
Matrix
Treemap
Funnel
Map
KPI
Gauge
Card
Multi Row Card
Slicer

Custom Visuals

Import and use custom visuals

Visuals interactions

How to use Images, Shapes, and Textboxes on pages

Buttons and Bookmarks

Add navigation to report
Add interactivity to reports using buttons

Drill/Filter & Sort

Page level filters
Report level filter
Drill through levels in visuals
Sort data in visuals
Sort by column

Tooltip Page

Control Tooltips
Create Tooltip pages
Set interaction between visuals and tooltip pages

Layout and Formatting

Format visuals
Format pages
Work with themes
Snap Object to Grid
Use gridlines
Lock Objects
Selection Pane
Conditional Colour formatting

Basic Publishing

View dates & prices

"What do I get on the day?"

Arguably, the most experienced and highest motivated trainers.

Face-to-face training

Training is held in our modern, comfortable, air-conditioned suites.

Modern-spec IT, fully networked with internet access

Lunch, breaks and timing

A hot lunch is provided at local restaurants near our venues:

Bloomsbury
Limehouse

Courses start at 9:30am.

Please aim to be with us for 9:15am.

Browse the sample menus and view joining information (how to get to our venues).

Refreshments

Available throughout the day:

Hot beverages
Clean, filtered water
Biscuits

Online training

Regular breaks throughout the day.

Learning tools

In-course handbook

Contains unit objectives, exercises and space to write notes

Reference material

Available online. 100+ pages with step-by-step instructions

24 months access to Microsoft trainers

Your questions answered on our support forum.

Training Formats & Services

On a public schedule at one of our
London training venues.
On-site at your company office UK wide
Near-site, at a location close to you
Tailored courses to your requirements
Productivity Training Programs
Consultancy

Bespoke one-to-one
Rollout
TNA

Upgrade
Case studies

Summary

Focusrite

Greg Sheffield,
Senior Customer Service Assistant

Alan was very thorough and patient in his explanations of the various features of Power BI, I'm really looking forward to getting stuck in with our own data.

Power BI Reporting

Argenta Holdings

Amanda Marjoribanks,
Senior HR Manager - Operations

Pace of training didn’t always reflect the ability in the room.

Power BI Reporting

NIIT Limited UK

Laura Caine,
NA

Good course - informative and was good to actually create something live during the training. Jens was very helpful when people had questions.

Power BI Reporting

More testimonials

Buy now Public schedule Live Get On-site/Closed quote

All courses
- MS Office
  - Power BI

TrustPilot

Excellent

Phoenix Consulting
Senior Quantity Surveyor
John Davies

Brilliant course on PowerBI

The trainer was very knowledgeable and went above and beyond to ensure we all left with a good understanding of the topic. The notes provided were detailed and will help going forward

Resources

Promotions

Latest Feedback

Latest Tweet

Learning & Development Resources

Blog

Training manual sample

Below are some extracts from our Power BI Reporting manual.

What is Power BI Desktop?

BI_desktop Much like the Power BI cloud service, Power BI Desktop provides businesses with a powerful analytics and data visualisation solution. It helps businesses understand large sets of data from data sources such as Excel spreadsheets and databases.

It can be used to calculate things such as your monthly sales profits and help you make smarter business decisions powered by data that your business collects. The data can be visualised into unique graphics that help you understand the data more easily, and these insights can be embedded in other apps and websites.

It supports hundreds of different data sources to ensure that your business doesn’t need to change its workflow to support Power BI Desktop. The software works in real-time to provide up-to-date analytics and insights for your business.

Power BI Desktop vs Power BI

supports_data Power BI Desktop supports many more data sources

BI_themes It supports different themes that can be personalised by the business

BI_modelling It supports shaping and modelling of data

BI_python It can be customised further using the Python programming language to generate unique visualisations

BI_share It cannot be shared as easily as the cloud-based Power BI service

Power Analytics With Simple-To-Use Tools

BI_graphical_Excel Power BI Desktop enables anyone to create advanced graphical representations of analytics with familiar tools that are similar to Microsoft Excel

BI_no_techno It doesn’t require technical knowledge and the interface is intuitive to use, meaning anyone can take advantage of its powerful tools

BI_more_control It features advanced tools that can give users more control once they’re more familiar with the software

Simple Integration With Existing Software

BI_hundreds_sources Power BI Desktop can grab data from hundreds of sources such as Excel, SharePoint, Azure SQL DB and Dynamics 365

BI_update_dynamic Data is updated dynamically, meaning all of the integrations you create are automatically kept up to date

BI_insights This provides your business with actionable insights even if you lead a dynamic business that changes its goals frequently

Easy Ways to Publish Your Reports

BI_publish_rights Power BI Desktop allows you to easily publish your reports so you can provide them to those that need it

BI_mobile_opt You can create mobile-optimised reports at the push of a button so that the data is easy to understand and read regardless of the device

BI_embed You can embed reports created in Power BI Desktop into websites and existing apps to make the data more accessible