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!

19 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. If wants to get real time Oracle Training visit this blog They give professional and job oriented training for all students.To make it easier for you visualizing all the real-world Application and how to implement in Archiecture trained with expert trainners guide may you want.. Start brightening your career with us Green Technologies In Chennai

    ResponderEliminar
  3. It is really very helpful for us and I have gathered some important information from this blog.
    Oracle Training In Chennai

    ResponderEliminar
  4. Oracle Training in Chennai is one of the best oracle training institute in Chennai which offers complete Oracle training in Chennai by well experienced Oracle Consultants having more than 12+ years of IT experience.

    ResponderEliminar
  5. There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.

    ResponderEliminar
  6. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.Informatica Training In Chennai

    ResponderEliminar
  7. A Best Pega Training course that is exclusively designed with Basics through Advanced Pega Concepts.With our Pega Training in Chennai you’ll learn concepts in expert level with practical manner.We help the trainees with guidance for Pega System Architect Certification and also provide guidance to get placed in Pega jobs in the industry.

    ResponderEliminar
  8. Our HP Quick Test Professional course includes basic to advanced level and our QTP course is designed to get the placement in good MNC companies in chennai as quickly as once you complete the QTP certification training course.

    ResponderEliminar
  9. Thanks for sharing this nice useful informative post to our knowledge, Actually SAS used in many companies for their day to day business activities it has great scope in future.

    ResponderEliminar
  10. Greens Technologies Training In Chennai Excellent information with unique content and it is very useful to know about the information based on blogs.

    ResponderEliminar
  11. Greens Technology offer a wide range of training from ASP.NET , SharePoint, Cognos, OBIEE, Websphere, Oracle, DataStage, Datawarehousing, Tibco, SAS, Sap- all Modules, Database Administration, Java and Core Java, C#, VB.NET, SQL Server and Informatica, Bigdata, Unix Shell, Perl scripting, SalesForce , RedHat Linux and Many more.

    ResponderEliminar
  12. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Sybase Training In Chennai

    ResponderEliminar
  13. 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
  14. 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
  15. 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
  16. It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command .
    PEGA Training in Chennai

    ResponderEliminar