You are building a dashboard for a business analytics team and need to choose how it connects to the underlying data. The same dashboard must support fast exploration for analysts and predictable performance for executives. You need to decide when a live connection is the right fit and when an extracted model is a better choice.
How do you decide when to use a live connection versus an extracted model for a dashboard?