CHAPTER 14Final Project: Combining It All Together

To write it, it took three months; to conceive it three minutes; to collect the data in it all my life.

F. Scott Fitzgerald


  • Act as the chief data officer of the fictitious company Wide World Importers

  • Tackle challenging datasets and apply your skills to prepare the messy data for analysis

  • Combine Unpivot and Pivot sequences in a complex real-life scenario, with multiple files of summarized data

  • Use different Merge transformations to compare two tables

Congratulations. You have reached the final chapter. It is time to challenge your data-wrangling skills and test your capabilities with a final project.

You have come a long way. In the preceding chapters of this book, ...

Get Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition 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.