It sounds as if you don't yet have a framework. I would suggest that you start with "The Data Warehouse Toolkit" by Ralph Kimball for a good overview. "The Microsoft Data Warehouse Toolkit" would be another good suggestion for a beginning overview.