That's a wide open area. Is something like this what you're looking for? It's the start of a series

http://www.sqlservercentral.com/articles/Data+Warehouse/72757/