O'Reilly logo

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition by Gil Raviv

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required