Systems and Methods for Data Warehousing

A system for business process outsourcing in a cloud computing environment, including

• a data hub inbound layer configured to receive the input data from the at least one data source in a controlled and auditable manner, to perform preprocessing of the input data;
• a core layer configured to receive the input data from the data hub inbound layer, the core layer including:
• a processing engine configured to:
• apply a first model and at least one rule of a first set of rules to the input data to generate a plurality of first level interim marts comprising first data, wherein the first data is input data processed in accordance with the at least one model and the at least one rule, and the first model and the first set of rules are defined and specific for the first level interim marts,
• apply a second model and at least one rule from a second set of rules to the first data from the first level interim marts and second data from an additional source to generate second level interim marts comprising third data, wherein the third data is the first data and the second data processed in accordance with the second model and the one rule form the second set of rules, and the second model and the second set of rules are defined and specific for the second level interim marts, and
• apply a third model and at least one rule from a third set of rules to the third data from the second level interim marts to generate a plurality of data marts comprising processed data, wherein the processed data is the third data processed in accordance with the at least the third model and the at least one rule from the third set of rules, and the third model and the third set of rules defined and specific for the plurality of data marts;
• the processing engine to generate data lineage tracking from the at least one data source to the at least one computer system user, the data lineage tracking to track processing of the input data and second data through the first level interim marts, the second level interim marts, and the plurality of data marts to the at least one computer system user, the data lineage tracking to enable updating of at least one of the plurality of data marts based on changes in data;
• and
• a data hub outbound layer configured to receive data from the plurality of data mart.

A computer-implemented method for generating data marts for deployment in a cloud environment that can be accessed by system user client devices having authorization to access the cloud environment, comprising:

• receiving, by a computer-implemented data acquisition layer, the input data from the at least one data source in a controlled and auditable manner, to perform preprocessing of the input data;
• applying, by a computer-implemented platform layer, at least one model from a plurality of models and at least one rule from a plurality of rules to the input data to generate a plurality of first level interim marts comprising first data, wherein the plurality of models and the plurality of rules are stored in an at least one repository database and the first data is input data processed in accordance with the at least one model and the at least one rule defined and specific for the plurality of first level interim marts;
• applying, by a computer-implemented platform layer, at least one model from the plurality of models and at least one rule from the plurality of rules to the first data from the first level interim marts and second data from an additional source to generate second level interim marts comprising third data, wherein the third data is the first data and the second data processed in accordance with the at least one model and at least one rule defined and specific for the second level interim marts;
• applying, by a computer-implemented platform layer, at least one model of the plurality of models and at least one rule of the plurality of rules to the third data from the second level interim marts to generate a plurality of data marts comprising processed data, wherein the processed data is the third data processed in accordance with the at least one model and the at least one rule defined and specific for the plurality of data marts;
• generating, by a computer-implemented platform layer, data lineage tracking from the at least one data source to the at least one computer system user, the data lineage tracking to track processing of the input data and second data through the first level interim marts, the second level interim marts, and the plurality of data marts to the at least one computer system user, the data lineage tracking to enable updating of at least one of the plurality of data marts based on changes in data;
• and
• receiving, by an information delivery layer, the processed data from the plurality of data marts.