Lessons Learned from Poor Data Warehouse Design
July 10, 2009[From SQL Server Magazine]
When designing a data warehouse, its important to consider the business and design factors associated with the project, first. This article walks you through the business considerations and data warehouse design best practices you should keep in mind when designing and creating a SQL Server data warehouse. And dont forget to get buy-in from both the top-level executives and the business usersthe last thing you want to do is build a data warehouse that doesnt meet your users needs.
The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=102119