Lessons Learned from Poor Data Warehouse Design

When designing a data warehouse, it’s 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 don’t forget to get buy-in from both the top-level executives and the business users—the last thing you want to do is build a data warehouse that doesn’t meet your users’ needs.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=102119