Picking dashboard visualizations

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

The correct answer is D: A KPI object, a line chart, a straight table

There is always a part of personal preference in creation and design of Qlik apps. However, if we want to follow the given requirements closely, then the right answer needs to contain a straight table. Let’s have a look at all four options and see how they stack up against the given requirements:

• The revenue of the current year and last year
• The average margin over the last 12 months
• The top 10 products with associated details

Below you can see each answer visualized in a small dashboard:

Now let’s see how well each of these matches the requirements.

The revenue of the current year and last year

The revenues for the current and previous year ar most clearly visualized in a KPI Object.

The request for the revenues of the current year and previous year are most clearly visualized in a KPI Object. It will show the amount of revenue clearly where current year is shown as the primary KPI and the sales of the previous year as the secondary KPI.

In this question the requirements are followed to the letter, but we could improve on this by adding a year to date comparison to the object. Comparing the same period in the last year with the same period in the current year will give us a better understanding of how good, or bad, the results are.

We could also improve on this visually by using the measure for the revenue last year as limit for the conditional color. This gives a visual representation of whether the revenue of the current year is above or below last year:

A green KPI with a plus symbol when the revenue is above last year

A red colored KPI with a minus symbol when the revenue is below last year

The pie chart (answer B) representing the revenues of each year only shows how these values are divided between the years. Not very applicable for understanding how much revenue is created. If we apply the same trick and create a YTD overview of the pie chart, while it does create a visual representation of which year currently has the bigger part of the pie, the most important request, the actual revenue, is not visible.

The average margin over the last 12 months

The next request is to show the average margin of the last 12 months. While technically the gauge shows this measure, there is not much point in showing it like this. The gauge object is meant to fill up to a certain value and show how far along you are, more like a speedometer in a car for example.

In this case a measure like average margin is more or less likely to hover around a single value, negating the visual effect of the gauge. Also while the value shown is indeed the average over the last 12 months, there is no clear way to check and know that, the months are not visible after all in a gauge. Using a line chart makes it immediately visible over which months the margin is shown, as well the change over time. In this case while the average is around 11%, we can see that around June, July and August 2021 things have greatly improved the margin going forwards, making it able to analyze what these changes were or whether certain business changes have indeed resulted in the desired effect.

The top 10 products with associated details

And then finally the chart with most debate. While we agree that for a quick glance management overview Answer C is the best and visually clearest solution. However, the request in the requirements clearly stated that the top 10 products with associated details were to be shown. In this case a straight table will contain those. However we have no doubt in your abilities to find a great solution and convince the business of better solutions.

Are these questions too easy for you?

If these questions are too easy for you, then you may be ready for the Masters Summit for Qlik.

At the Masters Summit for Qlik, we take your Qlik skills to the next level in 3 days with deep dives about:

• Qlik Data Modelling
• Qlik Scripting
• Set Analysis and Advanced Aggregations
• Solution Architecture & Performance
• Effective Visualizations
• Performance Tuning
• Qlik Sense integration

The courses are taught by Qlik veterans Rob Wunderlich, Oleg Troyanksy, Bill Lay, Nick Webster and Bitmetric’s Barry Harmsen. Together, this team brings almost 75 years of Qlik experience and has implemented hundreds of successful projects.

You can find more information and registration on the Masters Summit for Qlik website.

See you next week!

 That’s it for this week. See you next Friday? And remember:

• If you have suggestions for questions, we love to hear from you via WhatsApp or at info@bitmetric.nl
• If you’re enjoying these questions and want to work on stuff like this every day (but a bit more challenging), we’re always on the lookout for new colleagues. Check our job openings here.
• For more of these brain teasers, check out our archive of Qlik certification questions and answers.
• Want to stay up to date about everything Qlik? Then sign up for our newsletter below: