What I am going to showcase in this tutorial is how to load web stats from Google Analytics into a fact table with Penthao Kettle/PDI. And then how to represent that fact table with Mondrian 3.6 schema so we can visualize the data with Saiku on Pentaho BI Server. In the end I’ll give my two cents on Saiku Analytics and possible options involving d3.js and Roland Bouman‘s xmla4js.
In case you are new to this I recommend reading my articles on the following topics involved here:
- Getting Started With Pentaho BI Server 5, Mondrian and Saiku
- Setting Up a Time Dimension Table in MySQL
- Using the Dimension Lookup/Update Step in Pentaho Kettle
- Google Analytics API with Pentaho Kettle