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.Learning ObjectivesHow 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?Areas covered An introduction to the Power BI Query EditorManaging Query StepsRemoving columns from your imported dataSplitting a single column into multiple columns Applying FiltersCleaning date-based dataCleaning text-based dataCalculations without formulas – the power of The Query Editor RibbonUnpivot – the hidden gem and unsung hero of The Query EditorWho Should AttendThis 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.Why Should You AttendIf 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!
Single
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.
Learning Objectives
- 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?
Areas covered
- An introduction to the Power BI Query Editor
- Managing Query Steps
- Removing columns from your imported data
- Splitting a single column into multiple columns
- Applying Filters
- Cleaning date-based data
- Cleaning text-based data
- Calculations without formulas – the power of The Query Editor Ribbon
- Unpivot – the hidden gem and unsung hero of The Query Editor
Who Should Attend
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.
Why Should You Attend
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!