End to end aggregating, reporting and visualization API