Microsoft Power BI Office 365 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

Understanding the Power BI environment

Installing Power BI Desktop

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

Exploring Power BI Desktop

Working with the Fields and Visualisation Panes

Using Report View to create visualisations

Using Data View to sort and Format data

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

Creating and using Query Parameters

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 with people both inside and outside your organisation

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.