Several years ago, my consulting company embarked on a project to create a relatively low budget, short implementation time data warehouse. Not to keep you in suspense; we managed to pull it off. In fact, as the product we created enters its fifth year online, it continues to be among the most valuable tools we have produced for any of our clients. In the process we came up a few tips and techniques we thought worth sharing.
A data warehouse is a repository for data, whether legacy or active, that is created to consolidate informa