• Again it would depend on your data and how you want to analyse that data as to what route you need to take in your warehouse. Only you would be able to decide on that.

    There is the AdventureWorks data warehouse which you can download from Codeplex to get an idea of how that is built, but I would really recommend reading up on warehousing methodologies and then applying it to your data.