Systems and methods for visualizing master data services information

• US 9,489,438 B2
• Filed: 02/27/2013
• Issued: 11/08/2016
• Est. Priority Date: 02/27/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Cohen, Ronen
• Primary Examiner(s): Saeed, Usmaan
• Assistant Examiner(s): Perez-Arroyo, Raquel
• Application Number:
  US13/779,106
• Publication Number:
  US 20140244673A1
• Time in Patent Office: 1,350 Days
• Field of Search: 707/756
• US Class Current: 1/1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

According to some embodiments, a processor may receive an original set of records and automatically transform the original set of records into a transformed set of records. The processor may also generate a visualization display including both a first graphical representation associated with the original set of records and a second graphical representation associated with the transformed set of records.

Claims

1. A computer implemented method, comprising:

receiving, at a computer processor of a master data services platform, an original set of records;

automatically transforming, by the computer processor of the master data services platform, the original set of records into a transformed set of records that combines multiple records referring to a single entity into a single record by identifying potential duplicates, the transforming based on determining (i) records with a highest number of populated fields or (ii) records having a most frequently occurring combination of values across fields within the multiple records and merging the identified potential duplicates records into a single best representing instance of the record; and

generating a visualization display to visualize an impact of a distribution process related to an amount of sales, an amount of profit, or a number of purchase orders in real-time, the impact based on a reduction in records, the visualization display including (i) a first graphical representation being divided into regional distribution sub-categories prior to the reduction in records and (ii) a second graphical representation being divided into the regional distribution sub-categories to illustrate a change in regional distribution based on the reduction in records while not changing the overall amount of sales, profit or purchase orders wherein the first graphical representation and the second graphical representation are each divided into sub-representations associated with customer levels and wherein a data steward'"'"'s work flow is prioritized based on an analysis of customer levels and associated sales data.

2. The method of claim 1, wherein the original set of records are received from a customer information platform.

3. The method of claim 1, wherein said transforming is further associated with a record enrichment process.

4. The method of claim 1, wherein the visualization display is updated in substantially real time.

5. The method of claim 1, wherein the first graphical representation and the second graphical representation are each divided into sub-representations associated with geographic locations.

6. The method of claim 1, wherein the first graphical representation and the second graphical representation are each divided into sub-representations associated with demographic attributes.

7. The method of claim 1, wherein the original set of records include records from a plurality of data sources.

8. The method of claim 1, wherein said generating is associated with a business user data analysis tool.

9. A non-transitory, computer-readable medium storing program code executable by a computer to:

receive, at a master data services platform, an original set of records;

automatically transform, by the master data services platform, the original set of records into a transformed set of records that combines multiple records referring to a single entity into a single record by identifying potential duplicates, the transforming based on determining (i) records with a highest number of populated fields or (ii) records having a most frequently occurring combination of values across fields within the multiple records and merging the identified potential duplicates records into a single best representing instance of the record; and

generate a visualization display to visualize an impact of a real-time reduction in records associated with a distribution process related to an amount of sales, an amount of profit, or a number of purchase orders, the visualization display including (i) a first graphical representation being divided into regional sales distribution sub-categories prior to the real-time reduction in records and (ii) a second graphical representation being divided into the regional sales distribution sub-categories to illustrate a change in regional sales distribution based on the reduction in records while not changing the overall amount of sales, profit or purchase orders wherein the first graphical representation and the second graphical representation are each divided into sub-representations associated with customer levels and wherein a data steward'"'"'s work flow is prioritized based on an analysis of customer levels and associated sales data.

10. The medium of claim 9, wherein the original set of records are received from a customer information platform.

11. The medium of claim 9, wherein said automatic transformation is associated with:

(i) a record consolidation process, and (ii) a record enrichment process.

12. The medium of claim 9, wherein the first graphical representation and the second graphical representation are each divided into sub-representations associated with at least one of:

(i) geographic locations, (ii) customer levels, and (iii) demographic attributes.

13. The medium of claim 9, wherein the original set of records include records from a plurality of data sources.

14. The medium of claim 9, wherein said generating is associated with a business user data analysis tool.

15. A system, comprising:

an original data store to provide a plurality of original records; and

a master data services platform comprising a computer processor to;

receive the original set of records;

automatically transform the original set of records into a transformed set of records that combines multiple records referring to a single entity into a single record by identifying potential duplicates, the transforming based on determining (i) records with a highest number of populated fields or (ii) records having a most frequently occurring combination of values across fields within the multiple records and merging the identified potential duplicates records into a single best representing instance of the record; and

generate a visualization display to visualize an impact of a real-time reduction in records associated with a distribution process related to an amount of sales, an amount of profit, or a number of purchase orders, the visualization display including (i) a first graphical representation being divided into regional sales distribution sub-categories prior to the real-time reduction in records and (ii) a second graphical representation being divided into the regional sales distribution sub-categories to illustrate a change in regional sales distribution based on the reduction in records while not changing the overall amount of sales, profit or purchase orders wherein the first graphical representation and the second graphical representation are each divided into sub-representations associated with customer levels and wherein a data stewards work flow is prioritized based on an analysis of customer levels and associated sales data.

16. The system of claim 15, wherein said automatic transformation is associated with at least one of:

(i) a record consolidation process, and (ii) a record enrichment process.

17. The system of claim 15, wherein the original data store is associated with a customer information platform.

18. The system of claim 15, further comprising:

a business user data analysis tool, wherein said generating including transmitting information from the master data services platform to the business user data analysis tool.