CHAPTER 22
Advanced Modeling with Slicers, Filters, and Pivot Tables
So far in this book, you have seen really powerful and elaborate techniques to analyze data and present results in the dashboard format. You need to spend a significant amount of time when creating dashboards with these techniques. Continuing from the previous chapter, I’ll provide some alternatives here.
Creating an Interactive Excel Dashboard
My goal is to create informative, interactive, and beautiful dashboard…in less than 60 minutes. You are going to create a dashboard like the one shown in Figure 22-1.
Figure 22-1. Sales dashboard using Excel
You will be using the data ...
Get Dashboards for Excel 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.
