Full star Half star Star PDF
The Ultimate Training Experience.

Power BI Essentials Course

(4.85 out of 5) 4398 Student Reviews

Microsoft Partner - Dynamic Web Training

About the Course

During this 1-day course, you will learn how to develop and share reports and dashboards using Microsoft Power BI. During the course, students will use excel data sets as examples to explore various features and functionalities of MS Power BI and learn the underlying concepts that make Power BI Desktop such a powerful Business Intelligence tool. Upon completion of this course, students will gain a solid foundational and practical knowledge of the tool which will prepare you for more advanced courses.

Who should do this course?

This course is suitable for excel users who wants to implement BI to create reports and dashboard or SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

For this introductory Power BI course, basic computer literacy is sufficient. However, familiarity with Excel is helpful, but not strictly required.

Course Details

$396 incl GST

  • Duration:1 Days
  • Max. Class Size:10
  • Avg. Class Size:5
  • Study Mode:
    Classroom Online Live
  • Level:Beginner
  • CPD Hours:6 hours
  • Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
  • Download Course PDF
Pay Later

Course Dates

Sydney Class Dates

Level 11, 32 Walker Street, North Sydney , NSW 2060

23 Feb 26 Mon Online Live
25 Feb 26 Wed Online Live
27 Feb 26 Fri Online Live
03 Mar 26 Tue Online Live
05 Mar 26 Thu Classroom
05 Mar 26 Thu Online Live
10 Mar 26 Tue Online Live
11 Mar 26 Wed Online Live
13 Mar 26 Fri Online Live
16 Mar 26 Mon Online Live
17 Mar 26 Tue Online Live
19 Mar 26 Thu Online Live
20 Mar 26 Fri Online Live
23 Mar 26 Mon Classroom
23 Mar 26 Mon Online Live
25 Mar 26 Wed Online Live
27 Mar 26 Fri Online Live
30 Mar 26 Mon Online Live
02 Apr 26 Thu Online Live
07 Apr 26 Tue Online Live
08 Apr 26 Wed Classroom
13 Apr 26 Mon Online Live
15 Apr 26 Wed Online Live
17 Apr 26 Fri Online Live
22 Apr 26 Wed Online Live
23 Apr 26 Thu Online Live
24 Apr 26 Fri Online Live
28 Apr 26 Tue Classroom
28 Apr 26 Tue Online Live
30 Apr 26 Thu Online Live
04 May 26 Mon Online Live
06 May 26 Wed Online Live
08 May 26 Fri Online Live
11 May 26 Mon Online Live
12 May 26 Tue Classroom
13 May 26 Wed Online Live
15 May 26 Fri Online Live
18 May 26 Mon Online Live
20 May 26 Wed Online Live
21 May 26 Thu Online Live
26 May 26 Tue Online Live
28 May 26 Thu Online Live
01 Jun 26 Mon Classroom
01 Jun 26 Mon Online Live
02 Jun 26 Tue Online Live
05 Jun 26 Fri Online Live
10 Jun 26 Wed Online Live
12 Jun 26 Fri Online Live
15 Jun 26 Mon Online Live
17 Jun 26 Wed Online Live
18 Jun 26 Thu Online Live
23 Jun 26 Tue Online Live
24 Jun 26 Wed Classroom
24 Jun 26 Wed Online Live
25 Jun 26 Thu Online Live
26 Jun 26 Fri Online Live
Melbourne Class Dates

Level 12, 379 Collins Street, Melbourne , VIC 3000

23 Feb 26 Mon Online Live
25 Feb 26 Wed Online Live
26 Feb 26 Thu Classroom
27 Feb 26 Fri Online Live
03 Mar 26 Tue Online Live
05 Mar 26 Thu Online Live
10 Mar 26 Tue Online Live
11 Mar 26 Wed Classroom
11 Mar 26 Wed Online Live
13 Mar 26 Fri Online Live
16 Mar 26 Mon Online Live
17 Mar 26 Tue Online Live
19 Mar 26 Thu Online Live
20 Mar 26 Fri Online Live
23 Mar 26 Mon Online Live
25 Mar 26 Wed Online Live
26 Mar 26 Thu Classroom
27 Mar 26 Fri Online Live
30 Mar 26 Mon Online Live
01 Apr 26 Wed Classroom
02 Apr 26 Thu Online Live
07 Apr 26 Tue Online Live
13 Apr 26 Mon Online Live
15 Apr 26 Wed Online Live
17 Apr 26 Fri Online Live
21 Apr 26 Tue Classroom
22 Apr 26 Wed Online Live
23 Apr 26 Thu Online Live
24 Apr 26 Fri Online Live
28 Apr 26 Tue Online Live
30 Apr 26 Thu Online Live
04 May 26 Mon Online Live
06 May 26 Wed Classroom
06 May 26 Wed Online Live
08 May 26 Fri Online Live
11 May 26 Mon Online Live
13 May 26 Wed Online Live
15 May 26 Fri Online Live
18 May 26 Mon Online Live
19 May 26 Tue Classroom
20 May 26 Wed Online Live
21 May 26 Thu Online Live
26 May 26 Tue Online Live
28 May 26 Thu Online Live
01 Jun 26 Mon Online Live
02 Jun 26 Tue Online Live
04 Jun 26 Thu Classroom
05 Jun 26 Fri Online Live
10 Jun 26 Wed Online Live
12 Jun 26 Fri Online Live
15 Jun 26 Mon Online Live
16 Jun 26 Tue Classroom
17 Jun 26 Wed Online Live
18 Jun 26 Thu Online Live
23 Jun 26 Tue Online Live
24 Jun 26 Wed Online Live
25 Jun 26 Thu Online Live
26 Jun 26 Fri Online Live
Brisbane Class Dates

All courses facilitated in, Online Live format , QLD

23 Feb 26 Mon Online Live
25 Feb 26 Wed Online Live
27 Feb 26 Fri Online Live
03 Mar 26 Tue Online Live
05 Mar 26 Thu Online Live
10 Mar 26 Tue Online Live
11 Mar 26 Wed Online Live
13 Mar 26 Fri Online Live
16 Mar 26 Mon Online Live
17 Mar 26 Tue Online Live
19 Mar 26 Thu Online Live
20 Mar 26 Fri Online Live
23 Mar 26 Mon Online Live
25 Mar 26 Wed Online Live
27 Mar 26 Fri Online Live
30 Mar 26 Mon Online Live
02 Apr 26 Thu Online Live
07 Apr 26 Tue Online Live
13 Apr 26 Mon Online Live
15 Apr 26 Wed Online Live
17 Apr 26 Fri Online Live
22 Apr 26 Wed Online Live
23 Apr 26 Thu Online Live
24 Apr 26 Fri Online Live
28 Apr 26 Tue Online Live
30 Apr 26 Thu Online Live
04 May 26 Mon Online Live
06 May 26 Wed Online Live
08 May 26 Fri Online Live
11 May 26 Mon Online Live
13 May 26 Wed Online Live
15 May 26 Fri Online Live
18 May 26 Mon Online Live
20 May 26 Wed Online Live
21 May 26 Thu Online Live
26 May 26 Tue Online Live
28 May 26 Thu Online Live
01 Jun 26 Mon Online Live
02 Jun 26 Tue Online Live
05 Jun 26 Fri Online Live
10 Jun 26 Wed Online Live
12 Jun 26 Fri Online Live
15 Jun 26 Mon Online Live
17 Jun 26 Wed Online Live
18 Jun 26 Thu Online Live
23 Jun 26 Tue Online Live
24 Jun 26 Wed Online Live
25 Jun 26 Thu Online Live
26 Jun 26 Fri Online Live
Canberra Class Dates

All courses facilitated in, Online Live format , ACT

23 Feb 26 Mon Online Live
25 Feb 26 Wed Online Live
27 Feb 26 Fri Online Live
03 Mar 26 Tue Online Live
05 Mar 26 Thu Online Live
10 Mar 26 Tue Online Live
11 Mar 26 Wed Online Live
13 Mar 26 Fri Online Live
16 Mar 26 Mon Online Live
17 Mar 26 Tue Online Live
19 Mar 26 Thu Online Live
20 Mar 26 Fri Online Live
23 Mar 26 Mon Online Live
25 Mar 26 Wed Online Live
27 Mar 26 Fri Online Live
30 Mar 26 Mon Online Live
02 Apr 26 Thu Online Live
07 Apr 26 Tue Online Live
13 Apr 26 Mon Online Live
15 Apr 26 Wed Online Live
17 Apr 26 Fri Online Live
22 Apr 26 Wed Online Live
23 Apr 26 Thu Online Live
24 Apr 26 Fri Online Live
28 Apr 26 Tue Online Live
30 Apr 26 Thu Online Live
04 May 26 Mon Online Live
06 May 26 Wed Online Live
08 May 26 Fri Online Live
11 May 26 Mon Online Live
13 May 26 Wed Online Live
15 May 26 Fri Online Live
18 May 26 Mon Online Live
20 May 26 Wed Online Live
21 May 26 Thu Online Live
26 May 26 Tue Online Live
28 May 26 Thu Online Live
01 Jun 26 Mon Online Live
02 Jun 26 Tue Online Live
05 Jun 26 Fri Online Live
10 Jun 26 Wed Online Live
12 Jun 26 Fri Online Live
15 Jun 26 Mon Online Live
17 Jun 26 Wed Online Live
18 Jun 26 Thu Online Live
23 Jun 26 Tue Online Live
24 Jun 26 Wed Online Live
25 Jun 26 Thu Online Live
26 Jun 26 Fri Online Live
Adelaide Class Dates

All courses facilitated in, Online Live format , SA

23 Feb 26 Mon Online Live
25 Feb 26 Wed Online Live
27 Feb 26 Fri Online Live
03 Mar 26 Tue Online Live
05 Mar 26 Thu Online Live
10 Mar 26 Tue Online Live
11 Mar 26 Wed Online Live
13 Mar 26 Fri Online Live
16 Mar 26 Mon Online Live
17 Mar 26 Tue Online Live
19 Mar 26 Thu Online Live
20 Mar 26 Fri Online Live
23 Mar 26 Mon Online Live
25 Mar 26 Wed Online Live
27 Mar 26 Fri Online Live
30 Mar 26 Mon Online Live
02 Apr 26 Thu Online Live
07 Apr 26 Tue Online Live
13 Apr 26 Mon Online Live
15 Apr 26 Wed Online Live
17 Apr 26 Fri Online Live
22 Apr 26 Wed Online Live
23 Apr 26 Thu Online Live
24 Apr 26 Fri Online Live
28 Apr 26 Tue Online Live
30 Apr 26 Thu Online Live
04 May 26 Mon Online Live
06 May 26 Wed Online Live
08 May 26 Fri Online Live
11 May 26 Mon Online Live
13 May 26 Wed Online Live
15 May 26 Fri Online Live
18 May 26 Mon Online Live
20 May 26 Wed Online Live
21 May 26 Thu Online Live
26 May 26 Tue Online Live
28 May 26 Thu Online Live
01 Jun 26 Mon Online Live
02 Jun 26 Tue Online Live
05 Jun 26 Fri Online Live
10 Jun 26 Wed Online Live
12 Jun 26 Fri Online Live
15 Jun 26 Mon Online Live
17 Jun 26 Wed Online Live
18 Jun 26 Thu Online Live
23 Jun 26 Tue Online Live
24 Jun 26 Wed Online Live
25 Jun 26 Thu Online Live
26 Jun 26 Fri Online Live
Perth Class Dates

All courses facilitated in, Online Live format , WA

23 Feb 26 Mon Online Live
25 Feb 26 Wed Online Live
27 Feb 26 Fri Online Live
03 Mar 26 Tue Online Live
05 Mar 26 Thu Online Live
10 Mar 26 Tue Online Live
11 Mar 26 Wed Online Live
13 Mar 26 Fri Online Live
16 Mar 26 Mon Online Live
17 Mar 26 Tue Online Live
19 Mar 26 Thu Online Live
20 Mar 26 Fri Online Live
23 Mar 26 Mon Online Live
25 Mar 26 Wed Online Live
27 Mar 26 Fri Online Live
30 Mar 26 Mon Online Live
02 Apr 26 Thu Online Live
07 Apr 26 Tue Online Live
13 Apr 26 Mon Online Live
15 Apr 26 Wed Online Live
17 Apr 26 Fri Online Live
22 Apr 26 Wed Online Live
23 Apr 26 Thu Online Live
24 Apr 26 Fri Online Live
28 Apr 26 Tue Online Live
30 Apr 26 Thu Online Live
04 May 26 Mon Online Live
06 May 26 Wed Online Live
08 May 26 Fri Online Live
11 May 26 Mon Online Live
13 May 26 Wed Online Live
15 May 26 Fri Online Live
18 May 26 Mon Online Live
20 May 26 Wed Online Live
21 May 26 Thu Online Live
26 May 26 Tue Online Live
28 May 26 Thu Online Live
01 Jun 26 Mon Online Live
02 Jun 26 Tue Online Live
05 Jun 26 Fri Online Live
10 Jun 26 Wed Online Live
12 Jun 26 Fri Online Live
15 Jun 26 Mon Online Live
17 Jun 26 Wed Online Live
18 Jun 26 Thu Online Live
23 Jun 26 Tue Online Live
24 Jun 26 Wed Online Live
25 Jun 26 Thu Online Live
26 Jun 26 Fri Online Live

Course Units

Unit 1: Understanding Business Intelligence

  • Why is Data Analytics Important?
  • Why is conventional Data Analysis Process inefficient?
  • What is Business Intelligence?
  • Steps & concepts involved in Business Intelligence
  • Other BI Tools in the Market
  • What is Self Service BI?

Unit 2: Understanding Power BI

  • Power BI (Desktop Vs Mobile Vs Service)
  • Licenses (Free Vs Pro Vs Premium)
  • What makes Power BI different from other BI Tools?
  • Frequent Updates and Changes
  • BI Steps in Power BI
  • Languages Involved in Power BI (Power Query, DAX, R)

Unit 3: Getting Started with Power BI

  • Setting up Office 365 Enterprise E3 trial account
  • Signing up for Power BI
  • Upgrading to Power BI PRO
  • Downloading Power BI Desktop

Unit 4: Getting Data in Power BI Desktop

  • Understanding Power BI Navigation
  • Discussing Different Data Sources in Power BI
  • Getting Data from Excel

Unit 5: Data Transformation

  • Navigating Query Editor
  • What is Query?
  • What is Data Transformation?
  • Removing empty rows
  • Removing irrelevant Columns
  • Renaming Columns
  • Changing Data Types
  • Duplicating Columns
  • Splitting Columns
  • Merging Columns
  • Correcting Spelling Mistakes
  • Changing cases
  • Trimming & Cleaning

Unit 6: Introduction to Power Query (M Formula Language)

  • Exploring Applied Steps
  • Introducing idea of repeatable workflows
  • Updating Applied Steps
  • Deleting Applied Steps
  • Renaming Applied Steps
  • Understanding the Code behind every step
  • Automating Data Transformation process via repeatable workflows
  • Exploring Advanced Editor
  • Loading and Applying Data

Unit 7: Data Modelling

  • Understand Navigation of Relationship view
  • What is Data Model?
  • What is a unique Identifier?
  • Creating a new relationship
  • Editing a relationship
  • Updating a relationship
  • Understanding Cardinality
  • Understanding Cross Filter Direction
  • Why is Data Model more efficient than a Flattened Data Set?

Unit 8: Introduction to DAX

  • What can we calculate using DAX?
  • What is Calculated Columns and Calculated Measure?
  • How is DAX different from Excel Functions?
  • Calculating a column using DAX
  • Calculating a measure using DAX
  • Formatting Data types
  • Changing property of a Data Type

Unit 9: Data Visualization

  • Understand Navigation of Report View
  • Creating a Bar Chart
  • Formatting a Bar Chart
  • Changing Chart Type
  • Creating and Formatting a Column Chart
  • Creating and Formatting a Line Chart
  • Creating and Formatting a Pie Chart
  • Creating and Formatting a Tree Chart
  • Creating and Formatting a Card
  • Creating and Formatting a Matrix
  • Creating and Formatting a Table
  • Creating and Formatting BubbleMap Visualization
  • Creating a Filled Map Visualization

Unit 10: Creating Custom Visuals

  • Getting Custom Visuals from the Store
  • Creating Sankey Chart
  • Creating Radar Chart

Unit 11: Visual Interaction

  • Understanding Visual Interaction
  • Turning visual interaction on and off

Unit 12: Exploring Filters

  • Cross Filtering through visuals
  • Creating a slicer
  • Visual level filter
  • Page Level Filter
  • Report Level Filter
  • Drill through filter
  • Top N Filter

Unit 13: Creating Custom Slicers

  • Getting Custom Slicer From Store
  • Creating Enlighten Word Flag Slicer
  • Creating Chiclet Slicer
  • Inserting Images in Chiclet Slicer

Unit 14: Exploring Power BI Desktop Features

  • Exploring visual options (focus mode, show data, spotlight, export)
  • Create and Duplicate New Pages
  • Create image, text boxes and shapes
  • Switch between phone and web layout
  • Save the report
  • Print the report
  • Publish report to Power Bi Service

Unit 15: Power Bi service Features

  • Log in to Power Bi Service
  • Understand Navigation
  • Opening and Editing your report in Power BI service
  • Publishing to web
  • Converting report to a Power Point
  • Generating a QR Code
  • How to get Data directly into Power Bi Service
  • Importing Data Vs Uploading Data

Unit 16: Dashboard

  • Pin visuals from report to dashboard
  • Difference between report and dashboard
  • Why visual interaction isn't supported in Dashboards
  • Resizing and moving a visual
  • Creating a video tile
  • Creating an image tile
  • Applying alert on Card
  • Pinning complete report to Dashboard
  • Customizing dashboard for mobile view
  • Sharing dashboard with colleagues
  • Viewing Shared Reports

Unit 17: Natural Language Query

  • What is NLQ and why is it a breakthrough
  • Create a Card using NLQ
  • Create a Table Using NLQ
  • Create Bar Visual Using NLQ
  • Pin the visuals directly to your dashboard

Unit 18: Power Bi publisher for excel

  • Installing the Add-in
  • Activating this Add-in in Excel
  • Connect your Excel Workbook with Power Bi
  • Pin a chart from Excel to Power Bi Dashboard
  • Pin a pivot table from Excel to Power Bi Dashboard
  • Update the Chart in Power Bi Dashboard from Excel

Unit 19: Quick Insights

  • What is Quick Insight Tool?
  • How to create quick insights of a dataset
  • Explore visuals created by this option
  • Pin a visual to dashboard

Unit 20: Sample Reports and Dashboard

  • Getting the Sample reports and Dashboard
  • How samples are very helpful?
  • Editing sample reports and dashboard

Unit 21: Power Bi mobile

  • Downloading power bi mobile app and logging in
  • Understand Navigation
  • How to see underlying reports
  • Annotate visuals and share using other apps
  • How to see our own dashboard
  • How to see dashboard shared with us
  • See report using QR scanner
  • Exploring mobile sample reports

Training Packages

Power BI Training Package

$ 2541 incl GST
(You save $330)
Total Duration
6 days
Pay Later

Related Courses

Excel Advanced Course
Excel Advanced
(4.85 out of 5)
$385.00
Learn More
Power BI Report Design Course
Power BI Report Design
(4.87 out of 5)
$495.00
Learn More
Power BI Advanced Course
Power BI Advanced
(4.89 out of 5)
$990.00
Learn More
Power BI DAX Essentials Course
Power BI DAX Essentials
(4.91 out of 5)
$990.00
Learn More

Student Reviews

(5.0)
20 February, 2026

The instructor Ali Noorani was able to explain things very well, I liked the use of whiteboard and drawing on the page

Mel G
(5.0)
20 February, 2026

This course was extremely helpful, useful and enlightening. Thanks so much to Ali, he has been amazing, very knowledgeable and passionate and great at explaining Power BI

Marisa S
(4.8)
20 February, 2026

Fantastic course, very practical and I love you made sure everyone can keep up as we had different levels of prior Power BI experience.

Beau H
(4.1)
20 February, 2026

Morning session was easy to follow, the afternoon session seemed to be done quicker and a bit harder to follow

Liza M
(5.0)
20 February, 2026

Ali is an excellent instructor which made the learning work [for a complex subject]. Highly recommend this course because of my experience with Ali as the instructor - engaging, practical, good pace, supportive.

Chrissy C
(4.8)
20 February, 2026

The execution of the course was really good and really happy how the instructor answered all the questions patiently. thank you. However, this course is more suitable for someone who is very new to PowerBi. I'm not one of them. I have some basic understanding of PowerBI. At the same time learn stuff that I was not aware in this course too. I am registered with the Advance Power BI course as well. I feel that will add alot of value to me. Overall agood experience.

Vidath J
(5.0)
19 February, 2026

Paul was an amazing instructor. At the beginning he promised that he won't leave anyone behind and he really did. Everyone made great progress as a group. Paul explained all complicated concepts clearly.

Dharshani C
(4.6)
19 February, 2026

Very well paced to enable all levels of learners to follow and not fall behind. The instructor Paul made it very interactive which made sure we all paid attention and remained focus.

Michelle M
(5.0)
19 February, 2026

- Paul was incredibly engaging to listen to for a product that requires many steps - Very patient and made sure we were all on the same page, which is extremely difficult to do live and on a strict time schedule - The way the transitions from excel and powerBI was done was very straight forward, esp for people that are beginners for both tools - Great pointers on what notes to take down and also references them throughout the session - Represented the tool as it is - allowing us to understand the benefits but also the areas to be careful with when using it - Did a fantastic job at differentiating why we're covering the things we did in a beginners course vs a more advance one Overall, very pleased and excited to incorporate this tool into our workflow!

Alieca
(5.0)
19 February, 2026

This was an excellent training course made even more enjoyable by Paul who was so fun, engaging and supportive. Paul explained the concepts clearly and I loved the additional tips on how best to use Excel.

Vanessa L
(5.0)
16 February, 2026

Course was great for a beginner, the trainer was excellent at explaining each step and at a good pace, easy to learn from the trainer, not all trainers can train.

Sharon
(5.0)
16 February, 2026

Danny was extremely knowledgeable, great at presenting, and always stopped to pan for questions, the pace at which he delivered the training was perfect, and we even touched on a few extra things. thank you Danny!

Ryan G
(4.6)
16 February, 2026

Course was good. Moved a bit slow at some points, but was good for beginners. Checked in after every exercise was good. I learnt a lot.

Corben J
(5.0)
16 February, 2026

Presenter was excellent, set information out in a really logical way that I was able to follow, even though I am technologically incompetent! He left space for questions and for us to implement the processes that he described.

Rachel
(5.0)
16 February, 2026

Super helpful and comprehensive session. Jay was an excellent teacher and offered really helpful examples for how Power BI can be used in different business contexts.

Brad
Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Note: Form fields marked with * are required.

Your details
Please enter a valid email address for shipping updates.
I am enquiring about a...
Complete Power BI Package

Book our 4 core Power BI course together and
SAVE $330


For more info please

Call 1300 888 724

View Package Details

REQUEST A CALLBACK
A team member will call you at a time convenient to you.
Your message was sent, thank you!
Contact us

Level 11, 32 Walker Street, North Sydney NSW, 2060