Power BI Data Wrangling Training

Power BI provides the ability to perform rich transformations with your data as well as combine data from multiple sources. This one-day workshop will help you overcome data integration and data transformation challenges by delving into M (or Power Query) as well as Power BI data modelling, common errors and best practice.

 

Course Outline

This workshop is tailored according to the needs of the delegates and involves explanation and demonstration from your instructor with students practising the techniques shown. Content covered includes the following:

    • Connecting to data sources
    • Data quality & profiling
    • Cleaning the data
    • Joining data from different source systems
    • Common errors with joins and data models and how to fix them
    • Structuring Power BI queries for optimal and correct joins
    • Exploration of M functions such as Column by Example, Pivoting and Unpivoting, Indexes, creating tables, the advanced editor and Custom Functions
    • Preparing your model to support time intelligence
    • When to use M or DAX
    • Model tuning and optimising maintenance tasks

 

Course Prerequisites

    • Have a base level of Power BI skills equivalent to having attended the Power BI Dashboard in a Day course.
    • Have the latest version of Power BI Desktop installed.

 

Pricing & Logistics

    • Please contact your local regional office for pricing.
    • Training delivered at your offices or remotely via online delivery.
    • Capped at 15 attendees to ensure maximum personal attention.
    • Training can be customised to suit your needs.
    • We can also provide follow-on consulting to help students develop their first best-practice Power BI reports/dashboards. This can be an effective way to help students successfully transition from the classroom to the real world.

Get in touch if you’d like to find out more about our Power BI training

* Required field

  • This field is for validation purposes and should be left unchanged.

 

Sydney

Regional Manager:
Emilio Gazis

Level 6
219 Castlereagh St
Sydney NSW 2000

Phone:
+61 2 9211 1522

 

Canberra

Regional Manager:
Katrina Pilcher

Ground Floor
65 Canberra Ave
Griffith ACT 2603

Phone:
+61 2 6262 5422

 

Melbourne

Regional Manager:
Andy Painter

Level 14
45 William St
Melbourne VIC 3000

Phone:
+61 3 9913 7100

 

Auckland

Regional Manager:
Alex Gray

Level 6
152 Quay Street
Auckland, New Zealand 1010

Phone:
+64 9 369 1910

 

London

Regional Manager:
Chris Kearns

6 Hays Lane
London Bridge, London
United Kingdom SE1 2HB

Phone:
+44 7704 957 438