Select Page

In recent weeks I have been writing training material for an introductory course for Qlik Sense Cloud. The training course is aimed at business users. It teaches the basic data discovery capabilities available in the Qlik Sense Cloud application. It also gets users familiar with Qlik Sense Cloud’s basic functionality.

In preparing the training material, I had to build a Qlik Sense App that contained data and attributes relevant to the application features and capabilities I wanted to cover. The App also needed to support delivering simple and clear demonstrations of the course material, as well as being able to be used as the basis of class exercises.

Before I could build the Qlik Sense App, I needed to find appropriate data. The data need to have the following attributes:

  • Contain a time series
  • Contain a hierarchy
  • Relatable (Familiar)  – nothing too technical or business specific
  • Contain numeric data that could be used in calculations
  • Available for free

After the better part of a morning looking for data on the internet I found what I needed. I had briefly considered data from the World Health Organisation (WHO) and the World Bank – there’s a lot of interesting data available for free from both of these organisations, which I may come back to in the future. However, I eventually settled on using Rugby World Cup data as it met all the required criteria and it was the most relatable and timely (as the Rugby World Cup has just started in Japan).  

With a dataset selected, I was able to start building the App in Qlik Sense. I wanted the App to include a reasonable proportion of the visualisation types available in Qlik Sense. The intention of the course is to demonstrate the search and select capabilities that are available to help a user understand their data.

I created the following four sheets in my Rugby World Cup App:

  • Dashboard
  • Trends over time
  • Performance
  • Match details

The first sheet, Dashboard, summarises the Rugby World Cup match data. It contains data on the number of matches won, lost and drawn and the average points scored and conceded. The sheet also allows you to filter by continent.

Sheet two looks at Trends over Time. Information on the average points scored for a win are presented in line and area charts.

The third sheet looks at the Performance of each Team that has competed in the Rugby World Cup. It contains data on the number of wins by team and the number of matches played.

Sheet four presents the Rugby World Cup Match Details in a table. It allows exploration of the data at a more detailed level. You can also filter this data by Continent, Team, Result, Year or Hemisphere.

 Over these four sheets the following type of visualisations have been included:

  • Scatter plot
  • Bar chart
  • KPI
  • Filter pane
  • Area chart
  • Line chart
  • Pie Chart
  • Combo Chart
  • Table

These different types of visualisations allow us to examine the data in interesting ways and to use all the different types of search and select capabilities in Qlik Sense Cloud. The table below details what selections you can use in each visualisation type. We go through how to use each one of these selection types in the course.

So, if you are a business user or analyst and want to learn about Qlik Sense Cloud and delve into the details of this app we would love to see you on our Qlik Sense Cloud: Introduction for Business User Course. If you want more information contact Steve Thomas on steve.thomas@optimalbi.com

 

Alison Rowe is part of our team of data analysts who make sense of data which enables better decision making. Check out the beginners guide to learning Qlik Sense, or connect with Alison on LinkedIn.

 

%d bloggers like this: