15 tips on how to get more from Business Intelligence data

See also: Business Intelligence, a timeline

IT industry is awash with talk of Big Data and in-memory engines. I believe we should be putting our effort into producing simple and useful data that is presented in a format that helps people communicate and make quality decisions.

Companies have invested heavily in Business Intelligence systems for many years (Gartner Research Reports BI Market Revenue Hit $12.2bn £7.83bn in 2011), to aid decision making, but do they really get value from the information they collect and present? 

Typical Data Presentation
There are commonly three key trends in the creation of BI reports:

1 - Manual comparison
Many management packs' have pages of tables of numbers that require readers to manually compare one month, region, or product with another to try to identify trends, patterns or outliers. This is both time-consuming and hard work.

2 - Confusing charts
Where charts are used (usually pie or doughnut) the eye is naturally poor at comparing areas and angles, so the reader usually struggles to make proper comparisons and must refer to the legend.


3 - Over-complex presentation
Some report or presentation creators use the latest flashy 3D dials and animated components. These may look impressive but often merely prove a distraction and rarely enhance communication.

The end result is reports that make life hard for those that need to make insightful decisions; consequently information is either ignored or takes too much time to interpret.

Most of the BI tools we use today tempt us into making one of these three mistakes described above.

A measured approach
To find the best way to present data, you need to understand what crucial information needs to be presented and how it can be used:

 - Define what metrics will help you manage my team or role better
 - Decide what is the most important metric, or the one the makes the most impact
 - Establish which metrics you can improve on