book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft Power BI Intermediate – Data Modelling with Power Query

Microsoft Partner Power BI Logo
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Power BI Intermediate – Data Modelling with Power Query

$770per person

In Person

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 9:00 am to 4:00 pm
Duration: 1 Day

Join in-person at our vibrant Perth CBD training centre. Lunch and refreshments are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

In this one-day course, you will extend your Power BI capabilities through advanced data modelling, report sharing, and data transformation techniques. Building on knowledge gained from the Power BI Essentials course, you will work with complex data from multiple sources, create relationships between tables, and apply advanced transformations to optimise datasets for reporting. The course also introduces key considerations and options for real-world Power BI deployment.

Dates

Book a course

Course Information

Course Content
This course is best suited for: Technical users who are involved in connecting to complex data sources with multiple related tables, who need to transform them into better, simpler models for creating Power BI Reports.

Connecting to Data Sources

  • Relational databases
  • Web pages
  • PDF documents
  • Folders
  • SharePoint lists
  • Power BI datasets
  • Using ODBC

Column Transformations

  • Duplicating, reordering and renaming columns
  • Splitting columns
  • Transforming text, number and date-time columns
  • Adding custom columns
  • Creating conditional columns
  • Creating index columns

Advanced Transformation Techniques

  • Grouping tables
  • Renaming query steps
  • Using parameters
  • Removing rows from tables
  • Filtering data
  • Filling null area with values

Advanced Transformations

  • Grouping tables
  • Renaming query steps
  • Using parameters
  • Removing rows from tables
  • Filtering data
  • Filling null area with values

Incorporate Unrelated Data Sources

  • Incorporating data from the web
  • Merge using fuzzy matching

Converting Flat Files to Related Tables

  • Why would we want to do this?
  • Overview of techniques
  • Removing duplicates
  • Adding an index column
  • Using merge to link tables

Adding a Source at a Higher Level

  • Comparing against a budget
  • Unpivoting tables
  • Duplicating Vs referencing other queries
  • Adding parent tables
  • Linking to the model
  • Creating visualisations

Basic M Scripting

  • Basic script structure and data types
  • Working with lists, records and tables
  • Conditionals using IF / ELSE IF
  • Looping using EACH
  • Custom functions
  • Creating a date table

Further development

Power BI Advanced – Creating Performance Measures using DAX This training is aimed at Power BI users who are looking to get even more out of this popular tool. Learn how to write code in DAX (Data Analysis Expressions) to enhance the data models, create custom performance measures, create complex calculations. Incorporate these results into practical stunning reports, to make decision making easier.

Get in touch

Excel in business with our essential Power BI training and more. Whether you’re looking to upskill through training or need tailored support through our consultancy services, we’re here to help.

To learn more about our Microsoft Power BI course or how we can support your data goals, please contact us today or give us a call on (08) 9218 9059.

  • Understand how to connect to a wide range of data sources
  • Develop the skills to performs number, text and date-time column transformations
  • Develop the skills to add custom columns to existing data source tables
  • Learn and use a range of advanced transformation techniques, including grouping tables, transforming rows and replacing values
  • Understand how to incorporate date from unrelated data sources into our model
  • Learn how to convert a flat file into multiple related tables (normalisation)
  • Learn how to add a data source to the model, which is summarised at a different level, and perform comparisons
  • Learn and try some basic M scripting techniques

Participants must have completed the Power BI Essentials course, as well knowledge of Excel formulas at an Intermediate level or higher.  Knowledge of DAX or a similar programming language is recommended, as well as a basic understanding of database theory is advantageous.

“This is very helpful for me to know how to play and modeling data via Power Query. This is fantastic training.” – Chunxia from Mineral Resource

“This course provides me with the guidance to update existing and create new files using Power Query options and M coding. Materials provided are great, lesson plans are great and format with regular breaks so I can keep focus. The facilitator was good at making sure everyone in the class kept up to date and helped them when needed.” – Sue-Anne from CBH

FAQs

No FAQs found.