The
warehouse is rolled out successfully, but soon runs into several
difficulties:
- Adding additional data sources takes too long, and
turnaround time is not acceptable to users.
- Data load times are excessive, threatening BI
organizations ability to meet negotiated Service Level
Agreement (SLA).
- Data quality erodes, impacting ability to trust data
for business decisions.
- Ad hoc query and report execution performance
degrades.
Your
customers are frustrated, and you demand answers:
- Your
network and internet consultants recommend additional web
servers and bandwidth. It helps a bit, but not much.
- Your
application architecture consultants recommend a more powerful
database software, or at the very least additional database
servers. It barely helps at all.
- Your
application vendor brings in performance gurus to reinstall the
latest upgrades and patches. More pain, no gain.
Why does this problem persist?
The Devil’s in the Data:
The
critical success factor for high functioning Business
Intelligence and Data Warehousing functions is not software or
hardware, though these obviously matter.
Still more important is
architecting the data, applications, business processes and
organizational structure to support business goals.
The
most often neglected critical factor for a Business Intelligence
platform is aligning disparate data sources into a structure
which supports the current reporting and analytical needs of the
organization, and future scalability. This entails:
The Problem
