Microsoft Power BI Visualisations

Course Overview

An full encompassing course of Microsoft Power BI that will cover the power of data visualization and will provide infrastructures for visualization, dashboard and reports using Microsoft BI toolkits.

It covers everything from the basics of the tool to advance concepts including planning, creating visualizations, dashboards and reports.

Course Details

Charts

• Working with charts

• Specific chart type issues

• Grouping and binning

Creating a Basic report

• Getting data

• Basic visualisations

• Shapes, text boxes and images

Filtering data

• Slicers

• Visualisation level filters

• Hierarchies and re-usable Hierarchies

• Drill with Dates

Other types of visualisations

• Working with matrices

• Working with cards

Advanced Filters and Views

• Grouping and pivoting

• Grouping with Bins

• Filter combinations

• Creating new columns

Formatting visualisations

• The formatting panes

• Conditional formatting

Overview of Power BI Desktop

Overview of a pbix file and introduction to:

• Views: Reports (visualisations); Tables and Relationships

• Visualisations: Treemap; Funnel; Map; Clustered Column Charts

• Page Tab

• Focus Mode

• Tool tips

Maps

• Geo Data

• Data Categorisation and Maps

Parameters

• Creating parameters

• Filtering by parameter

Data sources and Query Editor

Connecting to:

• Access databases

• Excel / text files

• Websites and web services

• Pasting data

• Filtering rows

• Manipulating columns

• Working with data types

Dashboard visualisations

• Gauges

• KPIs

Drill-down

• Interactions

• “See records” feature