Winning Dashboard Creation Tips from the QlikView Open Data Challenge Champion


Business intelligence (BI) software vendor QlikView recently ran a contest called the Open Data Challenge: here, BI users were to analyze data on populations, poverty, health, education, transportation and the environment, and create a dashboard that would inspire users to take action. And contestants could only use open data (meaning data that is publicly available for free download).

First-place winner of the contest is Alexandre Perrot: as a QlikView Solution Expert for Keyrus, he has a decade of experience developing business intelligence dashboard applications.

His dashboard “Do You Realize?” tells the story of how great the human impact is on our planet, and provides end users with resources for effecting positive change. Perrot completed the project in just three weeks: an amazing turnaround.

Do You Realize QlikView Environment Dashboard
The “Environment” screen of Perrot’s dashboard, displaying information about population growth for selected areas of the world.

I caught up with Perrot to discover the dashboard creation tips that helped win him first place in this contest. Here are some of his best practices for creating an effective and actionable application:


Think About the Data Before the Dashboard

Before you even begin to build your dashboard, you must think carefully about the data and how it will be used, says Perrot. It’s absolutely imperative to use accurate, relevant and reliable data: if your numbers aren’t sound, the insight they provide is misleading, and the dashboard isn’t useful.

You also need to organize this data and present it in a way that makes sense. Perrot commonly uses star or snowflake schemas, and this is what he suggests others default to. For most datasets, these models provide the best infrastructure for organizing data and enabling the end user to view it in a variety of different ways.

Here is the snowflake schema Perrot used in the “Do You Realize?” application:

Perrot Snowflake Data Model

Here, you can see that the user is given different dimensions they can interact with depending on how they want to view data: they can choose to filter the results by “Year” and “Country.” The field “KEY” is most important, because it provides the link between all other data tables.

This means that whether the user is viewing all the data at once or only looking at a specific country or year, they’re always looking at the same information, just from a different angle. In this example, the star schema is most efficient. Here, instead of recalculating the information every time a user specifies a country or year, all the data is always readily available—it simply displays different information according to the user’s specifications.

Perrot estimates that 60 percent of the time he spent working on this project went towards brainstorming how the end user would need to interact with the dashboard application. This included ensuring that he had the perfect data model to reinforce expected user behavior and to present the right information quickly, clearly and accurately.

It’s also important to think about how this data will be used. Here are some of the questions Perrot suggests dashboard creators ask business users:

  • Which Key Performance Metrics (KPIs) will be most important for the end user?
  • What story are you trying to tell through your dashboard?
  • Which data supports that story, and illustrates it most clearly for the end user?
  • What are the common dimensions of analysis between my different data sources?
  • Which data is the user going to click on and interact with?

Do You Realize QlikView Take Action Dashboard
The “Take Action” screen, which provides users with links to charities they can donate to in order to make a positive impact.

Develop the Overview Screen First

When looking at the overview screen—the high-level screen that summarizes the dashboard’s most important information—the end user should instantly understand what is wrong with his business (or, in the case of the Challenge, what is wrong with the world).

Perrot recommends building this screen first; when creating “Do You Realize?,” he started with the “Overview” screen. Next, he builds additional screens that will help the user better understand the significance of a given KPI: here, the “Environment” and “Health” screens.

Finally, he builds out a screen that allows the user to compare different data points and build their own analysis. It’s important to work in this order, Perrot says, for a few reasons:

  • The overview screen is essentially a high-level summary of the your most important KPIs. If this screen isn’t clear, it means that you don’t know what you want to explore and demonstrate with your dashboard, says Perrot.
  • Since it presents all the most important information in one place, the overview screen is where the majority of your end user’s business questions will arise from. You have to imagine all the questions the end user might have after seeing the dashboard, and develop the other views to help him answer those potential questions.
  • Once the overview is clear, Perrot says, the rest of your application and the story it tells will come naturally. Without having this first, you’re likely to develop overly complex, inconsistent screens—or worse, screens without relevance to the end user’s business needs.

Do You Realize QlikView Overview Dashboard
The Overview screen for “Do You Realize?” provides a snapshot of the most important KPIs for the world as a whole and how they have changed over time.

Create a Dashboard That’s Both Attractive and Informative

As with so many things in life, first impressions are crucial when it comes to your dashboard. A well-designed, attractive dashboard is more compelling to the end user—as long as it’s also functional. Your design choices can also inform your data, indicating important things to the reader that help them understand the greater message.

→ Use color to convey change. Change over time is a key component of almost any dashboard. According to Perrot, the best way to help the end user quickly visualize this is to use color coding. Assigning colors to trend lines or data points can tell you something about the data: for example, green means the measure is moving in a positive direction; red means it’s not.

Use Color to Convey Change

→ Use a four-column table to express change. Another effective way to represent change over time, Perrot says, is to use a table with a time breakdown (usually by month) and at least four columns, which contain: the actual value; the comparative value; the percentage or value of change; and a color indicator (red or green).

Four Column Table QlikView Dashboard

→ Choose function over form. If you have to choose between form and function, lean towards function. A dashboard that’s pretty but that doesn’t work right isn’t worth much to the end user. For example, Perrot’s dashboard includes both clickable countries and a search field to make sure users are able to quickly drill down to country-level specificity.

Function Over Form QlikView Dashboard Search

Make Your App Easy Enough for Anyone to Understand

Make sure that the analysis your dashboard conveys can be easily understood by all end users. Without having any prior knowledge of the subject, the user needs to be able to look at your app and instantly understand what message the data is trying to convey and what it means to them personally.

  • Since dashboards help business users make decisions quicker and more easily, you need to create applications that lead the uninitiated user to the same conclusions you came to. Perrot says his ultimate test is to show his completed dashboards to his wife: “If she doesn’t understand everything, it means something is wrong and I need to restart.”
  • In this Challenge, Perrot’s primary goal was to keep it simple. If you try to include too much information in your app or clutter it with graphs and tables, he says, the end user will get lost. Here, it was also important to clearly and directly tie the KPI data to specific actions the user can take to make a difference.
  • When building dashboards, Perrot recommends getting straight to the point. Display the most interesting data the most prominently—and, perhaps most importantly, use visual elements that help users understand where the numbers come from and how they evolve over time.

Simple QlikView Dashboard
Perrot’s dashboard is simple and to-the-point: important information is displayed prominently, charts and graphs convey change over time and pop-ups provide a summary of relevant data.

While these are good general guidelines, don’t be afraid to break your own rules: in the end, always let the data dictate your dashboard. For example, when developing QlikView applications, Perrot usually puts the dimensional filters of the left side of the screen.

For the Challenge, however, he wanted to use the left side to navigate the different sub-menus as well as to access outside sources like video. There’s always room for innovation.

Following these best practices helped Perrot win first place in the QlikView Open Data Challenge—and you, too, can use them to create more effective and actionable dashboards that inspire your users to take action.

Share this post:  
Holly Regan

About the Author

Holly Regan is the Content Editor for Software Advice. Her work has appeared on many notable sites, including The New York Times, PRNews and oDesk. She has also contributed to works on top-tier publications such as Entrepreneur, the Wall Street Journal and Business Insider.

Connect with Holly Regan via: 
Email  | Google+  | LinkedIn