Database Answers Customer Analytics Dashboard (click for ScienceLogic Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
The Customer Analytics Page 

This diagram shows the three Steps in creating new Client-specific Data Models to meet Business Requirements.
Customer Analytics - Meeting Business Requirements

Barry maintains the Database Answers Web Site which offers over 50 Customer-related Data Models, including these for CRM :-
  • CRM
  • CRM Marketing_data, including Loyalty Schemes
  • CRM Metrics, including Loyalty

    Here is a selection of Customer-related Enterprise Models from his Web Site ...
    1. Enterprise Data Model for Retail
    2. Enterprise Data Model for Retail and TK Maxx (with permission)
    3. Alternative Enterprise Data Model (Version 2)
    4. Alternative Enterprise Data Model (Version 3)
    5. Alternative Events-Oriented Enterprise Data Model (Version 4)
    6. Conceptual Data Model
    7. Generic Retail Model
    8. Retail Customers Data Layers and Entities
    9. Here’s a Generic Data Warehouse in ERwin
    10. Here’s a Generic Data Mart in ERwin
    11. Retail Model – ARTS - compatible
    12. Canonical Model and Arts
    13. The ARTS Data Model (a Macro View on the Database Answers Web Site)
    14. The ARTS Data Model (a description on the ARTS Web Site)

    and Dimensional Models (Data Marts)
    1. Generic Retail Data Warehouse
    2. Retail Customers Data Mart
    3. Retail Dimensional Model
    4. Alternative Retail Customer Data Model
    5. The ARTS Data Warehouse Model (a description on the ARTS Web Site)
    The Customer Experience
    A valuable approach is to look at the world through the Customer's eyes.
    We have a Model for 'My Life' and My Work
    In addition, we have created this one for Customer Experience Management

    Engaging with the Business
    An important activity is to adapt the Data Foundation to meet the requirements of a new Client.
    This tailoring will involve meeting with business users to clarify their requirements and tailoring the Data Foundation accordingly.
    This might involve one on one Interviews and running Facilitated Workshops in order to achieve consensus.
    Planning timetables will have to allow for these procedures which can be lengthy. 
    Getting everybody on the same page  ("Conflict Resolution")
    Some activities, such as agreeing what is in scope, require consensus among a group of people who might have different objectives 
    and priorities.
    There are three techniques that can prove useful to achieve consensus :-
    1)	Create a friendly relationship with any individual who is one of a few objectors.
    	However, this technique may not survive the first serious meeting !!!
    2)	Adopt a ‘pincer movement’ and say ‘Jim, 19 other people are happy with the proposal, it is difficult to defend your position’.
    3)	Bring in senior management if appropriate.

    Barry Williams
    Principal Consultant
    June 19th. 2013
    Database Answers Ltd.
    London, England

  • Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map

    © 2010