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 for Introduction to Power BI Desktop coursesLocations:Manchester, London
  • Next Introduction to Power BI Desktop course locationNext course:Tue 26 June 2018
  • Introduction to Power BI Desktop course timesTime:09.30-16.30

Course Contents

Basic reports

  • Training topicGetting data
  • Training topicBasic visualisations
  • Training topicShapes, text boxes and images

Data sources

  • Training topicSQL Server / databases
  • Training topicExcel / text files
  • Training topicWebsites and web serivces

Formatting visualisations

  • Training topicThe formatting panes
  • Training topicConditional formatting

Charts

  • Training topicWorking with charts
  • Training topicSpecific chart type issues
  • Training topicGrouping and binning

Other types of visualisation

  • Training topicWorking with matrices
  • Training topicWorking with cards

Dashboard visualisations

  • Training topicGauges
  • Training topicSingle-number visualisations
  • Training topicKPIs

Query editor

  • Training topicFiltering rows
  • Training topicManipulating columns
  • Training topicWorking with data types

More on query editor

  • Training topicCreating new columns
  • Training topicIntroducing the M language

Multiple tables

  • Training topicRelationships
  • Training topicFilter directions

Filtering data

  • Training topicSlicers
  • Training topicVisualisation level filters

Drill-down

  • Training topicInteractions
  • Training topic"See records" feature

Drill-through filtering

  • Training topicAdding drillthrough filters
  • Training topicBack buttons

Action buttons

  • Training topicAssigning actions to shapes
  • Training topicInserting buttons
  • Training topicHover and select effects

Bookmarks

  • Training topicCreating bookmarks
  • Training topicFiltering using bookmarks
  • Training topicSpotlighting and hiding visuals

Overview of maps

  • Training topicThe types of map
  • Training topicGeo-location
  • Training topicIntroduction to ArcGIS

Calculated columns

  • Training topicAdding columns
  • Training topicIF and SWITCH
  • Training topicThe RELATED function

Calendars

  • Training topicCreating calendars
  • Training topicUsing multiple calendars
  • Training topicWorking days

Publishing reports

  • Training topicPower BI accounts
  • Training topicPower BI files (PBIX)

Power BI Service Overview

  • Training topicDifferences from PBI Desktop
  • Training topicWorkspaces
  • Training topicFavorites

Using Power BI Service

  • Training topicReports and dashboards
  • Training topicUsing tiles
  • Training topicPinning to dashboards

Why Choose Us?

View full list of benefits 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.

Related Courses

Advanced Power BI Desktop

Intermediate

2 day course

PowerPivot / Excel Power BI

Introduction

2 day course

DAX

Intermediate

2 day course

Other Power BI Tools training resources

Power BI exercises

Power BI exercises

View Power BI Desktop or PowerPivot exercises

Power BI videos

Power BI videos

View PowerPivot videos

Power BI skills assessment

Power BI skills assessment

View Power BI Desktop skills assessment tests

Power BI blogs

Power BI blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post