Power BI Desktop Training

Training Aims:

Training in this course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards.  These can then be shared with colleagues or others with the Power BI service, and in many other ways.

Course Requirements:

Attendees should previously have knowledge of Excel with some familiarity with Excel Pivot Tables and Excel Functions like SUMIFS and VLOOKUP.  People with Database, Programming, or other BI experience will be qualified for the course even if they don’t have direct Excel experience.

Course Contents:

What is Microsoft Power BI

Power BI Desktop Vs Power BI Online

Understanding the Power BI environment

Understanding Data Sources in Power BI Desktop

Importing a variety of data sources into Power BI Desktop

Connecting to Excel Workbooks, Access Databases, CSV Files and other data sources.

Exploring Power BI Desktop

Working with the Fields and Visualisation Panes

Using Report View to create visualisations

Using Report View to Sort and Format Data

Using Data View to sort and Format data

Filtering Data in Power BI Desktop

Using the Filters Pane

Single Selection

Advanced Filter on a Field

Filters on Current Page

Filter on all Pages

Show/display Filters Pane

Creating a Data Model in Power BI desktop

Understanding the Data Model

Using Relationship View

Creating Many-to-One relationships

Refreshing Data

 Visualisations Workshop using Power BI Desktop

Adding visualisation to the Report Canvas

Understanding and controlling interactions between Visualisations

Using Drill Down and Drill Through on visualisations

Creating and using Hierarchies

Introduction to DAX in Power BI Desktop

Exploring the importance of custom calculation within the Data Model

Creating Calculated Columns & Measures

Understanding Evaluation Context

Using CountRows and DistinctCount Functions

Using Queries in Power BI Desktop

Understanding the role of Queries in data import

Understanding Extract, Transform & Load (ETL)

Data transformations

Applied Steps

Publishing to Power BI Service

Publish your Report to PowerBI.com

Creating Dashboards

Using Power Pivot Data Model in Power BI Service

Creating visualisations in Power BI Service using Power Pivot data

Sharing your Dashboards & Content Packs

How to share your interactive Power BI Dashboards

Sharing using Power BI, Web, PowerPoint and others

Duration: 1 Day

Cost: £235 + VAT

Office 365 Training, Inverness, Aberdeen, Glasgow, Edinburgh, Scotland and onsite UK Training available.