CHAPTER 39Transforming Data with Power Query
Data transformation generally entails certain actions that are meant to “clean” your data—actions such as establishing a table structure, removing duplicates, cleaning text, removing blanks, and even adding your own calculations.
In this chapter, you will be introduced to some of the tools and techniques in Power Query that make it easy for you to clean and massage your data.
|
You can follow along with the examples in this chapter by downloading the Once you've downloaded the file, you can import the sample file into Power Query (select Data ⇨ Get & Transform Data ⇨ From Text/CSV, browse to the |
Performing Common Transformation Tasks
You will find that many of the unpolished data sets that come to you will require various types of transformation actions. This section covers some of the more common transformation tasks that you will have to perform.
Removing duplicate records
Duplicate records are absolute analysis killers. The effect that duplicate records have on your analysis can be far-reaching, corrupting almost every metric, summary, and ...
Get Excel 2019 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
