Setting up a new workstation (apple mac pro)

Today I got a new MacPro, as my old one died of ram and batteries decease:( For myself and all other crazy developers, I describe what I’m setting up, step by step, to get a production machine! Startpoint To make it simpe, I just clicked through the apple wizzards and ended up with a ready to use (nothing taken over from an old win or mac!) desktop.  Step One, Basic App Setup Grep Chrome as Browser from http://www.google.com/chrome Open the App Store and upgrade to the lates OS! Install XCode from the App Store – install the commandline tools! (xcode-select –install) get homebrew http://brew.sh/ (the coolest missing none apple package… Read More

Continue Reading

QlikView and Google Analytics – primary key issues

The main challenge I’m facing now, is the definition of a primary key, that allows me to build up my own data mirror to google analytics without messing up the metrics. Walking around on the internet, I found a lot of interesting articles about this and the best solution to come up with, seems to be the option to hand over custom variables to google analytics. This custom variables allow you to identify a single session and then you can grep the related data to it! For the historical data, I have to come up with another solution, as the tracking ID will only be implemented for the upcoming periods.… Read More

Continue Reading

QlikView and Google Analytics – Getting Started

Hello, as I got the challenge to integrate Google Analytics into our company warehouse with QlikView I will write a series of hopefully more or less usefull articles on how to fetch the data needed. For accessing the Google Analytics API (v3) you have two possibilities: You are a technic geek and you know how to use REST-Services and OPENAUTH You use the ready to use and well tested tool QVSource – www.qvsource.com As we had some time pressure for the analysis and I didn’t wanna write the „fetcher“ by myself. We decided to order and use the QVSource solution. Where to start? Facing the „KPI-Definition List“ from our marketing… Read More

Continue Reading