Technologies | April 12, 2021

Qlik Sense – a Business Intelligence tool for everyone

What is a Qlik Sense tool? How you can develop a simple application yourself, using a free account? Read the article!

Qlik Sense – a Business Intelligence tool for everyone

Many implementations of tools in companies start from a bottom-up initiative. It often turns out that one of the employees starts using a tool to facilitate their work, recommends it to a colleague, and so the tool begins to be used more widely in the organization, the natural consequence of which is an official implementation. An example of such a tool is Qlik Sense, a system that facilitates independent data analysis.

You do not need any programming knowledge to test them, and you can develop a simple application yourself, using a free account. In the article, I will guide you step by step how to do this.

Hobby: data collection

The example of Michał Rogalski proves that bottom-up initiatives can turn into large-scale projects. Michał is a young data analysis specialist and enthusiast who has created a database on the coronavirus pandemic, based on publicly available sources and available to everyone. Today, everyone, even if they are not as passionate about data as Michał, can conduct an analysis for their own purposes using widely available Business Intelligence tools.

Qlik Sense Cloud – the perfect BI tool?

Nowadays the range of Business Intelligence tools on offer is huge. The most well-known of these tools are:

  • Microsoft Power BI
  • Qlik Sense
  • Qlik View
  • Tableau

Today I would like to focus mainly on the cloud version of Qlik Sense, because it is a good choice if you want to test the tool’s capabilities for your own purposes. I will show you how to easily create an analytical application that can initiate the implementation of Qlik Sense throughout the entire organization. You can try the cloud version of Qlik Sense for free for 30 days. To access the tool, you just need to create an account on the Qlik website:

2020.12.09 jpro graphic 1

An advantage of the cloud version is that you can use it on any device – Windows PC, Mac, tablet or smartphone, regardless of whether it’s an Android or iOS device.

The first Business Intelligence application – where to start?

The first step is the hardest to take. And how to take it in the world of data analysis? Once we have access to Qlik Sense in the cloud version, a simple Excel sheet is enough to start with. We will develop an application based on this – don’t worry, no programming knowledge is required here. I will also use publicly available sources to show how to easily build an application that analyzes data on the coronavirus pandemic.

  1. We download Excel with publicly available data:
2020.12.09 jpro graphic 2

2. You do not need to know any programming languages or SQL scripting skills to build your first application. In Qlik Sense, many basic operations can be performed using the “Drag & Drop” option.

2020.12.09 jpro graphic 3
2020.12.09 jpro graphic 4

After dragging the Excel sheet with the data, the script will be generated automatically, based on which you can build a data model. Now we just need to create the visualizations that we are interested in. In this case, we will base them on simple aggregation functions that have equivalents in Excel.Based on Excel, our application will contain 2 reports which will analyze the number of cases and tests. We will build the application based on one scheme, which will include:

  • A panel of the most important filters
  • A line chart for analysis over time
  • A KPI type object with the number of cases
  • A pie chart showing data by location
  • A map with marked-out areas, colored according to the number of cases

3. We start with the filter panel.In the report editing mode, on the left, select Charts and drag the Filter Panel object onto the report.

2020.12.09 jpro graphic 5

Then we add the dimensions that interest us (in this case: the year). The search tool for fields previously loaded into the model makes it easier.

2020.12.09 jpro graphic 6

We can change the name displayed on the report by filling in the Title field. For example: Year

2020.12.09 jpro graphic 7

4. We create a bar chart objectWe drag the object in the same way as the filter panel.For the dimension, we select the Year-Month field (automatically generated earlier by the Qlik engine based on the date field in Excel). We add a measure analogically  – we choose the field on which the measure will be based, as in the case of dimensions. In our case, the new cases.  After confirming, we select the aggregate function – in this case, the sum.

2020.12.09 jpro graphic 8

5. Finally, in the Appearance section, we can go to Presentation and select the display type as an area.

2020.12.09 jpro graphic 9

The final result will look like this:

2020.12.09 jpro graphic 10

6. We create a KPI object.
The KPI object will use a similar measure. We drag it onto the report and add the measure in the same way as we did in the line chart. You can add a label to enhance the look, just as with the filters panel.

2020.12.09 jpro graphic 11

7. We create a pie chart
Similarly, we create a pie chart object. In the dimension section, however, we select the location field to present the number of cases in a given location. The final result looks like this:

2020.12.09 jpro graphic 12

8. We create a mapThe map object is the last thing to be created. After dragging the map object, we click the add layer option and select the area layer. We choose location again as the source dimension.  This is when we can take care of the colors of our visualization. To color the areas, go to the colors option. We choose custom settings and the option “According to measures”. As a measure, we enter the sum of new cases known to us.

2020.12.09 jpro graphic 13

9. Below, we choose Divergent Gradient as the Color Scheme and check the Invert Colors option.

2020.12.09 jpro graphic 14

The final result is as follows:

2020.12.09 jpro graphic 15

And the report looks like this:

2020.12.09 jpro graphic 16

Due to the fact that subsequent reports will be created according to the same scheme, we can copy the entire report and replace the measures with those that analyze daily test increments (new_tests) in subsequent copies. To copy a given report, just go to Application Overview, select the report, right-click on it and select Duplicate.

2020.12.09 jpro graphic 17

This way you have just developed your first data analysis application without coding.

After replacing the measures with those calculating the number of tests, the report looks like this:

2020.12.01 jpro graphic testy 1

Implementation of Qlik Sense in the organization

At the beginning I mentioned implementations in organizations inspired by bottom-up initiatives. Let’s imagine that you have tested the tool’s capabilities, and data analysis painted such a picture that you have managed to reach the CEO and convince him to implement the Business Intelligence system at your company.

What now?

In the case of commercial implementations, it is worth having the support of a technology partner. All you need to do is reach out to a company with Business Intelligence implementations in their portfolio. At JCommerce, we implement both Qlik Sense and the aforementioned Microsoft Power BI solutions. As part of the project, Business Intelligence specialists will:

  • collect requirements,
  • configure the server,
  • prepare data that will feed the applications,
  • build a package of basic analyzes that users can freely modify and extend later on in self-service mode,
  • take care of support and maintenance of the environment and develop the tool if necessary,
  • conduct training for users and assist them.


Low-code, no code solutions and Data Democracy are becoming increasingly important. As you can see, thanks to their combined forces, creating your own analyses based on simple data is a piece of cake, and the results may surprise you. Even larger and more complex data sets can be analyzed in a similar way, provided that they are properly prepared during the initial implementation.

As a result, business users who are unfamiliar with complicated programming languages can create their own reports using the “Drag and Drop” option and taking advantage of simple aggregation functions. If you are interested in this subject, please contact us to discuss how your company can take advantage of the possibilities created by analytical tools.

FotoInetum abstract18


Use data to your advantage

Discover our Data Management End-to-End offer! Find out more!

An enthusiast of QlikView and Qlik Sense solutions and a Business Intelligence consultant at JCommerce. A graduate of the Jagiellonian University and the University of Economics in Krakow. A fan of music in every form.

Exclusive Content Awaits!

Dive deep into our special resources and insights. Subscribe to our newsletter now and stay ahead of the curve.

Information on the processing of personal data

Exclusive Content Awaits!

Dive deep into our special resources and insights. Subscribe to our newsletter now and stay ahead of the curve.

Information on the processing of personal data

Subscribe to our newsletter to unlock this file

Dive deep into our special resources and insights. Subscribe now and stay ahead of the curve – Exclusive Content Awaits

Information on the processing of personal data

Almost There!

We’ve sent a verification email to your address. Please click on the confirmation link inside to enjoy our latest updates.

If there is no message in your inbox within 5 minutes then also check your *spam* folder.

Already Part of the Crew!

Looks like you’re already subscribed to our newsletter. Stay tuned for the latest updates!

Oops, Something Went Wrong!

We encountered an unexpected error while processing your request. Please try again later or contact our support team for assistance.

    Get notified about new articles

    Be a part of something more than just newsletter

    I hereby agree that Inetum Polska Sp. z o.o. shall process my personal data (hereinafter ‘personal data’), such as: my full name, e-mail address, telephone number and Skype ID/name for commercial purposes.

    I hereby agree that Inetum Polska Sp. z o.o. shall process my personal data (hereinafter ‘personal data’), such as: my full name, e-mail address and telephone number for marketing purposes.

    Read more

    Just one click away!

    We've sent you an email containing a confirmation link. Please open your inbox and finalize your subscription there to receive your e-book copy.

    Note: If you don't see that email in your inbox shortly, check your spam folder.