Creating a simple and effective Sales dashboard (with Qlikview)

Kunal Jain 18 Apr, 2015
3 min read

Appropriate space allocation and compelling visuals which convey business insights in meaningful manner are key to creating a good dashboard.

The dashboard / chart which I plan to cover in today’s post is one example of how you can do this effectively. I am creating this dashboard for a Sales led business, but that does not stop you from applying in any other field. The core idea can be applied to any area where you want to analyze outcome in multi-dimension.

Let us start with an example, where a Sales team is divided into Regions (4), which are further divided in four Zones (16). Each of these zones will contain numerous cities.

In excel era, Sales MIS would typically look something like:


Next, you can either create multiple sheets or tables in same sheet to show comparison at a zonal or city level. Alternatively, we can also add Pivot tables to the mix or group rows. However, none of these features give you a natural drill down (barring Pivot tables to some extent). If you use pivots to create a drill down, you need your customer to be comfortable with pivot tables, which may or may not be the case for business users.

If you are slightly more evolved in Business Segmentation and Analytics thought process, we can summarize the performance on a grid like this (remember, Low rejection rate => Better quality):


However, even this visualization also suffers from same problems of having limited drill-downs. This is where Qlikview comes in handy. One of the ways which I have found simple and powerful is to use box charts in Qlikview.  Following are a few screenshots of how the dashboard might look like with natural capabilities of drill ups and drill downs.

Please note that the screenshots are for just this chart object only and not the entire dashboard.


This screenshot tells the summary at Regional level, with size of box showing the volume of business and Colour of box showing the quality of business. The chart below shows what happens as soon as you click on North.


A glance at this chart can tell you:

  • North sources 29.67% of business, but quality is below average.
  • Within North, 55.56% of business comes from Delhi, but is of very poor quality.
  • On the other hand, there are some relatively smaller markets in North (Chandigarh, Faridabad & Gurgaon), which source good quality of business.

This is a simple example where we have brought out some key information with help of simple dashboard. In the next post, I plan to post a step by step guide of creating this dashboard and enhancing the same.

Do you know of any other application of this simple concept? If yes, please feel free to add them below or to reach out to me.


If you like what you just read & want to continue your analytics learning, subscribe to our emails or like our facebook page

Kunal Jain 18 Apr, 2015

Frequently Asked Questions

Lorem ipsum dolor sit amet, consectetur adipiscing elit,

Responses From Readers


Rajesh Ranjan
Rajesh Ranjan 21 Jun, 2013

I have worked on Qlikview and completely agree with you. Its really helpful for those who are dealing with complex MIS tools and other business dashboards. The best thing is that its easy to learn and although, if are new to Qlikview and stuck with some problem, Qlikview community ( is gonna help you. So no worries of expensive trainings, one can learn and use it him/herself.

Nagaraju 29 Jan, 2014

Tableau is another software by which we can create dashboards easily. But that software is too expensive. I dont have any idea on it an open source software?

Creating a simple and effective Sales dashboard (with Qlikview) - Part 2 - Analytics Vidhya
Creating a simple and effective Sales dashboard (with Qlikview) - Part 2 - Analytics Vidhya 10 Jan, 2024

[…] my last post, I discussed how a simple dashboard can provide information effectively. I will continue from where I left and go through the steps involved in creating the […]

Take a note

10 Nov 23 • 08:00pm

View all notes