26th September 2003 - Ten Mistakes to Avoid

Today I found a nice small guide regarding "The Mistakes to Avoid When Constructing a Real-Time Data Warehouse" by Stephen Brobst of the Data Warehousing Institute.

The mistakes are:

- Focusing on "Real" time rather than "Right" time

- Confusion between bookkeeping, decision making, and action taking

- Using legacy ETL [Extract Transform Load] infrastructure

- Too much summary data

- Lack of high availability

- Failure to initiate business process changes

- Separate ODS [Operational Data Stores] deployment per channel

- Underestimating the importance of historical data

- Failure to integrate the data

- Assume all knowledge workers want real-time data

Working in an organization that has been in the business intelligence industry for almost ten years, and having implemented my own share of data warehouses, I believe that these simple pragmatic guidelines make sense. The essence is to focus on business requirements rather than requirements, thus the focus is to put the data in a data warehouse to intelligent work on all organizational levels towards and including the operational level; essentially changing the organizations ability to act according to the mantra of the article: "From Chosen Few to Common World View".

Although the top ten mistakes to avoid are based on experience with real-time, I believe that they also apply to data warehousing in a broader sense.

For those of you interested in data warehousing in general, please stop by the TARGIT website and see how at least one company in the industry seeks to aid in the ability to get the right and relevant data turned into valuable decisions throughout an organization…. ;-)

Back to journal

Updated 2003-09-26

[Home] - [CALM] - [Blog] - [Work] - [Projects] - [Profile] - [References] - [Links]

Search and Site Map are in English language only

The official homepage of Morten Middelfart and CALM. Computer Aided Leadership and Management (CALM) is an inspirational speculation on where mankind may be heading in the quest to leverage computer potentials for helping individuals and organizations to self-actualize their symbiotic potentials.

The time frame for this well-informed and provocative speculation on relatively near-term and more distant potentials is clearly within mankind's grasp. Dr. Middelfart argues persuasively that within the next one or two decades, symbiotic links with "intelligent machines" will surely leverage people's potentials, far beyond all human progress to date!

Altogether, a tour de force of well-informed contemporary insights and maturely reasoned speculation; affording possible stepping stones and a creative springboard for what may lie ahead. As has been said: "Man's reach should exceed his grasp; else what's a heaven for?”


morten middelfart, morten, middelfart, morton, doctor, dr, ph.d., author, book, calm, computer, aided, leadership, management, human, potential, energy, decision, fear, strength, weakness, business, intelligence, artificial, decision, individual, organization, computers, leaders, managers, future, targit, targit a/s, intelligent dashboard, intelligent analysis, intelligent reporting, balanced scorecard, business scorecard, data warehouse, data mart