I have a large analytics dataset in BigQuery and I wrote an interactive exploratory UI on top of it and any query I did generally finished in 2s or less. This led to a very simple app with infinite analytics refinement that was also fast.

I would definitely not trade that for a pre-computed analytics approach. The freedom to explore in real time is enlightening and freeing.

I think you have restricted yourself to recomputed fix analytics but real time interactive analytics is also an interesting area.