Objective assessment whether Data Warehouse is successful or not
1. Executive Sponsor
2. Tool
3. Data quality / Business rule
4. Performance
5. Support / Training
6. ROI

1. Executive Sponsor
At the heart of the data warehouse is the executive sponsor. This is the person who believes in the value of the warehouse and is willing to use his/her political clout to fund the project. The executive sponsor is the one individual that must clearly understand the ROI of the project and be able to articulate to his/her peers.
The important note is that the executive should be an active member of the data warehouse project from concept through implementation. It is very difficult to progress through the politics of the project if the sponsor’s only involvement is to supply funding and receive monthly status reports.

2. Tool
The first decisions to be made are the categories of tools (extract, transform and load, data cleansing, OLAP, ROLAP, data modeling, administration, etc.). Many of these tools are expensive, not just for their initial costs and maintenance costs, but in training, consulting and in terms of the internal people required to implement and support the tool. The tools must match the requirements of the organization, the users and the project. The tools must work together without the need to build interfaces or write special code.

3. Business rule
According to Ronald G. Ross, business rule are literally what you use to run your business. Business rules are what guide your business in running its day-to-day operations. Without business rules, you would always have to make decisions on the fly.
Equally important as the executive sponsor is the organization of the project team. Although the project team is made up of resources from the business and technical side of the house, for the purposes of the project, they cannot report up separate