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