Ejemplo:

Google Analytics + QlikView + QVSource

A while ago I posted about loading Google Analytics data into QlikView (link [spanish]) using the java client. Today, I'm sharing with you an example about how to do the same with QVSource, the QlikView API connector.

QVSource is a third party software created by Industrial Codebox (the guys behind great QlikView related stuff)  that enhances the connectivity power of QlikView, allowing us to connect to many different APIs such as Twitter, Facebook, Youtube, Sentiment APIs, Azure Marketplace and many others.

It runs in the background and each connector of QVSource connects directly to each API, retrieving the data locally so it can be loaded directly into QlikView and it can be associated with internal data of the company such as data stored in a datawarehouse, CRM, or ERP systems.

About the low level technical details, I think it would be reinventing the wheel if I explained here how to install QVSource and how to configure the Google Analytics connector because the QVSource doc page is really extensive and can get you through the process really quickly (and also offers many examples on how to use each connector). Visit the QVSource doc page here.


Like I did in my previous blog posts, I'm sharing with you a very simple QlikView app that will give you a glimpse on how to use QVsource with QlikView to load Google Analytics data and use the power of QlikView to 'master' the data.

In this app you can learn how to load the data into QlikView and analyze the most common metrics (visits, new visits, page views, time on site etc...) and dimensions (Geographical data, source, medium, keyword, ...).

QlikView app example screenshot

Download this QlikView example application here.

This is what you need to open the application:

• QlikView Desktop (get it from http://download.qlikview.com) with a valid license.
• A QlikView extension to visualize the map created by Brian Munz (get it and know more in this post: http://notas-bi.blogspot.com/2012/09/beautiful-maps-in-qlikview.html).

If you want to reload the app with your own Google Analytics data, you will need:

• QVSource
• A valid QVSource license (for more information about QVSource and licensing, please visit www.qvsource.com or contact @qvsource on twitter)

Feel free to comment and share this post.

I wish you all a Happy New Year!

Beautiful maps in QlikView

I have to admit it, I’m a big fan of data visualization with maps. And I’m in love with QlikView, so from time to time I spend a few hours investigating new ways of using “old techniques” and new techniques that allow us to use beautiful and useful map visualizations in QlikView.

This summer, QlikTech released a demo application for the 2012 Summer Games in London  which uses two interesting QlikView Extensions: one extension to center-align the content and another extension for the map. As you may have guessed, I’m going to talk about the second one.

Global Games QlikView app released summer 2012.

Another way to use good old Google Maps method in QlikView

A few weeks ago I came across with this idea while building some maps in QlikView.

I was switching from bubble (plain shape, no 3D!) to rings style when suddenly realized that we can show two expressions related one to each other (sales vs budget for example) at the same time in a beautiful and useful way.

And, this is the result:

Deja la tarta para los postres

Parafraseando a Stephen Few, uno de los autores más reconocidos del mundo de data visualization (http://perceptualedge.com/), he querido titular este post dedicado a los maravillosos gráficos de tarta.

Estos gráficos son muy utilizados porque son muy fáciles de interpretar. Se usan principalmente cuando se quiere representar la distribución de una métrica/dato/indicador sobre una dimensión.

El problema de los gráficos de tarta o pie charts, es que parecen tan sencillos que no nos damos cuenta de que muchas veces consiguen justo lo contrario a lo que buscamos: un gráfico poco legible y poco leal a la verdad (que distorsiona ligeramente el dato y genera en el usuario una idea incorrecta sobre los datos).

Monitorizando búsquedas de Twitter con QlikView

Actualización: esta aplicación QlikView ha dejado de funcionar desde que Twitter ha "apagado" la API v1 (Junio 2013) y han pasado a la API v1.1, que requiere autenticación y además la respuesta ahora es en formato JSON (https://dev.twitter.com/docs/using-search).

Google Analytics en QlikView

Recientemente he estado probando las distintas posibilidades de integrar datos de Google Analytics en una aplicación QlikView. Ahora mismo existen dos opciones. Una es gratuita y un poco más de andar por casa. La otra, es de pago y algo más profesional.

En este post voy a comentar la primera de ellas. El coste del resultado final es de 0 € y alrededor de 30 minutos como máximo. Este post va dirigido tanto a los que conocéis QlikView como a los que no.