Power BI Fundamentals

Tuesday, 5 & 12 March 2024 | 9:00am – 12:30 pm AEDT | Online

Training Overview

Harness the power of your data.

Microsoft Power BI empowers business users to perform advanced data analysis, transforming data into actionable, impactful insights. Dive into our course to unlock the potential of Power BI Desktop, enabling you to source data from various channels and craft dynamic, interactive reports. We then catapult your insights into a captivating online dashboard, extracting invaluable business wisdom.

If you possess a fervent passion for data and seek to streamline the collection, cleansing, and visualisation processes, this course is your gateway! Join us for an engaging, comprehensive, and hands-on exploration of self-service Business Intelligence.

Who Should Attend

This course is designed for:

Excel Users (time to step up)

Anyone who uses data
and Local Data Gurus

Beginner Level Data Management
and Analytics Community

Learning Outcomes

Master Power Query for data extraction and transformation

Grasp data modelling fundamentals

Unlock the potential of the DAX language for data enhancement

Craft impressive Power BI visuals and differentiate between Reports and Dashboards in the Power BI Service

Meet Your Facilitator

Nicky Bull
IT Trainer and Courseware Developer

Nicky Bull is a dynamic corporate trainer and consultant. She has 15 years of commercial experience as a computer programmer and analyst, and over ten years designing and delivering a range of educational programs. She lectures accounting students at Macquarie University and was the lead content designer for the hugely popular Excel Skills for Business course that received the Coursera Outstanding Educator Award for Student Transformation in 2018.

Nicky is passionate about learning and enabling people to use technology confidently and effectively in their workplace. She holds a BSc Hons in Computer Science (University of the Witwatersrand, South Africa), a BA in English Literature (University of the Witwatersrand, South Africa), and a Postgraduate Certificate in Education (University of Hertfordshire, U.K.)

Key Sessions

Day 1: Module 1.1Day 2: Module 1.2 Day 2: Module 2.1 Day 2: Module 2.2
  • Getting Started with Power BI Desktop
    • What is Power BI
    • Power BI Licensing
    • Overview of Power BI Desktop
  • Use Power Query to Get and Transform Data
    • Data Connection Options
    • Get Data from Excel
    • Introduction to Power Query
    • Get Data from a Folder
  • Work with the Data Model
    • Understand Relationships
    • Add and manage Relationships
  • Introduction to Data Analysis Expressions (DAX)
    • Use DAX to create Calculated Columns
    • Use DAX to Create Simple Measures
  • Design and Create a Power BI Report
    • Set Page and Canvas Settings
    • Add Images
    • Change and Customise Themes
    • Add and Manage Pages
  • Add and Customise Common Visualisations
    • Add Map, Treemap & Card Visuals
    • Work with Tables & Matrixes
    • Add Line and Column Charts

  • Work with Visualisations
    • Work with Tool Tips and Cross Filters
    • Focus Mode and Spotlight
    • Sort and Drill Down
    • Customise Visuals
  • Add Multiple Pages and Custom Visuals
    • Rename, Add and Duplicate Pages
    • Add Custom Visuals
  • Filter Visuals, Pages and Report
    • Use the Filters Pane
    • Work with Slicers
  • Publish and Work with Reports in the Power BI Service
    • Publish to the Power BI Service
    • Workspaces & Sharing Options
    • Subscribe and Comment
    • Spotlight and Bookmark
    • Export Data from a Report
  • Create and Work with Dashboards in the Power BI Service
    • Report vs Dashboard
    • Create a Power BI Dashboard
    • Work with Tiles and Q&A
    • Customise for Mobile View
  • Install Apps and work with Power BI Mobile
    • How to find shared Reports
    • How to find Apps
    • Power BI for Mobile


Final Price


per person + GST

Customised in-house options available for teams

Interested in any of our online trainings?

You can also choose to have them delivered in house. We will work closely with our inspiring session facilitators to tailor the content around the key development areas your team are prioritising, shape the learning outcomes around your core departmental challenges and make the most of your L&D and upskilling budget.

Interested In Learning More?

The Data Management & Analytics Community provides a hub for public sector professionals from around the globe to learn, network, collaborate, benchmark, and share best practices with their peers. Become a member today for free and gain access to:

  • Live chats and digital forums
  • Global content library
  • Priority event registration
  • Networking opportunities with peers
  • Complimentary access to exclusive events and insights