Microsoft Office training - Introduction to Power BI Desktop

Power BI Training

Introduction to Power BI Desktop Training Course

£695 + VAT for most venues (£795 + VAT for London)

2 days

There are three parts to creating a Power BI Desktop report, all of which are covered by this two-day course. Firstly, you'll learn how to get data from all manner of different sources, using Query Editor to manipulate the results; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns and measures using basic DAX language. You'll also learn how to use Power BI Web, and get an overview of Power BI Mobile. If you're not sure whether you want to book on this course or on our two-day Excel Power BI tools course, have a look here.

Course details

Locations:Manchester, London
Next course:Tue 26 June 2018
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Basic reports

Getting data
Basic visualisations
Shapes, text boxes and images

Data sources

SQL Server / databases
Excel / text files
Websites and web serivces

Formatting visualisations

The formatting panes
Conditional formatting

Charts

Working with charts
Specific chart type issues
Grouping and binning

Other types of visualisation

Working with matrices
Working with cards

Dashboard visualisations

Gauges
Single-number visualisations
KPIs

Query editor

Filtering rows
Manipulating columns
Working with data types

Multiple tables

Relationships
Filter directions

Filtering data

Slicers
Visualisation level filters

Drill-down

Interactions
"See records" feature

Drill-through filtering

Adding drillthrough filters
Back buttons

Action buttons

Assigning actions to shapes
Inserting buttons
Hover and select effects

Bookmarks

Creating bookmarks
Filtering using bookmarks
Spotlighting and hiding visuals

Overview of maps

The types of map
Geo-location
Introduction to ArcGIS

Calculated columns

Adding columns
IF and SWITCH
The RELATED function

Calendars

Creating calendars
Using multiple calendars
Working days

Publishing reports

Power BI accounts
Power BI files (PBIX)

Power BI Service Overview

Differences from PBI Desktop
Workspaces
Favorites

Using Power BI Service

Reports and dashboards
Using tiles
Pinning to dashboards

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
555 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Flexibility of trainer, offering to stay late, was great."

Arron Bhandal (ReAssure UK Services Limited)

"There was a lot to take in (especially in day 2) but the course materials are so extensive I feel confident I'll be able to find out how to do anything I might have forgotten."

Steve Pilkington (Department for Education)

"I was the only person on the course, so could be tailored to my abilities and learning needs which I found really helpful."

Holly Gregson (Myerscough College)

"Superb. Best course I have been on for ages in both delivery, content and presentation."

Andrew Wilson (Fitinique Ltd)

"The trainer delivered the course with incredible enthusiasm, which made learning a difficult topic all the easier and more enjoyable. His patience and support has made this course excellent along with the pace and level it was delivered at - highly recommend. Excellent course; thanks for everything."

Gina Floyd (HM Inspectorate of Constabulary (HMICFRS))

There are lots more where these came from (or just refresh this page to change the quotes shown).

Power BI Desktop is a standalone application, so there are no pre-requisites for attending this course.

Other Power BI Tools training resources

Power BI exercises

View Power BI Desktop or PowerPivot exercises

Power BI videos

View PowerPivot videos

Power BI skills assessment

View Power BI Desktop skills assessment tests

Power BI blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post