PowerBI Desktop

Duration: 
2 days
Codes: 
QAPBIDESK

Overview

This course will provide you with the basic knowledge and skills to import / ingest data, create a model and create visualisations using Power BI Desktop.

Target

Audience

  • Anyone who will be creating Power BI Desktop models.
  • The course is aimed at both non-technical 'power users' and IT Professionals who will be creating models.

Please note - Delegates attending an Extended Classroom delivery will need access to a second monitor.

Prerequisites

There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.

Course Outline

Module 1: Overview

This module provides essential background information Power BI Desktop such as connections with Power BI Service, Analysis Services and data warehouses.

Lab :

  • Installing Power BI Desktop

Module 2: Accessing data

This module describes the process of importing data into a Power BI Model. The sources used as demonstrations include CSV, Excel and Azure SQL Databases.

  • Connecting to a live source
  • Importing Excel and CSV data

Module 3: Transforming Data

This module describes how you can transform the data from an imported source into a table. The module describes most of the options with the Power Query Editor and M language.

  • Remove unwanted columns and rows
  • Cleansing data
  • Normalise datasets
  • Merging data
  • Importing multiple Excel files (M)

Module 4: Modelling Data

Once the data is imported into the model, the model can be enhanced by adding column and measure properties, calculations, hierarchies and relationships.

  • Managing relationships
  • Customising fields view
  • Calculations

Module 5: Visualisation

This module how to create report pages using Power BI Desktop for consumption by others.

  • Visualise tabular
  • Adding charts
  • Adding maps
  • Adding slicers
  • Drillthrough pages
  • Bookmarks, selections and buttons
  • Custom tooltips

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA, ATO of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London2 1803 £1803 2019-09-19
London London2 1803 £1803 2019-09-26
Yorkshire Leeds2 1803 £1803 2019-09-26
London London2 1803 £1803 2019-10-10
Manchester Manchester2 1803 £1803 2019-10-10
Midlands Birmingham2 1803 £1803 2019-10-31
London London2 1803 £1803 2019-11-25
Glasgow Glasgow2 1803 £1803 2019-12-16
London London2 1803 £1803 2019-12-19
Yorkshire Leeds2 1803 £1803 2019-12-19
London London2 1803 £1803 2019-12-23
London London2 1803 £1803 2019-12-23
Manchester Manchester2 1803 £1803 2019-12-23
Midlands Birmingham2 1803 £1803 2020-01-02
London London2 1803 £1803 2020-01-02