Introduction to Power BI (classroom)

Training

In Manchester and London

£ 895 VAT inc.

Description

  • Duration

    2 Days

  • Start date

    Different dates available

There are three parts to creating a Power BI report, all of which are covered by this two-day course.

Important information

Documents

  • Introduction to Power BI Desktop.pdf

Facilities

Location

Start date

London
See map
Holland House 1-4 Bury Street, EC3A 5AW

Start date

Different dates availableEnrolment now open
Manchester (Lancashire)
See map
Barlow House, Minshull Street, M1 3DZ

Start date

Different dates availableEnrolment now open

About this 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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Basic reports
  • Data sources
  • Formatting visualisations
  • Charts
  • Other types of visualisation
  • Dashboard visualisations
  • Query editor
  • Multiple tables
  • Filtering Data
  • Drill-down
  • Drill-through filtering
  • Action buttons
  • Bookmarks
  • Overview of maps
  • Calculated columns
  • Calendars
  • Publishing reports
  • Power BI Service Overview
  • Using Power BI Service

Teachers and trainers (5)

Andrew Gould

Andrew Gould

Senior Trainer

Andy Brown

Andy Brown

Microsoft Trainer & Programmer

Rick Gould

Rick Gould

Trainer

Sam Lowrie

Sam Lowrie

Trainer

Shaun Wantling

Shaun Wantling

Trainer

Course programme

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
More on query editor
  • Creating new columns
  • Introducing the M language
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

Additional information

£895 + VAT for most venues (£1,195 + VAT for London)

Introduction to Power BI (classroom)

£ 895 VAT inc.