Microsoft Power BI Introduction

Duration: 2 Days

Who will benefit from this course?

Anyone who is familiar with Microsoft Office applications and need to work with data to connect, process and analyse data to produce suitable output at all levels within an organisation.

Prerequisites

It is assumed that attendees are familiar with Excel with charts and pivot table concepts and have an understanding of basic data concepts.

Getting Started

• Power BI Concepts and Overview

• Introduction to Main Features

• Imports

• Visualisations

• Filters and Queries

• Reports

Connecting to Data Sources

• Data Sources

• Data Types and Properties

• Import and Enter Data

• Get Data and Query Editor

• Introducing the Query Editor

• Combining Data Sources

• Append Queries

• Merge Data Tables

• Working with Relationships in Data

Querying and Shaping the Data

• Filters

• Clean, Trim, Format and Replace

• Split Column or Extract Using Delimiters

• Column from Example

• UnPivot

• Custom Calculated Columns

• Histograms

Data Visualisations

• Overview of Data Visualisations

• Table and Matrix Views

• Conditional Formats

• Charts

• Slicers

• Visualisation Drilling for Data

• Analytics Lines

• Forecast

• Measures

• KPI Visualisation

• Date Hierarchies

• Quick Measures

• Clustering

Reports and Output Options

• Report Elements and Options

• Working with Pages

• Visual and Filter Settings

• Edit Interactions

• Bookmarks

• Report Themes

• Buttons and Q&A

• Export Power BI Data to CSV

• Create a Power BI Template