Full star Half star Star PDF
Beginner · 1 Day · $396 incl GST

Power BI Essentials Course

A 1-day beginner course for anyone new to Power BI: $396, taught live by a Microsoft Certified Trainer with a maximum of 10 students. Connect to your data, clean it in Power Query, build a data model and create interactive reports and dashboards you can share. Join Online Live from anywhere in Australia, or train in person in Sydney or Melbourne.
4.85 / 5 from 4,738 student reviews Microsoft Partner - Dynamic Web Training Classroom · Online Live Australia wide

About the Power BI Essentials Course

Power BI Essentials is a 1-day beginner course ($396 incl GST, 6 CPD hours), taught live by a Microsoft Certified Trainer Online Live or in our Sydney and Melbourne classrooms, with a maximum of 10 students. No prior Power BI experience is needed.

You learn how to develop and share reports and dashboards using Microsoft Power BI, using Excel datasets as examples to explore the features of Power BI Desktop and the concepts that make it such a powerful business intelligence tool. By the end of the day you have solid foundational and practical knowledge of Power BI, ready for the more advanced courses. Not sure this is the right level? Compare all our Power BI courses.

What you'll be able to do

  • Explain what business intelligence is and how Power BI Desktop, the Power BI Service and Power BI Mobile fit together
  • Get data from Excel into Power BI Desktop and explore other data sources
  • Clean and shape data in Power Query and reuse the applied steps
  • Build a data model with relationships, cardinality and cross filter direction
  • Create calculated columns and measures with DAX
  • Build interactive reports with charts, maps, tables, slicers and filters
  • Publish reports to the Power BI Service, build dashboards and share them with colleagues
  • Explore data with natural language questions and the Power BI Mobile app

Who should do this course?

This course is for anyone new to Power BI who wants to turn data from Excel, databases and other sources into clear reports and dashboards, including business users, analysts and managers who report on data.

Prerequisites

No prior Power BI experience is needed. Familiarity with Excel is helpful but not required.

Power BI Essentials Course Details

$396 incl GST per person
  • Duration1 Day
  • CPD Hours6 hours
  • LevelBeginner
  • Class Size10 max · 5 avg
  • Study modesClassroom or Online Live
  • Course Times 9.00am to 5.00pm approx Classroom (local time) or Online Live (AEST/AEDT)

Pay Later available ?

Class Dates

Power BI Essentials course dates

December 2026
02
Dec
Wed ยท 02 Dec 26
Online Live ยท Instructor-led
02
Dec
Wed ยท 02 Dec 26
Online Live ยท Instructor-led
07
Dec
Mon ยท 07 Dec 26
Classroom ยท Melbourne
09
Dec
Wed ยท 09 Dec 26
Online Live ยท Instructor-led
14
Dec
Mon ยท 14 Dec 26
Online Live ยท Instructor-led
14
Dec
Mon ยท 14 Dec 26
Classroom ยท Melbourne
17
Dec
Thu ยท 17 Dec 26
Online Live ยท Instructor-led
January 2027
13
Jan
Wed ยท 13 Jan 27
Online Live ยท Instructor-led
14
Jan
Thu ยท 14 Jan 27
Classroom ยท Melbourne
18
Jan
Mon ยท 18 Jan 27
Classroom ยท Sydney
20
Jan
Wed ยท 20 Jan 27
Online Live ยท Instructor-led
21
Jan
Thu ยท 21 Jan 27
Online Live ยท Instructor-led
27
Jan
Wed ยท 27 Jan 27
Online Live ยท Instructor-led
28
Jan
Thu ยท 28 Jan 27
Online Live ยท Instructor-led
29
Jan
Fri ยท 29 Jan 27
Classroom ยท Melbourne
February 2027
03
Feb
Wed ยท 03 Feb 27
Online Live ยท Instructor-led
05
Feb
Fri ยท 05 Feb 27
Online Live ยท Instructor-led
09
Feb
Tue ยท 09 Feb 27
Online Live ยท Instructor-led
09
Feb
Tue ยท 09 Feb 27
Classroom ยท Melbourne
10
Feb
Wed ยท 10 Feb 27
Online Live ยท Instructor-led
15
Feb
Mon ยท 15 Feb 27
Online Live ยท Instructor-led
17
Feb
Wed ยท 17 Feb 27
Classroom ยท Sydney
18
Feb
Thu ยท 18 Feb 27
Online Live ยท Instructor-led
22
Feb
Mon ยท 22 Feb 27
Online Live ยท Instructor-led
23
Feb
Tue ยท 23 Feb 27
Online Live ยท Instructor-led
26
Feb
Fri ยท 26 Feb 27
Classroom ยท Melbourne
March 2027
02
Mar
Tue ยท 02 Mar 27
Online Live ยท Instructor-led
04
Mar
Thu ยท 04 Mar 27
Online Live ยท Instructor-led
10
Mar
Wed ยท 10 Mar 27
Classroom ยท Melbourne
11
Mar
Thu ยท 11 Mar 27
Online Live ยท Instructor-led
12
Mar
Fri ยท 12 Mar 27
Online Live ยท Instructor-led
16
Mar
Tue ยท 16 Mar 27
Online Live ยท Instructor-led
17
Mar
Wed ยท 17 Mar 27
Online Live ยท Instructor-led
19
Mar
Fri ยท 19 Mar 27
Online Live ยท Instructor-led
22
Mar
Mon ยท 22 Mar 27
Classroom ยท Sydney
23
Mar
Tue ยท 23 Mar 27
Online Live ยท Instructor-led
25
Mar
Thu ยท 25 Mar 27
Online Live ยท Instructor-led
31
Mar
Wed ยท 31 Mar 27
Classroom ยท Melbourne
April 2027
14
Apr
Wed ยท 14 Apr 27
Classroom ยท Melbourne
21
Apr
Wed ยท 21 Apr 27
Classroom ยท Sydney
27
Apr
Tue ยท 27 Apr 27
Classroom ยท Melbourne
May 2027
12
May
Wed ยท 12 May 27
Classroom ยท Melbourne
17
May
Mon ยท 17 May 27
Classroom ยท Sydney
26
May
Wed ยท 26 May 27
Classroom ยท Melbourne
June 2027
07
Jun
Mon ยท 07 Jun 27
Classroom ยท Melbourne
16
Jun
Wed ยท 16 Jun 27
Classroom ยท Sydney
21
Jun
Mon ยท 21 Jun 27
Classroom ยท Melbourne
No dates match your selected filter

Looking for Power BI Essentials dates?

There are currently no scheduled dates matching your selected filter, but we'd love to assist. Get in touch with our team to discuss your individual training needs or corporate group requirements, and we'll explore available options with you.

Bundle & Save

Training Packages

You save $330 4 courses · 6 days

PL-300 Power BI Training Package

$2,541 incl GST
Value $2,871 · save $330

Pay later available ?

Course Content

What the Power BI Essentials course covers

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

  • Signing up for Power BI
  • 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 Visualisation

  • 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: Dashboards

  • 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: 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 19: Sample Reports and Dashboards

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

Unit 20: 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
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.90 out of 5)
$990.00
Learn More
Excel Advanced Course
Excel Advanced
(4.82 out of 5)
$385.00
Learn More
Student Reviews

What students say about this course

(5.0)
12 November, 2026

Found this course really informative and even potentially helped me solve an issue I've had with PBI for 8+ years (formatting M to m for millions). Adam delivered it very well. Great intro.

Justin T
(5.0)
12 November, 2026

The course was easy to follow and engaging. The instructor led the course really well and kept it engaging.

Anonymous
(5.0)
12 November, 2026

I found this course to be very easy to follow with clear instructions and at very good pace for us beginners.

Felisia D
(5.0)
12 November, 2026

The course was a great starting point to begin Power BI usage. Sean Misso was a fantastic teacher/trainer. His presentation style was calm and orderly, taking ample time to address questions and troubleshoot seemingly without sacrificing content coverage.

cam
(5.0)
12 November, 2026

I loved this course. The presenter Sean was so patient and easy to listen to and understand. The examples we worked through were relatable to my work so I can see how I will use Power BI to enhance the data we collect and share.

Rose K
(5.0)
12 November, 2026

Sean have been an excellent trainer with great and knowledgeable leading us with indepth insight into PowerBi.

Kelvin
(5.0)
12 November, 2026

The course was easy to follow and provided enough detail without being too challenging. I was not at all familiar with PowerBI and the standard and pace of the course was perfect. Sean was an excellent instructor.

Victoria M
(4.3)
09 November, 2026

A lot of good content so a lot to take in. Would be good to save some time for a quick recap at the end.

Tess
(5.0)
04 November, 2026

Adam was a great facilitator; he worked are a good pace and it was easy to ask questions as we worked through the content.

Kristie O
(5.0)
04 November, 2026

Adam was very informative and the course was very efficient and engaging. I learnt the basics for sure with Adam.

Taleen B
(5.0)
21 October, 2026

A very good course, with a very competent facilitator. The practical work throughs were appropriately paced.

Graeme S
(5.0)
21 October, 2026

It was a very good course with clear, step-by-step guidance. The training was very useful, and the trainer was very patient and helpful.

Fiona H
(4.9)
21 October, 2026

Great course, glad it was fairly basic but i felt it would have been better done over 2 days. In the afternoon i got a little overwhelmed

Lesley C
(5.0)
21 October, 2026

This course helps me to build Power BI build and analysing skills. Mentor was an amazing person with a patience and good pace to absorb new learning for beginners.

Hiral J
(5.0)
21 October, 2026

This training was absolutely fantastic and I am so excited to get stuck in to making my own reports. I can already see a lot of ways I can apply my learnings to my current work. I work in learning and development and am a trainer and learning designer myself. Cath is truly one of the best trainers I have ever had the pleasure of learning from, and I felt like I was having two classes at the same time - one in Power BI, and one in training difficult technical subjects. I can't wait for the next course I am signed up for.

Amanda D
Read all course reviews
Common Questions

Frequently asked questions

Do I need Excel skills for Power BI Essentials?

No. Familiarity with Excel helps, but it isn't required. The course uses Excel datasets to show how Power BI works, step by step. Publicly scheduled courses also include unlimited free repeats within 8 months, so you can come back and consolidate your skills at your own pace.

Does Power BI Essentials cover DAX?

Yes, as an introduction. You create calculated columns and measures with DAX. To go further, the 2-day Power BI DAX Essentials course covers filter and row context, CALCULATE, iterators, variables and time intelligence.

Can I use a Mac for Power BI Essentials?

Power BI Desktop runs on Windows only, so for Online Live classes you need a Windows PC or laptop. In our classrooms, we provide the computers.

What should I do after Power BI Essentials?

Most people go on to Power BI Report Design, then Power BI Advanced and Power BI DAX Essentials. Advanced and DAX Essentials each need only Essentials, so you can take them in either order. Book all four together as the Power BI Training Package and save $330.

Does Power BI Essentials prepare me for the PL-300 exam?

It's the first step. Essentials introduces all four PL-300 skill areas: preparing, modelling and visualising data, and publishing and sharing in the Power BI Service. Our four core courses together, booked as the Power BI Training Package, cover the skill areas the exam measures. You book the exam separately through Microsoft.

Power BI Training Package

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


For more info please

Call 1300 888 724

View Package Details

Contact Us

Enquire now

Fill in your details to have a training consultant contact you to discuss your training needs. We offer public, on-site and workplace IT and software training services across Australia. Complete the form or call us during business hours (8.30am to 5pm AEST/AEDT) and our friendly customer service team will respond within 1 business day.

Contact us

Level 11, 32 Walker Street, North Sydney NSW 2060
8.30am to 5pm AEST/AEDT, Monday to Friday

1300 888 724 info@dynamicwebtraining.com.au ยทEnquire online

Fields marked with * are required. We respond within 1 business day.

Our Training Locations

Train in-class or Online Live, Australia wide

Classroom + Online Live

Sydney

Level 11, 32 Walker Street, North Sydney NSW 2060

Classroom + Online Live

Melbourne

Level 12, 379 Collins Street, Melbourne VIC 3000

Online Live

Brisbane

All courses facilitated in Online Live format or In-house workplace training, QLD

Online Live

Canberra

All courses facilitated in Online Live format or In-house workplace training, ACT

Online Live

Adelaide

All courses facilitated in Online Live format or In-house workplace training, SA

Online Live

Perth

All courses facilitated in Online Live format or In-house workplace training, WA