CHAPTER 9Pulling It All Together: Creating a Dashboard from Pivot Tables
Throughout this book, you have learned how to get your data ready to be made into a pivot table, how to create and format a pivot table, how to add calculations, how to sort and filter the pivot table, and how to create charts from a pivot table. In this chapter, we will tie everything together to make a user‐friendly, interactive, informative dashboard.
A dashboard can consist of any combination of pivot tables, charts, sorts, filters, slicers, timelines, text, graphics, and really any other object available in an Excel spreadsheet. You can use your imagination to make your own dashboard any way you want it to be. The end result of a dashboard should be easy to use, visually appealing, and interactive, and it should show the results that the user is looking for. It should also be flexible to grow and change, as the user's needs will change. This chapter shows a specific example to give you an idea of the possibilities of what you can do with a dashboard. You can then take it from there. First, I will show you a finished dashboard, and then you will learn how to build a similar dashboard.
Get Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot 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.
