Microsoft Power BI - Intermediate

Length 1 day

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.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Book now!

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 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.