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

Data Model & Transformation

Data transformation principles
Fact and dimension tables
The data model
Star schema
Snowflake schema
Optimising the data model

Get Data

Data sources
The dataset from Excel
From Folder
Power Query Editor
Power Query user interface
Queries pane
Data pane
Ribbon
Query Settings

Data Transformations

Data Model in Desktop
Filter data
Rename queries
Remove columns
Unpivot columns
Conditional columns
Fill values
Reorder columns
Combine queries
Append
Merge
Replace values
Custom columns
Evaluate and change column data types

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
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
Create and use a calculated column
Create and use measures
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 / CALCULATE
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

Field Parameters

Create 2 Field parameters
Change the slicer setting to single select
Add a bar chart using the parameters as fields

Bookmarks

Format the buttons and assign bookmarks

Power BI Service

Select Workspaces → create new workspace → Add people
Explore different Access Rights
Return to PBI Desktop
Save and Publish report to your workspace

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.

M365 Adoption and Training Plans

Our aim is to help educate and enable your organisation to get the best return on your Microsoft 365 investment.

Learn more

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.