Power BI - Data Cleaning and Transformation - From Raw and Poor to Report-Ready Overview

It's a known fact that raw data loaded into Power BI is hardly ever "report-ready" and requires "cleaning" to make it useable.

Unnecessary rows and columns need to be removed, data that isn't required needs to be filtered out, dates are never in the correct format and often aren't even dates, columns require splitting or merging, and "weird" characters must be removed. These are just a few examples of what is meant by data cleaning.

Webinar Nov 03 2025, Monday 01:00 PM EDT 90 Minutes Basic Level Code: GRC0000243

  • How to create simple solutions to quickly clean and restructure less-than ideal data?
  • How do you combine data from multiple datasets?
  • How to create additional columns without complex formulas?

This training is aimed at existing users of Microsoft Power BI who have mastered the basics and want to take their knowledge and learning to the next stage. Implement complex tasks and boost your productivity.

If you’ve mastered the basics of Power BI and the phrase "it's taking too long" describes how you feel about the time it takes to get your raw data into the correct format for your reports, this training is for you!

MIKE THOMAS
MIKE THOMAS

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded excel trainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

  • Dec 26, Friday | 01:00 PM EDT | 75 Mins

“The future belongs to individuals and companies who embrace the entrepreneurial spirit, whether that is inside or...

  • Dec 26, Friday | 02:00 PM EDT | 120 Mins

A properly-composed JHA/AHA is one of the primary documents that large clients are increasingly asking to review in adva...

  • Dec 26, Friday | 03:00 PM EDT | 90 Mins

Skills-based hiring has been a topic of interest for many businesses and governments for the past few years. But even as...