CHAPTER 24
Introduction to PowerPivot
So far you have learned various techniques and advanced concepts when it comes to using formulas (and VBA) to build dashboards. Let me ask you one question.
What are some of the limitations of formula-driven (or VBA-driven) dashboard development?
Go ahead and think about it.
For all its glory and power, it turns out that formula-driven dashboard development suffers from a few key limitations, such as the following:
- Not scalable: As you bring more data into your dashboard world, suddenly you realize that the SUMIFS, SUMPRODUCT, and LOOKUP formulas are taking forever to calculate. Even if you are willing ...
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.
