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!


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
  • 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 (the coolest missing none apple package manager)
  • install appache and php5.x with brew (homebrew-apache)
  • Step by Step: brew install -v git
  • Update Path variable:
  • brew install ruby (need this for later)
  • brew install -v mysql
  • brew tap homebrew/dupes
  • brew tap homebrew/apache
  • brew install -v httpd22 –with-brewed-apr –with-brewed-openssl
  • brew install -v php56
  • brew install phpmyadmin (add the config to your httpd.config)

Other Apps

  • FireFox – as I need a second browser to test with (if they would not use that much memory, I would love to use them again as my main browser)
  • Virtual Maschine
  • GitHub Client
  • BitBucket SourceTree Client
  • SublimeText
  • Tunnelblick

Needed Browser Plugins

  • Flash Player


  • Package Control
  • Emmet
  • SublimeLinter
  • SidebarEnhancements
  • Theme Soda
  • SublimeCodeIntel
  • HTML5
  • Bracket Highlighter
  • Alignment
  • GIT
  • DocBlockr
  • Emmet CSS Snippets


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. And as google doesn’t want people to be able to track the visitors down to the detail record (limit of 10 to dimensions and metrics) I’ll have to work with a „bridge“ anyway.


After some time of investigation, with the new google universal analytics you can use the following steps to get a unique primary key!

  1. You need to login to your google analytics account.
  2. Screenshot 2014-11-11 11.47.22 Then enter the „Admin“ Menu, so you can add the new custom dimension.
    Screenshot 2014-11-11 11.47.31
  3. After you generated the custom variable, google offers you the code to include into your webpage:
    Screenshot 2014-11-11 11.48.08

So by doing this, the new custom dimension is available and can be „queried“ although by the connector.

QlikView and Google Analytics – Getting Started


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:

  1. You are a technic geek and you know how to use REST-Services and OPENAUTH
  2. You use the ready to use and well tested tool QVSource –

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 department and looking inside the google analytics dev documentation I realized that this will be a time consuming and knowledge building task;)

After digging into more and more details (help from dev friends) I ended up on this fancy little tool:

Google Analytics Query Explorer 2
Google Analytics Query Explorer 2

How to configure this tool is as simple as login into the tool with your oauth google credentlials (your normal google account). Then you can select the google analytics profile and the site you wanna query on.

To get started, I build a simple request structure where I ask for the dimension:

  • ga:date (YYYYMMDD)

Can be selected as followed:

Screenshot 2014-08-11 13.30.18

And the following metrics:

  • ga:users (former visitors)
  • ga:sessions (former visits)
  • ga:pageviews

If you have the feeling of getting lost within dimensions and metrics (measures) within the google analytics datamodel – I did so too – took me about 2 days to understand what’s going on (birdseye)…

The really cool part now is, that by clicking on the following symbol:

Screenshot 2014-08-11 13.36.29You’ll get the query uri for the latest Google Analytics API, that you can (if you although decide to use the QVSource solution) copy and paste within the follwing dialog in QVSource:

Screenshot 2014-08-11 13.47.12

After you clicked this you can use the generated code to fetch the first records from google!

I made a quick an dirty line/bar chart to display the so fetched metrics:

qlik view first quick chart
qlik view first quick chart

Check out my next posts, to see and learn more! Philipp;)