Reporting Database Considerations
I think what you're looking for is, "What are all the things I need to keep in mind when designing a data warehouse?"

There's a lot of good resources out there on it:


https://www.cu.edu/irm/stds/ddg/dzproces.html
http://www.slideshare.net/markginnebaugh/architecting-a-data-warehouse-a-case-study
http://msdn.microsoft.com/en-us/library/aa902672%28SQL.80%29.aspx