Business Intelligence – Do You Have The Facts?

Posted on March 21, 2013 · Posted in Blog

If you feel like you are drowning in data and starving for information, you are a candidate for Business Intelligence (BI). The promise of BI is to turn raw data into useful information. This has become the tagline, in one form or another, for most BI solution providers.

Deciphering pages of columns and rows on traditional reports can be insightful, but often the process is more gut-feel than evidence-based decision support. Questions typically lead to more questions in an effort to understand root-cause business issues. This often leads to an overwhelming volume of information. The process may help owners and managers make intelligent business decisions, but it is not Business Intelligence, nor is it the optimal way to empower knowledge workers.

The true power of BI
In a BI environment, knowledge workers are presented with dashboard-like gauges and indicators to advise them on the “health” of performance metrics within their organizations. When indicators are within acceptable tolerances, the knowledge worker can move on to address only issues that require attention – just like the red lights on a dashboard. Here the journey begins. The knowledge worker can then “drill” into the problem area indicated by the red light indicator.

The true power of BI becomes apparent when the knowledge worker finds himself discovering answers to questions that he could not have even formulated at the outset of his own analysis.

Data warehouse – essential for BI
Like most other solutions, there is no magic to BI. Between the volumes of raw data and the dashboard is “the plumbing”. A data warehouse is just as it sounds: a place to store data for efficient and effective BI access. Think of it this way. A truck delivers raw goods into a physical warehouse. Until this raw information is “put away” for optimal retrieval, it is not very helpful to information consumers.

This raises the question: “Do I need a data warehouse to ‘do’ BI?” The purest answer is yes – or at least eventually. If you forego a data warehouse in the beginning and position BI directly on top of your transactional files, just be aware that you will most likely need to revisit this decision sometime in the future as your BI solutions evolve.

Deploying BI directly on top of an ERP can eventually grind your computing environment to a crawl as data volumes grow and applications become more complex. Consider these factors in your cost/benefit analysis when designing your enterprise information strategy and roadmap.

If you have questions or comments on this blog, please contact Dale Fisher at .