Abstract: The present invention provides a system consisting of reusable components for implementing data warehousing and business intelligence solutions. The reusable components comprise a data model component housing an exhaustive pre-built vertical and business function specific data models and key performance indicator libraries. The reusable components further comprise a MetAL component which serves as a key repository of all mappings between all standard source data systems and vertical function specific data models and KPIs used in the data model component. Being compliant with Common Warehouse Metamodel, the system is extraction and reporting tool neutral. In other words, the technical and business metadata can be exported to any of the CWM compliant extraction and reporting tools. The system further consists of an algorithm to automatically detect version changes in the standard source systems.