If you want to display analytics on a dashboard I would generate materialized views from your underlying data first and then display that. Try and precalculate as much as possible to avoid having to do it on your front end.