According to Peter Hopwood, business intelligence (BI) reports tend to suffer from three things: confusing charts, overly complex presentation, and pages of data that people have to pore through by hand in order to compare it. If the point of BI reports is to help you make better business decisions, then why are they so hard to understand?
Taking the Measured Approach
Hopwood offers a better way. He provides three sets of tips that can get you off on a better foot when preparing reports. The first set has to do with deciding what constitutes crucial information. To that end, you should define the metrics that help you manage your team, decide which metric has the most impact, and establish which metrics you can improve upon.
The second set of tips has to do with how these metrics should be used. Hopwood says you should decide whether trend or precise value is most important, figure out where you need to see variance, and select whether categorizing, grouping, or aggregating the data will provide the best overview. The third set of tips finally is about presenting your information in the cleanest way possible. Here are his quick tips for presentation:
- Simple line and bar charts are often the most effective way to show most types of management information.
- Line charts are better for looking at trends over time.
- Bar charts are applicable for category comparisons.
- Bullet charts are good for a compact comparison between actual figures and targets.
- Spark lines are appropriate for providing an overview of a trend.
- For more complex problems, tree maps, heat maps, and bubble charts can be effective.
When you follow all three sets of tips, Hopwood says customers have reported improvement in user adoption, clearer presentation of data, and successful trend identification. If that sounds like a good deal to you, click here for Hopwood’s full article: http://www.computerworld.com/s/article/9228824/15_tips_on_how_to_get_more_from_Business_Intelligence_data