System, method, and computer program for mapping data elements from a plurality of service-specific databases into a single multi-service data warehouse

1. A non-transitory computer readable storage medium storing computer code executable by a processor to perform a method comprising:

generating a multi-service data model having a plurality of multi-service data elements and being specific to a single multi-service data warehouse that is a central consolidated database;

identifying a plurality of service-specific data elements included in a plurality of service-specific databases;

automatically mapping the plurality of multi-service data elements in the multi-service data model to the plurality of service-specific data elements in the plurality of service-specific databases, wherein the mapping correlates each of the multi-service data elements in the plurality of multi-service data elements with one or more of the service-specific data elements in the plurality of service-specific data elements based on an association of the multi-service data element and of the one or more of the service-specific data elements with a common business category, the automatic mapping being performed by:

(a) automatically parsing the service-specific databases,

(b) based on the parsing, identifying from the service-specific databases the service-specific data elements and descriptions associated therewith,

(c) identifying descriptions of the multi-service data elements in the multi-service data model, and

(d) using the identified descriptions associated with the service-specific data elements and the identified descriptions of the multi-service data elements, mapping each of the service-specific data elements in the plurality of service-specific data elements to one of the multi-service data elements in the multi-service data model;

storing mapping rules indicative of the mapping;

storing, in the multi-service data model, transformation and translation rules for removing duplicated service-specific data elements identified from the service-specific databases;

automatically importing data from the service-specific databases into the single multi-service data warehouse, including:

identifying data elements in the service-specific databases that are associated with a billing system, a revenue management system, a customer relation management system, and an ordering management system,

applying the transformation and translation rules to the data elements for creating a single view for each of the data elements, and

storing the single view for each of the data elements in the single multi-service data warehouse according to the mapping rules.

2. The non-transitory computer readable storage medium of claim 1 , wherein the automatic mapping is performed using business logic of a telecommunication service provider.

3. The non-transitory computer readable storage medium of claim 2 , wherein the single multi-service data warehouse is provided by the telecommunication service provider.

4. The non-transitory computer readable storage medium of claim 1 , wherein the multi-service data model includes one or more of entity diagrams and relationship diagrams that are associated with a dimensional data model.

5. The non-transitory computer readable storage medium of claim 4 , wherein the dimensional data model describes transactional data and events associated with the plurality service-specific databases.

6. The non-transitory computer readable storage medium of claim 1 , wherein the multi-service data model includes one or more physical table definitions mapped to the service-specific data elements.

7. The non-transitory computer readable storage medium of claim 1 , wherein the multi-service data model includes one or more attribute sources mapped to the service-specific data elements.

8. The non-transitory computer readable storage medium of claim 1 , further comprising automatically generating one or more reports utilizing the multi-service data model.

9. The non-transitory computer readable storage medium of claim 1 , wherein the single multi-service data warehouse includes a summary data store where data is aggregated and de-normalized to address analytics associated with a business.

10. The non-transitory computer readable storage medium of claim 1 , wherein the single multi-service data warehouse includes profiles where data is kept on per customer basis as a behavior profile, the behavior profile including key performance indicators associated with the customer that are capable of being tracked, monitored, and analyzed.

11. A method, comprising:

generating a multi-service data model having a plurality of multi-service data elements and being specific to a single multi-service data warehouse that is a central consolidated database;

identifying a plurality of service-specific data elements included in a plurality of service-specific databases;

automatically mapping the plurality of multi-service data elements in the multi-service data model to the plurality of service-specific data elements in the plurality of service-specific databases, wherein the mapping correlates each of the multi-service data elements in the plurality of multi-service data elements with one or more of the service-specific data elements in the plurality of service-specific data elements based on an association of the multi-service data element and of the one or more of the service-specific data elements with a common business category, the automatic mapping being performed by:

(a) automatically parsing the service-specific databases,

(b) based on the parsing, identifying from the service-specific databases the service-specific data elements and descriptions associated therewith,

(c) identifying descriptions of the multi-service data elements in the multi-service data model, and

(d) using the identified descriptions associated with the service-specific data elements and the identified descriptions of the multi-service data elements, mapping each of the service-specific data elements in the plurality of service-specific data elements to one of the multi-service data elements in the multi-service data model;

storing mapping rules indicative of the mapping;

storing, in the multi-service data model, transformation and translation rules for removing duplicated service-specific data elements identified from the service-specific databases;

automatically importing data from the service-specific databases into the single multi-service data warehouse, including:

identifying data elements in the service-specific databases that are associated with a billing system, a revenue management system, a customer relation management system, and an ordering management system,

applying the transformation and translation rules to the data elements for creating a single view for each of the data elements, and

storing the single view for each of the data elements in the single multi-service data warehouse according to the mapping rules.

12. A system comprising:

a memory system storing computer code; and

a processor in communication with the memory system that executes the computer code to:

generate a multi-service data model having a plurality of multi-service data elements and being specific to a single multi-service data warehouse that is a central consolidated database;

identify a plurality of service-specific data elements included in a plurality of service-specific databases;

automatically map the plurality of multi-service data elements in the multi-service data model to the plurality of service-specific data elements in the plurality of service-specific databases, wherein the mapping correlates each of the multi-service data elements in the plurality of multi-service data elements with one or more of the service-specific data elements in the plurality of service-specific data elements based on an association of the multi-service data element and of the one or more of the service-specific data elements with a common business category, the automatic mapping being performed by:

(a) automatically parsing the service-specific databases,

(b) based on the parsing, identifying from the service-specific databases the service-specific data elements and descriptions associated therewith,

(c) identifying descriptions of the multi-service data elements in the multi-service data model, and

(d) using the identified descriptions associated with the service-specific data elements and the identified descriptions of the multi-service data elements, mapping each of the service-specific data elements in the plurality of service-specific data elements to one of the multi-service data elements in the multi-service data model;

store mapping rules indicative of the mapping;

store, in the multi-service data model, transformation and translation rules for removing duplicated service-specific data elements identified from the service-specific databases;

automatically importing data from the service-specific databases into the single multi-service data warehouse, including:

identifying data elements in the service-specific databases that are associated with a billing system, a revenue management system, a customer relation management system, and an ordering management system,

applying the transformation and translation rules to the data elements for creating a single view for each of the data elements, and

storing the single view for each of the data elements in the single multi-service data warehouse according to the mapping rules.

13. The method of claim 11 , wherein the method is performed by a computer system.

14. The non-transitory computer readable storage medium of claim 1 , wherein:

a first portion of the service-specific data elements are included in at least one service-specific database of the plurality of service-specific databases that is associated with the customer relationship management application, and describe a sale cycle, a buyer, a product, and an employee, and wherein the first portion of the service-specific data elements are mapped to the multi-service data elements that include sales and marketing data elements; and

a second portion of the service-specific data elements are included in at least one service-specific database of the plurality of service-specific databases that is associated with a marketing automation application, and describe promotions, leads, prospects, response rate, and marketing effort, and wherein the second portion of the service specific data elements are mapped to the multi-service data elements that include the sales and marketing data elements.