Power BI Intermediate

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

Training Overview

Harness the power of your data

Power BI empowers business users for advanced data analysis, turning data into actionable insights. Our Intermediate training is designed for professionals with a basic Power BI understanding, aiming to expand their skills. This course covers advanced data modeling techniques, DAX functions for complex analysis, and creating interactive dashboards, providing attendees with the expertise to elevate their data analysis, make informed decisions, and drive departmental success.

Who Should Attend

This course is designed for heads, directors, assistant directors, managers, and team leaders in charged in all three levels of government including:

Data Science, Analysis and Engineering

Business Intelligence

Solution Architects

Learning Outcomes

Master advanced data modelling techniques to optimise performance and data accuracy

Develop a comprehensive understanding of DAX functions for more intricate data analysis

Acquire skills in creating sophisticated interactive reports, leveraging Power BI’s latest visualisation tools

Gain proficiency in utilising Power BI for effective and impactful data communication

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 1: Module 1.2 Day 2: Module 2.1Day 2: Module 2.2
  • Working with Power Query
    • Common Transformations
    • Introduction to the M Language
    • Merge and Append Queries
    • Fuzzy Matching

  • Advanced Transformations
    • Add Columns
    • Unpivot and Group
    • Data Profiling
  • Advanced Data Modelling
    • Concepts & Best Practice
    • Relationships and Cardinality
    • Advanced Modeling Techniques

  • Data Analysis Expressions
    • Calculated Tables and Columns
    • Filter vs Row Context
    • Create and Organise Simple Measures

  • Solving Problems with DAX
    • Quick Measures
    • The CALCULATE function
    • Time Intelligence Functions
    • CALCULATE with Filter Modifiers

  • Data Enhancements for Visualisations
    • Geospatial Visuals
    • Custom Sort Orders
    • Hierarchies and Drill Downs

  • Specialised Visualisations
    • KPIs and Gauges
    • Combo Charts
    • Small Multiples & Sparklines
    • Custom Visuals
    • AI Visuals

  • Interactive Filter Options
    • Edit Interactions for Cross Filter
    • Synchronise Slicers
    • Create Drill Throughs
  • Advanced Report Techniques
    • Add Conditional Formatting
    • Create Custom Tool Tips
    • Add Navigation & Buttons
    • Work with Bookmarks

  • Report Enhancements
    • Use the Performance Analyser
    • Add Row Level Security

  • Working In the Power BI Service
    • Workspaces and Sharing Options
    • Create a Dashboard
    • Create a Workspace App
    • Managing Workspace Apps

Registration

Final Price

$1195

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