Chapter 10
Transforming Your Way to Better Data
IN THIS CHAPTER
Performing common transformations
Creating your own custom columns
Understanding Power Query formulas
Applying conditional logic
Grouping and aggregating data
Working with custom data types
Wouldn’t it be great if all the data sources you work with were clean and ready to use? Unfortunately, that’s not the case — you often receive data that is unpolished, or raw. That is to say, the data may have duplicates or blank fields or inconsistent text, for example.
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, I introduce you to some of the tools and techniques in Power Query that make it easy for you to clean and massage your ...
Get Excel Power Pivot & Power Query For Dummies, 2nd Edition 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.
