PowerBI Desktop

Difficulty
Rating
2days
Duration
2010,00 
+ VAT
Time: 10:30 - 17:30
Location:
When paid with Sovelto Access -credits, you will be charged the corresponding amount of credits to the Euro-price. Please contact sales: 020 7776 670 or myyntipalvelu@sovelto.fi for exact amount of credits in your case.

Register before
Spoken language: English

We are sorry, but the course is already full, please try with another date or location.

Or contact sales: 020 7776 670 or myyntipalvelu@sovelto.fi

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.

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.

Lab :

  • 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.

Lab :

  • 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.

Lab :

  • Managing relationships
  • Customising fields view
  • Calculations

Module 5: Visualisation

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

Lab :

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

Prerequisites

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

 

Places left:
No participant limit
many
2010,00  + VAT