Power BI Training course - Provided by SharePoint Training ScotlandSharePoint Training Scotland

The Power BI training course is designed to take a user with a basic understanding of excel and office 365 and introduce them to the opportunities provided for the manipulation and visualisation of data.
To find out more about our SharePoint and Office 365 services get in touch today. call +44 (0) 7739 870 670 or Email us at: contact@solutionsdeveloped.co.uk

Duration: 2 Days
Course Style: Instructor Led

Audience: Intermediate
Experience with MS o365 required

The Power BI Training course covers the skills a user will be expected to use to create and maintain Power BI dashboards with visualisation.

Module 1 – Power Bi Introduction

Power BI Programs

Licensing

Limitations

Module 2 – Creation a Data Set for a Report

The difference between a Data set and a Data Source

Connecting to Data Sources

Using Multiple Data Sources

Editing the Data Queries

Linking Multiple Data Sources

Module 3 – Visualizations

Stacked Bar Charts and Stacked Column Charts

Clustered Bar Charts and Clustered Column Charts

100% Stacked Bar and Column Charts

Line Chart, Area Chart and Stacked Area Chart and Ribbon charts

Line and stacked columns, Line and Clustered columns charts

Waterfall Chart

Scatter Chart

Pie Charts and Donut Charts

Treemap

Map, Filled Map and ArcGIS Maps for Power BI

Funnel

Gauge

Slicers, Cards and Multi Row Cards

KPI

Tables and Matrices

Customising the Visualization

Module 4 – Multiple Pages

Filtering

When would you Filter

Module 5 – Publishing a Report and Sharing It

Publishing

Sharing the Report

Scheduling Refreshes

Embedding a Report

Module 6 – Creating a Dashboard

Adding Tiles to a dashboard

Sharing a Dashboard

Module 7 – DAX (Data Analysis Expressions)

What is DAX

What are calculated columns

What are measures

When to use a calculated column

When to use a measure

Using DAX in dynamic reports

Advanced DAX features