Power BI Data Wrangling

Power BI Data Wrangling is a one-day Power BI training course suitable for those needing to learn how to prepare data and build best practice Power BI data models.

Please review the Course Outline below to ensure this Power BI Data Wrangling training course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• 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

Please review the Course Prerequisites below to ensure this Power BI Data Wrangling training course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• Have the latest version of Power BI Desktop installed.
• Have a base level of Power BI skills equivalent to having attended the Power BI Dashboard in a Day course.
• You will have at least a basic knowledge of data modelling. Knowing about data types and relationships will help with understanding some of the concepts.
• This course is appropriate for those involved in building or using data models in Power BI.

Private training

• Please contact your local regional office for pricing for private training.
• Private Power BI Data Wrangling training delivered in the UK, remotely or at your offices.
• 1-day course that can also be delivered as 2 x consecutive half-days.
• 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.

Public training (schedule at bottom of page)

• £400 per person ex. VAT.
• 20% discount when you book 3 or more people on the same course.
• 20% discount when an individual enrols in 3 or more courses.

Based in London, we provide best practice Power BI training courses.

• “A lot of information, well explained, easy to follow with only a little bit of technical knowledge, breakout sessions are useful to understand different points of view on the same task/topic, well delivered”
• “Good balance of presentations and practical work”
• “It broadened my understanding on how to optimise data model structure”
• “Seeing a whole new way to do things that I really hadn’t thought about before.”
• “It was amazing!”
• “The activities – really helped cement the ideas in my head. Tony the trainer was also great, you could see his passion for the subject shine through, which in turn made it more engaging for us participants.”
• “Well structured – with good examples”

We recommend students next attend Power BI Data Visualisation where you will learn how to build more advanced Power BI visualisations and leverage interactivity.