Bigtable now supports Continuous Materialized Views for write-time, incrementally processed pre-aggregations and SQL GROUP BYs for read-time aggregations which make these kind of operations much easier.