Chapter 10

Transforming Your Way to Better Data

In This Chapter

arrow Performing common transformations

arrow Creating your own custom columns

arrow Understanding data types

arrow Understanding Power Query formulas

arrow Applying conditional logic

arrow 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.