Skip to Main Content
Excel Power Pivot & Power Query For Dummies, 2nd Edition
book

Excel Power Pivot & Power Query For Dummies, 2nd Edition

by Michael Alexander
March 2022
Beginner to intermediate content levelBeginner to intermediate
288 pages
7h 21m
English
For Dummies
Content preview from Excel Power Pivot & Power Query For Dummies, 2nd Edition

Chapter 10

Transforming Your Way to Better Data

IN THIS CHAPTER

check Performing common transformations

check Creating your own custom columns

check Understanding Power Query formulas

check Applying conditional logic

check Grouping and aggregating data

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Wayne Winston
Microsoft Excel 365 Bible

Microsoft Excel 365 Bible

Michael Alexander, Dick Kusleika
Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119844488Purchase Link