Description

Learn how to use this powerful tool to import and clean data and create some amazing visuals.

Course overview

Duration: 2 days (13 hours)

Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports.

This course is an introduction to Power BI to get you started on creating a powerful reporting capability.

You should have a good working knowledge of Excel and managing data before attending.

Objectives

By the end of the course you will be able to:

Import data from multiple data sources

Edit and transform data before importing

Create reports

Create different visualisations

Create data models

Build data relationships

Use the drill down features

Create measures

Use the Power BI Service

Build dashboards

Use the mobile app

Content

Essentials

Importing Data

Power BI Overview

Data sources

Importing data

Transforming Your Data

Editing your data

Setting data types

Removing columns/rows

Choosing columns to keep

Setting header rows

Splitting columns

Creating Reports

Creating and saving reports

Adding pages

Renaming pages

Interactivity

Refreshing your data

Adding Columns

Columns from example

Custom columns

Conditional columns

Append Queries

Importing folders

Setting up and using append queries

Creating Chart Visualisations

Adding chart elements

Choosing chart types

Setting properties

Setting values, axis and legends

Using tooltips

Visual filters

Setting page and report filters

Creating Tables, Cards, Gauges and Maps

Adding table elements

Adding maps

Working with cards

Working with matrices

KPIs and Gauges

Conditional Formatting

Setting rules

Removing conditional formatting

Working with Data Models

Merge Queries

Setting up and using merge queries

Merging in columns of data

Creating a Data Model

The data model

Multiple data tables

Connecting tables

Building relationships

Relationship types

Building visuals from multiple tables

Unpivoting Data

Working with summary data

Unpivoting data

Using Hierarchies

Using built in hierarchies

Drill down

Drill up

See next level

Expand a hierarchy

Create a new hierarchy

Grouping

Grouping text fields

Grouping date and number fields

Creating Measures

DAX functions

DAX syntax

Creating a new measure

Using quick measures

Using the PowerBI Service

Shared workspaces

My workspace

Dashboards

Reports

Datasets

Drill down in dashboards

Focus mode

Using Q&A

Refreshing data

Using Quick Insights

Power BI Mobile App

Using the Power BI Mobile App

Course Images

Power BI Introduction

By Underscore Group

Booking options

Highlights

Description

About The Provider

Tags

Reviews