jueves, 27 de diciembre de 2012

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.

ImageQVSource 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:

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!

30 comentarios:

  1. Very good articles,thanks for sharing

    http://www.kitsonlinetrainings.com/tableau-online-training.html
    http://www.kitsonlinetrainings.com/teradata-online-training.html
    http://www.kitsonlinetrainings.com/tibco-online-training.html

    ResponderEliminar
  2. Excellent information with unique content and it is very useful to know about the information based on blogs.
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    SAS Training In Chennai

    ResponderEliminar
  3. Your providing such a valuabe information about studying..and also have some good key

    points to every student.
    Qlikview Interview

    Questions | Qikview Training Videos | Qlikview online Training Hyderabad

    ResponderEliminar
  4. Thanks for sharing with detailed information. When I was reading more article on QlikView. I found one of the good resource related to QlikView. It will give complete knowledge on QlikView. To know more Just have a look at this link: https://intellipaat.com/qlikview-training/

    ResponderEliminar
  5. nice blog has been shared by you. before i read this blog i didn't have any knowledge about this but now i got some knowledge so keep on sharing such kind of an interesting blogs. mulesoft training bangalore

    ResponderEliminar
  6. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    python Online training in chennai

    python Online training in bangalore

    ResponderEliminar
  7. Well done! Pleasant post! This truly helps me to discover the solutions for my inquiry. Trusting, that you will keep posting articles having heaps of valuable data. You're the best! 
    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in chennai

    automation anywhere online Training

    angularjs interview questions and answers

    ResponderEliminar
  8. Really great post, I simply unearthed your site and needed to say that I have truly appreciated perusing your blog entries. I want to say thanks for great sharing.
    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in chennai

    automation anywhere online Training

    angularjs interview questions and answers

    ResponderEliminar
  9. I think QlikView and QlikSense are the best ways to provide information about complicated IT tools and above all to solve them.

    Qlik Soap Api Connection

    ResponderEliminar
  10. Thank you for sharing this blog !! QlikView Software is a software vendor specializing in data visualization, executive dashboards, and self-administration business knowledge items. Analyst firm Gartner consistently rates qlik as one of the top information perception and business intelligence (BI) merchants on the lookout, including Tableau and Microsoft.

    ResponderEliminar