MS Power BI
Training Courses

Power BI is used to collate and report on data. The data may be spread across Excel spreadsheets, Access or SQL Server databases, SharePoint lists or a wide variety of other sources. Power BI allows you to connect to various data sources and create reports without having to copy-and-paste between programmes.

Power BI is a relatively young programme, first released in 2015. Much of the core functionality of the programme had been previously developed for SQL Server and the “Power” add-ins for Excel, previously known as PowerQuery, PowerPivot and PowerView.

Please contact us for further details.

Course Type Cost per day
1 to 1 training$575 + GST
2 to 3 delegates $1195 + GST
4 to 5 delegates$1495 + GST
6 to 8 delegates$1795 + GST

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay $1495 + GST.

Aims of the course

This course aims to give delegates a practical understanding of the ways in which Power BI can help them in analysing and presenting critical business information.

Course Objectives

On completion of the course, delegates will be able to create multiple visualizations and interactive dashboards using Power BI.

They will be able to:

  • Connect to Data with Power BI
  • Data Manipulation
  • Visualizations
  • Data Analysis Expressions (DAX)

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with Excel is required. An understanding of relationships, Get & Transform and Power View are an advantage.


Connect to Data with Power BI

  • What is Power BI?
  • Components of Power BI
  • A Crash-Course in Databases
  • Connect to Excel
  • Select Which Data to Load
  • View the Data
  • Clean Data in Data View
  • Clean Data in the Query Editor
  • Undo Applied Steps in Query Editor
  • Choose Columns
  • Close the Query Editor
  • Save and Close the Report
  • Connect to a Database Query
  • Connect Directly to Access Tables
  • View the Relationship in Model View
  • Select the Required Fields
  • Connect to a CSV file
  • Combine Files from a Folder
  • Add Internet Data to a Report
  • Relate the Tables using Model View Data Manipulation

Open an Existing Report

  • Add a Calculated Custom Column
  • View Query Formulae
  • Rename an Applied Step
  • Remove a Custom Column
  • Group Rows
  • Add another Aggregation
  • Add a Grouping
  • Pivot a Column
  • Select Pivoted Columns
  • Sort and Filter Data
  • Use Inbuilt Functions in a Custom Column

Visualizations

  • Visualizations
  • A Note on Design
  • Add a Simple Chart Visualization
  • Format the Chart
  • Change the Chart Type
  • Create a Table Visualization
  • Add a Map Visualization

Formatting

  • Add and Rename a New Page
  • Add a Gauge Visualization
  • Format Numbers on the Gauge
  • Add Timescaled Data
  • Drill Mode
  • Add a Slicer Data Analysis Expressions (DAX)

DAX and Measures

  • DAX Syntax
  • Create a Measure
  • Use Measures in Visualisations
  • Link Another Data Source
  • Create a Hierarchy
  • CALCULATE Function using ALL
  • CALCULATE Function using FILTER
  • RELATED Function
  • PREVIOUSQUARTER Function
  • TOTALYTD Function