Introduction to Power BI

Microsoft Power BI is the leading tool for taking complex data and simplifying it into self-service reports that can be used throughout your organisation.

OVERVIEW
WHO SHOULD ATTEND?
PREREQUISITES
COURSE CONTENT
OVERVIEW

Data can be pulled from many different sources - Excel, SAP, SQL Server databases, Finance systems, SharePoint etc - and all combined into interactive dashboards that provide insights into how your company is performing.

 

This 1 day hands-on course introduces Microsoft Power BI and provides an understanding of how its features and functionality will assist business reporting.  

WHO SHOULD ATTEND?

Delegates who have an interest in the analysis of data, and making fact-based decisions within the organisation.

PREREQUISITES

Delegates should have a good depth of web browser knowledge, and be familiar with Microsoft Office functionality. 

 

Delegates should have, at least, a basic understanding of reporting and data analysis. 

 

Delegates will benefit from having a known data-set to work with, a set of questions to be answered and reports to be drafted. 

COURSE CONTENT

Introduction to Power BI

Power BI Licensing - Pro and Free

Power BI Features and Functionality

Power BI Web Service

 

Connecting to Data Sources

Power BI Queries

Data Cleansing and Manipulation

Importing Excel Data

 

Data Modelling

Relational Data

Calculated Columns

Building Measures

Working with Time Based Data Sets

 

Visualisations

Chart Types and User Interface

Slicers

Insights

Building Dashboards

Introduction to Data Analysis Expressions (DAX)

 

Power BI Administration

Content Packs

Publishing, Sharing and Embedding

App Workspaces

Have a training request?