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.
Twitter Sentiment Analysis
This is a really awesome Twitter Sentiment Analysis Dashboard developed by TiQ Solutions. It shows how social media streams can be analysed and visualized using QlikView. It can analyse a person’s emotions from published tweets, status messages or online comments. Unfortunately at the time of writing the code behind the file was not available from the demo app so you will have to contact TiQ Solutions for more info. Alternatively you can download the Twitter Dashboard Example from QVSource and rebuild the sentiment analysis part. QVSource offers two easy to use Sentiment Analysis API connectors which can be applied to any data source. As a starting point you can use the Facebook Friend dashboard above. Make sure to follow the steps on their Wiki and within no time you will be able to apply advanced sentiment analyses techniques on Twitter or any other data source.
Salesforce CRM Dashboard
Understanding how to load and analyse CRM data is a critical skill for any analyst, QlikView or BI developer. The great thing about Salesforce is that it is a cloud based solution that’s offers a Free Salesforce developer account for testing purposes. The developer account contains dummy data which can be used to populate the Qlikview Salesfoce dashboard. Before you can use this dashboard you will first need to install the QlikView-Salesforce Connector. I recommend reading the following blogpost to get started. Some extra tips. Do not forget to register your account on the QlikTech site otherwise the Connector will not appear in the download section. Also make sure to follow the instructions in the Salesforce dashboard on how to add the Salesforce security token to your password.
Whats new in QlikView 10
“Whats new in QlikView 10” is a QlikView dashboard example developed by QlikTech showing the latest features of QlikView 10. What makes this Dashboard so great is that is contains some really good chart examples that can be used in your own Dashboards. When I started developing in QlikView I downloaded this dashboard, replaced the code behind the file with my own code and re-enabled all the charts. A good example is the “Regional Scorecard” in the middle of the screenshot. It shows an overview with: Sales this year vs previous year, percentage difference, sparklines for trending and conditional formatting showing when KPI’s are off target (highlighted in red). The overview uses set analysis functions to compare budget against target (the grey-red dots). Finally the dashboard demonstrates how to use spark lines or formulas in standard selection fields in the top and left side of the dashboard. A lot of good educational stuff.
What is so great about this Dashboard is that it shows how to include qualitative survey data in quantitative dashboards. Combining quantitative and qualitative data opens up a whole new range of analytical possibilities. In the book Performance Dashboards: Measuring, Monitoring, and Managing Your Business the author describes how Cisco is using a Performance Dashboard to monitor over 50 qualitative metrics that impact revenue. In Cisco they use regression analysis to predict the degree to which targeted improvements in internal processes improve customer experiences and satisfaction, which in turn, will drive increase in revenue. Also within the field of Web Analytics there has been a lot of discussion about Voice of Customer data supplementing quantitative website data to get deeper insights. There are some good free online survey tools like 4Q and Survey Monkey that allow you to run on-exit surveys on your website in order to automatically collect customer feedback data (like the ones they sometimes use on the QlikTeck site). Especially 4Q is very good. By asking 4 simple questions they can measure important KPI’s as Task Completion Ratio and Overall Satisfaction scores.
Financial Controller Dashboard
The Financial Controller Dashboard is a great Dashboard with a very good business like design. No distractions in the form of fancy colours or graphs, but clear communication of the most important KPI’s and data. What caught my attention in this QlikView example is the “Profit and Loss Overview” in the upper left side of the screen, containing performance metrics “Revenue”, “Cost of Goods”, “Gross Profit” etc. What is special about this chart is that the “KPI names” are actually loaded as a dimension, allowing them to be used in a single chart element. In most QlikView dashboards these types of overviews are built manually with Text charts. I will leave it as homework to examine the load script behind the file and understand how this example is built.
Linked-in Contacts Analyser
This LinkedIn QlikView example might not offer direct business insights in terms of KPIs or key metrics yet, but it is really cool. Given how fast LinkedIn, a professional social networking site, is growing I am confident that analysing LinkedIn data will become an integral part of social media analytics. Being a LinkedIn fan it is also fun to play around with the Dashboard and slice and dice the data. If you have managed to get this far reading this blog post, than don’t forget to add me to your LinkedIn network! I am always looking for opportunities to extend my professional network in the area of BI, QlikView and Web Analytics. Here is my public LinkedIn profile and Twitter account. Just drop me a personal invitation referring to this blog post and I will be happy to add you!
QVCook Book and Set Analysis
The final two applications are not real dashboards but offer real good learning opportunities. The first application is the QlikView cookbook developed by Rob Wunderlich. This application contains excellent “how to” examples for common QlikView tasks, like incremental loads, interval match etc. The final application contains good information about set analysis for time periods and shows how to flag time periods in a load script. Set analysis is an advanced QlikView topic and having some good code examples is always useful!
I hoped you enjoyed the read! Are there any Dashboards you believe I forgot or should have added?BI, Dashboards, qlikview, QlikView Examples