COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: barrysaab on 30 Jun 2013 12:34:01 PM

Title: Best Practice for developing dashboards
Post by: barrysaab on 30 Jun 2013 12:34:01 PM

I  have tried to find out best practices to be followed while developing dashboards with both relational and dimensional data.Any ideas would be highly appreciated.Thanks
Title: Re: Best Practice for developing dashboards
Post by: Dineshkumar on 02 Jul 2013 05:55:22 AM
Hi,

Best practice would be reusing quries (query reference), layout component reference, less javascripting. Show summary data would be a better approach.

-Dinesh
Title: Re: Best Practice for developing dashboards
Post by: charon on 02 Jul 2013 10:56:50 AM
Also, reconsider the requierements/ requests and evaluete them in order to use the best possible fitting tool.
You can build dashboard within a cognos connection portal page, in Report Studio, Workspace Advanced or Workspace or even with Active Reports.
Which tool and technique to use depends on the set on requierements.
Good luck :)
Title: Re: Best Practice for developing dashboards
Post by: barrysaab on 03 Jul 2013 12:02:13 PM
Thank you all.
Title: Re: Best Practice for developing dashboards
Post by: CognosPaul on 04 Jul 2013 01:15:14 AM
Terminology can be a difficult thing. I tend to try to stick with Stephen Few's definition:
QuoteA dashboard is a visual display of the most important information needed to achieve one or more objectives, consolidated and arranged on a single screen so the information can be monitored at a glance.

A dashboard has no prompts, presents only the information needed in an easily digested and instantly understandable layout. Many visualization experts talk about the ink to information ratio. Chart borders, background images, harsh colors, and extraneous highlighting and animation are all things that serve to distract and hide information from the user. Instead of highlighting, small indicators can be placed to draw the users' eyes to information that needs their attention. Section separators are not as important as people tend to believe - we are very good at seeing invisible lines that separate groups (the gestalt principal). See the Kanizsa triangle as an example of seeing invisible lines (read more here: http://www.plosone.org/article/info%3Adoi%2F10.1371%2Fjournal.pone.0040106 (http://www.plosone.org/article/info%3Adoi%2F10.1371%2Fjournal.pone.0040106))

Workspace and pages with prompts are interactive analytical applications. Their design should follow the rules of dashboards, but should take into account where the user prefers to look in order to place the prompts. The data should always be the focus. I tend to put the prompts on the right side of the screen, with a slider to let the user hide or show the prompts as needed.

There are thousands of books, articles, and research papers on how to build effective dashboards. I hope you like reading. Here are just a few:

That is just the short list. I strongly recommend going over Stephen Few's and Edward Tufte's websites for more.
You can tell - I'm a lot of fun at parties

That's just the design phase, not related to Cognos.  On the implementation side you have a many options. To narrow down how to proceed, you should determine exactly what the users' needs are.


If the user wants a 20 page document in his email every morning, it will involve a different design methodology than if he's asking for a dashboard combining data from disparate parts of the organization. If he's looking for prompts, then using multiple cubes in a report will be difficult (though not impossible). If he wants instant results, then look into caching and scheduling.

When interviewing the user, make sure to keep a pad and a pen. Take notes, and draw sketches of what you think the user is asking for. The last question is the most important, users can only ask for what they know. If something is difficult, inefficient, or goes against best practicies offer alternatives. "Instead of a 3d animated pie chart, how about a static column chart?", "instead of showing a graph showing a constant 100%, if you need to see outliers how about 100 minus actual?"
Title: Re: Best Practice for developing dashboards
Post by: barrysaab on 04 Jul 2013 09:38:36 AM
Thanks a million,PaulM.Very informative indeed!
Title: Re: Best Practice for developing dashboards
Post by: charon on 09 Jul 2013 04:32:09 AM
Awesome answer, thank you Paul. Love learning new stuff in here  ;D