Chapter 4: Reshaping Your Data
When data grows in size and complexity, you need tools that allow you to make sense of your data and create views that can be relevant for reporting and presenting that data. In order to do this, they need features and options to reshape their data properly and to clean it if needed, especially when you can't edit data sources directly. Often, they connect to data that does not have a correct schema or a correct column name and they need to group and change how data is displayed.
In the recipes in this chapter, you will see how to leverage Power Query's built-in features that will allow you to reshape your data, to change its structure, and to adapt it to your reporting needs.
In this chapter, we will cover the ...
Get Power Query Cookbook 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.
