Cleaning data in Excel with Power Query, Part 2
Ready for the second part of Cleaning Data in Excel with Power Query? In this lesson, we're transforming our unruly dataset for easy, organised data analysis. We'll start by removing unnecessary rows and blank spaces and getting rid of any unwanted elements. We'll explore techniques t...
Corporate Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
[Place of publication not identified]
Assemble You
2024
|
Edition: | [First edition] |
Subjects: | |
Online Access: | |
Collection: | O'Reilly - Collection details see MPG.ReNa |
Summary: | Ready for the second part of Cleaning Data in Excel with Power Query? In this lesson, we're transforming our unruly dataset for easy, organised data analysis. We'll start by removing unnecessary rows and blank spaces and getting rid of any unwanted elements. We'll explore techniques to align and split columns for a more structured layout. We'll explore clever tricks to handle any quirks in your data. By the end, you'll have a refined dataset ready for analysis. Learning Objectives Remove unnecessary rows, handle blank spaces, merge and split columns, and fine-tune data types |
---|---|
Physical Description: | 1 video file (10 min.) sound, color |