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

IN THIS CHAPTER, YOU WILL

  • 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.