Course details

Duration: half-day

Location: This course is run virtually online.

This introduction to Power BI Desktop provides a condensed look at the process of data analysis. Starting with importing tables from Excel, and once we have that in Power BI, it focuses on transforming and cleaning it in the Query Editor. Then it looks at outputting the resulting data sets in visualisations to create an interactive dashboard.

Prerequisite

Some knowledge of using Microsoft Excel is preferable.

Learning objectives

Getting started

  • Launch Power BI Desktop
  • The four views of Power BI
  • The report canvas

Connect to data

  • Connect to and Excel file
  • Connect to a web source

Transform data in the Query Editor

  • Remove rows by filter
  • Replace values
  • Field data types
  • Fill data up and down
  • Split column by delimiter

Introduction to DAX measures

  • Create a SUM measure
  • The COUNTROWS measure
  • The DISTINCTCOUNT measure
  • DAX rules

Report visualisations

  • Create and format maps
  • Create and format charts
  • Table and card visuals
  • Control number formats
  • Use slicers to filter reports