A long and lonely road which leads to Data Warehouse. Here is a nice article discusses in depth about its need and how to.
Who in the World Needs a Data Warehouse?
Who in the World Needs a Data Warehouse?
Data Integration, Trends and Innovation