Got a question? Call  0800 835 835    |   
Contact usCheckoutContact us
Microsoft Power BI - Intermediate
Main menu
Got a question? Contact us
or call  +64 0800 835 835
Data and Analytics - Category Banner

Microsoft Power BI - Intermediate

  • Length 1 day
  • Price  NZD 685 exc GST
Course overview
View dates &
book now

Why study this course

Power BI is Microsoft's powerful data visualisation tool that is commonly used for business analytics. With the ability to connect to data, clean and transform it, and create interactive dashboards, users can gain valuable insights to support informed decision-making. In our courses, you will gain hands-on experience using both Power BI Desktop and the Power BI service to create compelling visualisations. Learning Power BI has never been easier, and our courses will provide you with the skills you need to leverage this powerful tool effectively.

Learn how to enrich data models to produce powerful interactive dashboards with this one-day course. You will work on data transformations, measures, DAX, Row Level Security, using Power Query and creating Advanced Visualisations. Our Microsoft-certified trainers make it easy to learn how to manipulate data in Power BI.

Request Course Information

What you’ll learn

At the completion of this course you should be able to:

  • Work with data from many sources

  • Build calculations in the data model to produce intelligent, interactive dashboards in one of the premier BI tools on the market

  • Collaborate with colleagues and publish to the web

Microsoft Solutions Partner - Cloud - Training Services Logo

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level.  We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ. 

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This intermediate course is designed for individuals who want to explore data analytics and data models necessary for data transformation.

Course subjects

Power BI Overview

  • An introduction to the different Power BI Products

  • When to use Power BI Desktop Free, Pro and Premium

  • Online services and databases that Power BI can connect to

The Business Intelligence Process

  • Power BI in the business intelligence industry

  • A day in the life of Power BI

Data Model & Transformation

  • Data transformation principles

  • Data normalisation

  • Fact and dimension tables

  • The data model

  • Star schema

  • Snowflake schema

  • Optimising the data model

Get Data

  • Data sources

  • The dataset

  • Get data from a SharePoint list

  • Get data from an Excel worksheet

  • Get data from an Azure SQL database

  • Import vs DirectQuery

Power Query Editor

  • Power Query user interface

  • Queries pane

  • Data pane

  • Ribbon

  • Query Settings

Data Transformations

  • Filter data

  • Rename queries

  • Group queries

  • Remove top rows

  • Use first row as headers

  • Rename columns

  • Duplicate columns

  • Split columns

  • Rename Applied Steps

  • Format data

  • Unpivot columns

  • Conditional columns

  • Fill values

  • Reorder columns

  • Combine queries

  • Append

  • Merge

  • Replace values

  • Custom columns

  • Remove columns

  • Evaluate and change column data types

Check the Data: Profiling

  • Column quality

  • Column distribution

  • Column profile

Date Transformations

  • Auto Date/Time

  • Create a date dimension table

  • Dynamic date dimension tables

  • Extract date components as columns

  • Fiscal quarter and fiscal year

Load Data

  • Include in report refresh

  • Enable load

  • Query dependencies

  • Advanced Editor

  • Close and Apply

Data Modelling

  • The importance of a good data model

  • Manage relationships

  • Relationship cardinality

  • Cross-filter direction

  • Typical cardinality and cross filtering

  • Modify data formats

Data Analysis Expressions (DAX)

  • What is DAX?

  • M (Power Query) language vs DAX

  • Calculated columns

  • Create and use a calculated column

  • Measures

  • Create and use measures

  • Implicit vs explicit measures

  • Filter context and measures

  • Referring to measures and calculated columns

  • Simple DAX functions

The X Functions

  • Calculating values row-by-row in a measure

  • X functions vs aggregators and calculated columns

Quick Measures

  • Quick measure categories

  • Aggregate per category

  • Filters

  • Totals

  • Mathematical operations

  • Text

Time Intelligence Quick Measures

  • Auto date/time option

  • Mark as date table

  • Visuals for date/time reporting

  • Quick measure using an existing measure

Secure and Share Data

  • Online sharing

  • Introduction to row-level security (RLS)

  • Multi-row cards

  • Testing row-level security

  • Power BI workspaces

  • Apps

  • Add users to RLS roles

  • Unpublish an app

  • Delete a workspace

Extended Content: More Visualisations

  • Combo charts

  • Small multiples

  • Waterfall charts

  • Drill-down charts

  • What if analysis

  • Bookmarks

  • Buttons to navigate bookmarks

Appendix: Database Normalisation

  • The Normal Forms

  • 1st Normal Form

  • 2nd Normal Form

  • 3rd Normal Form

  • Primary Keys

  • Relationships

Prerequisites

Students should have completed the Power BI Beginner course or have a basic understanding of Power BI Desktop, including sourcing and preparing data.

Familiarity with building visuals and dashboards in Power BI is helpful but not essential.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Select and book a course

January
February
March

Can't find a date you like?

Contact sales

Looking for more course options?

View all Microsoft Apps coursesView all Data and Analytics coursesView all End User Applications courses

Offers

Accelerate Copilot adoption with up to 50% off training
The promise of AI and Microsoft 365 Copilot in particular is clear. Microsoft research demonstrates that Copilot adoption results in: Significant time savings across departments Improved efficiency in document creation and communication Enhanced employee satisfaction and reduced repetitive tasks Copilot boosts creativity and makes data-driven insights more accessible than ever before. But how can businesses realise these benefits at scale? As the 2024 Work Trend Annual Report noted: “We’ve come to the hard part of any tech disruption: moving past experimentation to business transformation. Just as we saw with the advent of the internet or the PC, business transformation comes with broad adoption.”
Find out more