01
Pre-computed snapshots rather than live warehouse queries
The choice
The dashboard reads columnar snapshot files refreshed on a schedule from the warehouse.
Why
An operations dashboard opened by forty people every morning should not run forty warehouse queries, and the underlying numbers change once a day anyway.
What it means for you
The page is instant, and the warehouse is not competing with the reporting team.
