Aggregations and reports are hard to do right.
On one hand, you want reporting and aggregation queries to be up to date. On other other hand, they can be expensive and add a lot of database load.
Live-updated summary/aggregation tables offer both up-to-date correctness and great performance - but managing them is tough.
We're building a solution for instant aggregations that will deploy and maintain summary tables and manage all the necessary infrastructure (triggers, stored procs, views) to keep it updated with perfect correctness.
Point it at your base tables, tell it what you want to aggregate - we will do the rest.