Chapter 10
Transforming Your Way to Better Data
In This Chapter
Performing common transformations
Creating your own custom columns
Understanding data types
Understanding Power Query formulas
Applying conditional logic
Grouping and Aggregating Data
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 data. ...
Get Excel Power Pivot and Power Query For Dummies 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.