3
Preparing Your Data for the Data Model – Cleaning and Transforming Your Data Using Power Query
Having understood the best practices for data structuring in our earlier chapters, we will take a look at how to prepare our data for data modeling using Power Query—Microsoft Excel’s data cleaning and transformation tool.
In this chapter, you will understand the architecture of the Power Query editor and data types and how to use the Transform and Add Column tabs to correct any issues with the sample sales data. You will also learn how to append and merge data from our sample sales data.
The following topics will be covered in this chapter:
- Understanding queries and connections
- An overview of the Power Query editor
- Getting your data type right ...
Get Data Modeling with Microsoft Excel 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.
