Course details

Duration: 1-day

Location: This course is run virtually online or face-to-face onsite.

Power BI is a powerful data visualisation tool that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the visualisations in reports, the dashboards, where users interact with dynamic visuals to communicate trends in data.

The course focuses entirely on the creation and design of dashboard visuals, including a range of chart types, engaging maps, and different types of tables. With a rich array of design tools including KPI’s (key performance indicators), heatmaps, flowcharts, sparklines, and comparing multiple variables with trendlines.

Prerequisite

My assumption is you are already using Power BI and your only requirement is to learn about dashboard visualisations. If not, I recommend attending the Power BI Introduction course first.

Learning objectives

Lesson 1. Introduction

  • Power BI ecosystem
  • Things to keep in mind
  • Selecting dashboard colours
  • Importing online visuals
  • Data sources for analysis
  • Table relationships in Power BI

Lesson 2. Working with Data

  • Utilising a report theme
  • Table visuals
  • Matrix visuals
  • Drilling into hierarchies
  • Applying static filters
  • Creating lists
  • Creating bins
  • Using measures in dashboard visuals

Lesson 3. Creating Visuals

  • Heatmaps in Power BI
  • Visualizing time-intelligence trends
  • Ranking categorical totals
  • Comparing proportions
  • Display data labels as percentages
  • Viewing trends with sparklines
  • Setting up a histogram chart

Lesson 4. Comparing Variables

  • Inserting key performance indicators (KPI)
  • Visualising trendlines as KPI
  • Forecasting with trendlines
  • Analyse data with violin plots
  • Visualising flows with Sankey diagrams

Lesson 5. Mapping Options

  • Mapping with hierarchies
  • Mapping with ArcGIS or ESRI
  • Mapping flow patterns

Lesson 6. Creating Dashboards

  • High-level dashboard
  • Adding slicers for filtering
  • Promote interaction with nudge prompts
  • Creating dynamic labels
  • Customised visualisation tooltips
  • Activating and deactivating slicers
  • Setting up phone view
  • Exporting data

Lesson 7. Sharing Dashboards

  • Publishing to the cloud
  • Editing online reports
  • Exporting as PDF and PowerPoint files
  • Share dashboards in SharePoint online