Social Media BI and Social Media Analytics are hot trends in the BI industry. As Microstrategy, IBM, SAP and other BI Vendors are investing in social media analytics it is a good time to show the possibilities with QlikView. It has been pretty quiet from QlikTech’s site in the social media analytics sphere so this is a great opportunity to showcase the possibilities developed by QlikTech partners. In the first blog post of this series “Twitter Analytics in QlikView” I will introduce you to Twitter and Twitter Analytics. I will start from the beginning by helping you set-up a Twitter account and learn some of the Twitter basics, before moving to the second part of this series called “Twitter Analytics – Finding Top Influencers”. Here we will introduce you to Twitter Analytics by showing how to find the top influencers in an industry and measure two important social media KPI’s: the number of brand “Promoters” and “Detractors”. If you would like to run the examples in this post with your own company or client’s data, simply download the Twitter Analytics Dashboard and follow the instructions on the QVSource Wiki. Make sure to download and run the latest version of QVSource before reloading the Twitter Analytics Dashboard.

Twitter is a great way to promote your brand, share thoughts and keep updated about the latest trends and insights in the BI industry. It can be a valuable source of traffic for your site and a good way of getting in touch with other Qlikview Professionals. The goal of this series is to show how easy it is to get started with Twitter analytics in QlikView, by providing easy to follow steps. After reading this series you should be well on your way of becoming a true Twitter BI expert.

Part 1 - Introduction to Twitter for QlikView
Part 2 - Twitter Analytics in QlikView – Finding Top Influencers

In this first blogposts in the series “Twitter Analytics in QlikView” I will introduce you to some of the Twitter basics. A basic working knowledge of Twitter will be required before starting with the more advanced part of this series called “Twitter Analytics in QlikView - Finding Top Influencers“. In the follow up post I will show you how to analyze Twitter data, find top influencers in an industry and measure two important Twitter KPI’s: brand “Promoters” and “Detractors”. But first let’s dive into some Twitter fundamentals for QlikView professionals.

Setting up a Twitter account

The first thing you will need to do is create a Twitter account though this link. Simply fill in your name, e-mail address and choose a nice Twitter name. The name can be changed afterwards so don’t worry too much about this at this stage. In the second part of the signup process you will be asked to fill in some additional information and create a profile description. Make sure to include some words you would like to be found on, like “QlikView”, “Business Intelligence” or “Business Discovery”. Adding these words will make it easier for like minded people to find you when searching for new profiles.
Read more

In this second blogpost in this series called “Twitter Analytics in QlikView” I will show how to use QlikView to find the top influencers in your industry and measure two important social media KPI’s: the number of brand “Promoters” and “Detractors”. For people new to Twitter I recommend reading the first blog post in this series called Introduction to Twitter for QlikView, where I introduced some of the Twitter basics and helped setting up a Twitter account. In this second part we will start analysing Twitter data using the “QlikView Twitter Analytics dashboard” developed by QVSource. If you would like to run the examples in this post with your own company or client’s data, simply download the Twitter Analytics Dashboard and follow the instructions on the QVSource Wiki. Make sure to download and run the latest version of QVSource before reloading the Twitter Analytics Dashboard.

The main focus areas of this post will be:

• Finding top influencers
• Measuring a person’s Influence with “Klout” scores
• Measuring brand “Promoters” and “Detractors” trends
• A list of influential people to add on Twitter

To analyse influence we will use the influence tab on the QlikView Twitter Analytics dashboard as shown in the screenshot below. If you click on the dashboard you can see the top brand “Promoters” and “Detractors”, plus influencer’s trends for the BI industry based on two weeks of data collected from Twitter. We will discuss the details of the graphs in the following sections.

Read more

In this blog post I would like to share my favourite QlikView Dashboard examples. QlikView is an awesome Dashboard and/or data visualization tool that has been able to revolutionize the BI market. It is fun, intuitive and really easy to learn. All the examples below are available for download from QlikView or QVSource and can be tested at home, using the QlikView Personal Edition. I have been working with QlikView for a little over a year now and thought it would be nice to share my personal favourite Dashboards. Some are innovative, some useful and others are great for learning purposes. Enjoy the read!

Facebook Friends Analyser

The Facebook Friend Analyser Dashboard can be downloaded from QVSource. This is a really great dashboard allowing you to analyse Facebook friends in ways you didn’t knew was possible. You can analyse “Friends”, “Groups”, “Likes”, “Sentiment”, “Check-ins” and cross segment the data using dimensions as “Relationship”, “Gender” and more. What makes this dashboard truly unique is that it offers some really good learning opportunities for advanced techniques such as integrating Google Maps, Social Media Measurement, Sentiment Analysis and Geocoding in QlikView Dashboards. The code behind the file is easy to understand and with some minor modifications you can start applying these techniques to your own dashboards. At the time of writing the latest version includes a Google map which uses friend “locations” that are converted to latitude/longitude with the Yahoo Placemaker API. To run these examples make sure to run the latest version of QVSource and follow the instructions on their Wiki.

Read more

Recently I read an interesting blog-post about how to merge Google Analytics data with a Data Warehouse. Integrating data from your website with Data Warehouse data opens up a whole new range of optimization possibilities. It allows you to add customer data, purchase data or demographic data  from your organisation to your website data. Another example could be measuring offline sales generated through your website. In my previous post I showed how easy it is to pull Google Analytics data in Qlikview. This post I will dedicate on showing how to create a key between website and website data, allowing you to associate Google Analytics with offline data in QlikView.

Setting up the primary key.

In the example above you see a Qlikview Dashboard pulling data through two different sources, Google Analytics and CRM data. In order to produce this type of holistic view of our channels we first need to create a (primary) key between the different data sets. Once the key exists Qlikview will automatically associate the data.

Read more

This is my first video in a series called Google Analytics offline online data integration. In this post we will be building a dashboard where we pull in Google Analytics data and plot it on a Google Maps. The video above will show you how to build this application!

The goal of the first video is to introduce you to QlikView as a business intelligence and data visualisation tool. In the next video we will go one step further and start adding sales data from a back-office application. This will allow us to create a holistic view of our data, for example measuring sales from a keyword to an offline purchase.

Read more