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.

  • 60 Mins | Oct 30, Thu , 01:00 PM EDT

Time management for an attorney in a busy law office is a difficult task. Complicating the issue is managing the product...

MIKE THOMAS By MIKE THOMAS

  • Oct 27, Monday | 01:00 PM EDT | 75 Mins

Tattoos were always associated with sailors, marines, and bikers. Not today. Over the past few decades, there has been r...

  • Oct 27, Monday | 01:00 PM EDT | 60 Mins

This webinar is for you if you ever find yourself in a difficult emotional situation where a cool head is necessary. Th...

  • Oct 27, Monday | 08:12 PM EDT | 90 Mins

Nisi earum est dicta ab perspiciatis expedita sint. Sint voluptatem deserunt autem rerum quia possimus ea asperiores. Fa...

By