Moving quickly between aggregate and record-level data [closed]

Question

I am using postgreSQL to store and process data for a research project. I can program in SQL, R, and Python but am not a software developer or system administrator. I find myself constantly aggregating data and then wanting to see the individual records contributing to a single cell in the aggregation. The records contain text fields and I use CASE and LIKE statements to determine how these will be counted. I'm looking for a GUI that will allow me to quickly move between different levels and kinds of aggregation so I don't lose access to details when looking at the big picture. I believe the answer to my question involves OLAP and/or faceted search but would like recommendations for specific products, open source and turnkey if possible.

thank you, -david

Answer 1

icCube is not open source but allow for going from the big picture to the details (either via drilldown or drillthrough). Depending on your PostgreSQL model the work to setup the cube model might be minimal. Note once the model has been setup you've the full power of MDX analysis for more challenging requests.