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.
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.
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.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.