3

I'm about to start the development of a web analytics tool for an e-commerce website.

I'm going to log several different events, basically clicks on various elements of the page and page views.

These events carry metadata (username of the loggedin user, his country, his age, etc...) and the page itself carries other metadata (category, subcategory, product etc...).

My companies would like something like an OLAP cube, to be able to answer questions like:

How many customer from country x visited category y? How many pageviews for category x in January 2012? How many customer from country x visited category y?

My understanding is that I should use an OLAP engine to record these events, and then build a reporting interface to allow my colleagues to use it.

Am I right? Do you have advices on the engine and frontend/reporting tool I should use? I'm a Python programmer, so anything Python-friendly would be nice.

Thank you!

Giuc
  • 125
  • 1
  • 8
  • There are some solutions with Django. You might find this other question interesting: http://stackoverflow.com/questions/469200/any-python-olap-mdx-orm-engines – charlax Jan 21 '12 at 21:40

2 Answers2

2

As mentioned in the selected answer, it depends on your data amount. However, just you run into a case that a light-weight Python OLAP framework would be sufficient, then you might try Cubes, sources are on github. It contains SQL backend (any other might be implemented as well) and provides a light HTTP OLAP server. Example of an application (PHP front-end with HTTP Slicer OLAP server backend) using it can be found here It does not contain visualization layer and complex queries thought, but that is trade-off for being small.

Stiivi
  • 2,077
  • 2
  • 16
  • 27
2

The main question is how big your cube is going to be and if you need an open source OLAP solution or not.

If you're dealing with big cubes and want to get room for future features you might go for a real OLAP Server. A few are open source - Mondrian - and other have a 'limited' community edition - Palo, icCube. The important point here is being compatible with MDX and XMLA. defacto OLAP standard, so you can plug different reporting tools and/or using existing libraries. My understanding, there is no Phyton version for an XMLA library as in Java or .NET not sure this is the way to go.

If you're cubes are small you can develop something on your own or go for other quicker solutions as the comment of Charlax is indicating.

ic3
  • 7,917
  • 14
  • 67
  • 115