Well it would all depend on your data, and how you want to slice and dice it.

I would recommend choosing a warehousing route, like Kimball or Inmon as various people have various ways of defining a warehouse.

Some good reading on Kimball methodology - http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/, which is the way that I have always done warehouses.