Some of the best practices for implementing a data warehouse:
The project must fit with corporate strategy and business objectives.
There must be complete buy-in to the project by executives, managers, and users.
It is important to manage user expectation about the completed project.
The DW must be built incrementally.
Build in adaptability.
The project must be managed by both IT and business professionals.
Develop a business/supplier relationship.
Only load data that have been cleansed and are of a quality understood by the organization.
Do not overlook training requirements.
Be politically aware.