Implementing retail customer analytics data model in a distributed computing environment

• US 10,467,636 B2
• Filed: 03/23/2016
• Issued: 11/05/2019
• Est. Priority Date: 04/01/2015
• Status: Active Grant

• Current Assignee: TATA Consultancy Services Limited (Tata Sons Pvt Ltd.)
• Original Assignee: TATA Consultancy Services Limited (Tata Sons Pvt Ltd.)
• Inventors: Gopal, Radhakrishnan, Santhanam, Janardhan, Muralidharn, Sunitha Mayelil
• Primary Examiner(s): Waesco, Joseph M
• Application Number:
  US15/078,774
• Publication Number:
  US 20160292700A1
• Time in Patent Office: 1,322 Days
• Field of Search: None
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data

Abstract

The disclosure relates generally to managing data of a customer in a distributed computing environment and more particularly to a system and a method for implementing retail customer analytics data model in a distributed computing environment. Customer data, transaction data, and interaction data of a customer in a form of facts and dimensions is received from a plurality of sources. A relationship in the customer data is identified by checking the facts and the dimensions in the plurality of sources. Based on the relationship, a unified customer profile is created. Further, a customer identity is generated by performing an identity matching on the unified customer profile. The transaction data received from the plurality of sources is merged to create a unified transaction model. Subsequently, the customer identity is linked with the unified transaction model and the interaction data to generate a plurality of customer analytics records. Further, the plurality of customer analytics records are analyzed to obtain the behavior of the customer.

Claims

1. A method for implementing retail customer analytics data model in a distributed computing environment, the method comprising:

receiving, by a processor, data of a customer from a plurality of sources;

wherein the data comprises customer data, transaction data, and interaction data, wherein the customer data, the transaction data, and the interaction data are received in a form of facts and dimensions, and wherein a source of the plurality of sources comprises a plurality of channels facilitating the customer to perform one or more actions, wherein the transaction data corresponds to a plurality of purchasing patterns;

identifying, by the processor, a relationship in the customer data by checking the facts and the dimensions in the plurality of sources;

performing, by the processor, re-formatting and standardization of the data received, when the data received is in a structured format;

performing, by the processor, cleansing and formatting the data received by applying transformation rules, when the data received is in a unstructured format;

discarding, by the processor, the data received, when the data received is incomplete data, wherein incomplete data is identified by performing at least one of error checking, exception handling and a recovery of the data received;

creating, by the processor, a unified customer profile for the customer based on the relationship identified;

applying, by the processor, at least one of said unified customer profile, transaction data, and interaction data to a universal staging area;

generating, by the processor, a customer identity by performing an identity matching on the unified customer profile;

merging, by the processor, the transaction data received from the plurality of sources to create a unified transaction model, wherein the facts and the dimensions of the transaction data received from the plurality of sources are aggregated and the dimensions are flattened with the facts to create the unified transaction model;

linking, by the processor, the customer identity with the unified transaction model and the interaction data to generate a plurality of customer analytics records, wherein a customer analytics record of the plurality of customer analytics records represents an action performed by the customer in a channel of the plurality of channels, wherein the customer analytics record comprises data indicating a metric related to a behavior of the customer; and

analyzing, by the processor, the plurality of customer analytics records to obtain the behavior of the customer.

2. The method of claim 1, wherein the customer data comprises a plurality of attributes related to the customer, wherein the plurality of attributes comprise at least one of demographic, sociographic, and psychographic.

3. The method of claim 2, wherein the relationship is identified by matching at least one attribute from a source to another source in the plurality of sources.

4. The method of claim 1, wherein the customer data comprises data corresponding to customer details, customer profile information, and customer enrichment data, wherein the customer details are collected from sources comprising Loyalty, CRM, and web and mobile applications based on a registration by the customer, wherein the customer profile information is obtained from social media data sources, and wherein the customer enrichment data is received from a plurality of third party sources.

5. The method of claim 1, wherein the transaction data comprises data from a plurality of channels, comprising Point of Sale (PoS), e-commerce and mobile applications.

6. The method of claim 1, wherein the interaction data comprises data from call center logs, emails, blogs and external social media sources.

7. The method for claim 1, further comprising querying the customer analytics records for retrieving the behavior based on the analysis.

8. A system for implementing retail customer analytics data model in a distributed computing environment, the system comprising:

a memory; and

a processor coupled to the memory, wherein the processor executes program instructions stored in the memory, to;

receive data of a customer from a plurality of sources;

wherein the data comprises customer data, transaction data, and interaction data, wherein the customer data, the transaction data, and the interaction data are received in a form of facts and dimensions, and wherein a source of the plurality of sources comprises a plurality of channels facilitating the customer to perform one or more actions, wherein the transaction data corresponds to a plurality of purchasing patterns;

identify a relationship in the customer data by checking the facts and the dimensions in the plurality of sources;

performing re-formatting and standardization of the data received, when the data received is in a structured format;

performing cleansing and formatting the data received by applying transformation rules, when the data received is in a unstructured format;

discarding the data received, when the data received is incomplete data, wherein incomplete data is identified by performing at least one of error checking, exception handling and a recovery of the data received;

create a unified customer profile for the customer based on the relationship identified;

apply at least one of said unified customer profile, transaction data, and interaction data to a universal staging area;

generate a customer identity by performing an identity matching on the unified customer profile;

merge the transaction data received from the plurality of sources to create a unified transaction model, wherein the facts and the dimensions of the transaction data received from the plurality of sources are aggregated and the dimensions are flattened with the facts to create the unified transaction model;

link the customer identity with the unified transaction model and the interaction data to generate a plurality of customer analytics records, wherein a customer analytics record of the plurality of customer analytics records represents an action performed by the customer in a channel of the plurality of channels, wherein the customer analytics record comprises data indicating a metric related to a behavior of the customer; and

analyze the plurality of customer analytics records to obtain the behavior of the customer.

9. The system of claim 8, wherein the customer data comprises a plurality of attributes related to the customer, wherein the plurality of attributes comprise at least one of demographic, sociographic, and psychographic.

10. The system of claim 9, wherein the relationship is identified by matching at least one attribute from a source to another source in the plurality of sources.

11. The system of claim 8, wherein the processor executes the program instructions to query the customer analytics records for retrieving the behavior based on the analysis.

12. A non-transitory computer readable medium embodying a program executable in a computing device for implementing retail customer analytics data model in a distributed computing environment, the program comprising:

a program code for receiving customer data, transaction data, and interaction data of a customer from a plurality of sources, wherein the customer data, the transaction data, and the interaction data are received in a form of facts and dimensions, and wherein a source of the plurality of sources comprises a plurality of channels facilitating the customer to perform one or more actions wherein the transaction data corresponds to a plurality of purchasing patterns;

a program code for identifying a relationship in the customer data by checking the facts and the dimensions in the plurality of sources;

a program code for performing re-formatting and standardization of the data received, when the data received is in a structured format;

a program code for performing cleansing and formatting the data received by applying transformation rules, when the data received is in a unstructured format;

a program code for discarding the data received, when the data received is incomplete data, wherein incomplete data is identified by performing at least one of error checking, exception handling and a recovery of the data received;

a program code for creating a unified customer profile for the customer based on the relationship identified;

a program code for applying at least one of said unified customer profile, transaction data, and interaction data to a universal staging area;

a program code for generating a customer identity by performing an identity matching on the unified customer profile;

a program code for merging the transaction data received from the plurality of sources to create a unified transaction model, wherein the facts and the dimensions of the transaction data received from the plurality of sources are aggregated and the dimensions are flattened with the facts to create the unified transaction model;

a program code for linking the customer identity with the unified transaction model and the interaction data to generate a plurality of customer analytics records, wherein a customer analytics record of the plurality of customer analytics records represents an action performed by the customer in a channel of the plurality of channels, wherein the customer analytics record comprises data indicating a metric related to a behavior of the customer; and

a program code for analyzing the plurality of customer analytics records to obtain the behavior of the customer.