Cubes - Python Lightweight OLAP - 0.9 released
Author here. Just a small explanation: target audience are mostly those who would like to add OLAP to their apps with simple multi-dimensional reporting needs (see trivial hello-world example [1]). This release brings new star/snowflake aggregation browser which can be (roughly) considered to your analytical data as ORM framework is to your transactional data - some magic happens between your code and the database that makes your life easier.
Visualisation is not yet included and will be added in modular form of "presenters" [2]. If anyone with web/JS skills would like to help, he is welcome, as my skills in this area is little bit weak. There is unmaintained and unfinished prototype of JavaScript front-end as well [3]. Flask based example of simple dimension browsing is included in the source [4].
If you need any help with model creation, you encounter any issues, have a suggestion let me know.
[1] https://github.com/Stiivi/cubes/blob/master/examples/hello_w...
[2] https://github.com/Stiivi/cubes/issues/53
[3] https://github.com/stiivi/cubes.js
[4] https://github.com/Stiivi/cubes/tree/master/examples/sandbox...
Interesting idea. Ofcourse, OLAP isn't just about the underlying cubes and dimensions, in the end it's about how the information is being presented to the user. There's a reason why Microsoft is so good at data warehousing, because their product is one of the best, and also extremely feature-rich from the "front end" to the back end.
I haven't encountered a lot of BI nerds who are Pythonistas, but this is a great contribution nonetheless.
The more open source tools we can get that can begin displacing products like Cognos and BO, the better.
Is this going to integrate with the broader python ecosystem? I'm specifically wondering about packages like pyTables, pandas and larry.