A Cognos 10 Dashboard

Cognos 10 offers a huge library of charts. Several new types were added in the last release. There are now over 160 different charts available. Amongst the new additions, you will also find Stephen Few’s bullet charts. They nicely complement the existing sparklines that were already available in version 8.4. Cognos 10 also provides new and enhanced color palettes that help design beautiful reporting objects. Overall, Cognos 10 offers some really cool options for building effective dashboards.

A SAMPLE DASHBOARD

My colleague and friend Paul sat down last week to quickly create a sample dashboard in Cognos 10 using the new stuff. He took the new charts and also applied one of the palettes. Take a look – I love it! It’s simple but very effective. As a sales executive, I will immediately obtain an overview of my business.

Cognos Sales Dashboard

ACTIVE REPORT

Bullet charts and sparklines are also available for Active Reports. You can therefore build awesome looking dashboards for online and offline use. Even better: they also work with the new iPad app.

If you happen to attend BAForum in Las Vegas in a few weeks from now, make sure to look for some the sessions that discuss Cognos 10 and dashboarding techniques in detail.

 

 

Why sparklines sparkle in a dashboard

SPARKLINES SPARKLE

One of the key features of the dashboard in any car is the fact that it is on a ‘single page’. Car dashboards are usually very simple and it doesn’t take us more than a few seconds to familiarize ourselves in a new vehicle. Could you imagine driving a car with a complicated dashboard? Could you imagine having to scroll through multiple pages to get a speed reading while you are driving down the German Autobahn with 200 km/h? The answer is no.

THE CONSTRAINTS

Good management dashboards should be concise as well. Executives especially don’t have the time and patience to scroll through multiple pages of information. But that often creates a problem: We have a lot of information to show but there is limited space. This problem arises especially when we want to show trends. A typical dashboard might want to show profits, margins, win/loss ratios, revenue, pipeline across multiple regions. One way to display this rich set of data in a table. But tables are ineffective in quickly displaying trends. And they take up a lot of space. The other option would be to show multiple line charts. But those take up a lot of space as well.

THE SPARKLINE

Information design guru Edward Tufte developed a solution for this problem. He created a new but very simple chart called a ‘Sparkline‘. He describes them as “data-intense, design-simple, word-sized graphics”. In other words: sparkline charts are very small, yet they display vital trend data. Take a regular time series such as revenue by months. Stick that into a sparkline chart. Below is an example:

Simple sparkline charts

ELEMENTS

When you look at the example above, you will notice how easy it is to spot the general trend: the Conservative Party is loosing ground. You have also noticed the little dots. IBM Cognos 10 allows you to color code the low, mid and high point. (red, black, green). The Green Party is gaining. You can hover your mouse over the line to get the actual value. This type of chart simply provides the ability to obtain a quick overview of the general trend and all that within a very tiny amount of space.

SPARKLINES AT WORK

Sparklines truly show their full potential when you supplement them with metrics or other charts. Take a look the next example:

Sparklines in action

The above object allows us to review margins across regions. The sparklines quickly display the trend. The trend is supplemented with more detailed information. Notice how concise and compact the total object is. And here is an example where we can see the sparklines integrated into a regular dashboard:

A sample IBM Cognos 10 dashboard

The upper part allows us to quickly provide an overview of critical metrics across different dimensions.

SPACE SAVERS

In a prior blog post I discussed the bullet chart. Those charts are also quite small and highly useful. When you combine the sparkline with the bullet chart you have a powerful combination. Notice how much information we are able to absorb (trend, actual value, current performance). A traditional line chart would take up a lot more space.

Sparkling Bullets

SPARKLINES – A FINAL WORD

Sparklines are great for displaying trends. This is ideal for supplementing current information (e.g. YTD Sales). They are tiny, they are easy to use and they are easy to understand. However, they will not replace a traditional line chart. Line charts are definitely a better choice when you want to perform a more detailed analysis. Next time you build a dashboard try to incorporate some sparkling charts.