Database Answers Regatta House
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for a Customer Data Platform (for Digital Transformation)   
We would be glad to have your comments.
Joined-up Data for Marketing with IBM's Universal Behaviour Exchange
CMI and SVOC are provided by Oracle's Customer Hub.
Partner with Ensighten for their Customer Data Platform
Today (November 8th) it was announced that Salesforce integrated with Thunderhead's     Customer Engagement Hub
We recommend that you join the Customer Data Platform Institute

Conceptual Model for our Customer Data Platform
The purpose is to build a Profile of a Customer's Activities

Customer Data Platform
Architecture of our Customer Data Platform
Examples of CMI and SVOC are from Oracle's Customer Hub.

A Simplified view of Our Platform

A Single View of the Customer from Acxiom
Single Customer View
Innometrics Data Sources
An interesting perspective 'How it Works' from Innometrics

Innometrics Data Sources
Logical Data Model


Logical Data Model
Potential Partners
  • Dream Factory (Architecture)
  • Innometrics (see below - office in Regent street)
  • Oracle BI Analytics
  • Redpoint (Luton) - looks good
  • Tealium (Reading)
  • Umbel
    Here's a great Paper from David Raab dated April, 2013, about a new class of system called "the Customer Data Platform"
  • Getting Started with Self-Service
    Approach to a Customer Data Platform
    I am helping a number of Clients to undertake a digital transformation program, with a strategic commitment to be more customer centric.

    The challenge is to evolve from being a product driven, B2B business into a services and contractual business with an evolution to become a B2C business model.

    To achieve these goals, a programme has been established to drive a Customer focused CRM initiative, involving the implementation of Oracle EBS, SAP and Salesforce.

    A team consisting of internal stakeholders and SMEs is usually created and can be augmented with additional skills in CRM, Data Governance, Data Modelling and Architecture.
    I sometimes recommend 'Getting Started with Self-Service, by Gooogling for 'Self-Service a Customer Data Platform'.
    This usually starts by building a Customer Data Platform
    The UK Government has a good blog on "Building a Platform"

    Functions of a CDP include :-

  • Collect and reconcile customer data about identities, profiles, purchase history, preferences, and transactions
  • Transform and augment this data into a 360° view of the customer with context, intentions, relationships, and interactions
  • Turn data into insights, with segments, scores, forecasts and recommendations
  • Connect in real time to the customer touch-points and turn those insights into increased conversion rates and customer loyalty
  • Our Plans
    The comments on the right will help you understand
    our plans for our Customer Data Platform.

    We will be adding Data Models for
  • a 'Do-it-Yourself' Customer's Journey
  • a Single Customer View
    Features include :-
  • Cross-device Profiles
  • Customer Experience Management
  • Customer Touchpoints, including Online, offline, Mobile and Internet
  • Disparate Data Sources
  • Internet of Things
  • Omnichanel Customer Segmentation
  • Unified Customer View
    Interesting external links include :-
  • Progress Software asks What's your Plan ?
  • We have included features from :-
  • Customer Experience Management
  • Customer Journey Mapping (Basic) and (Complex).
  • Customer Lifetime Value
  • Customer Master Index
  • CRM Customer Metrics
  • Know your Customer
    Our Customer Experience Management Layer ensures a consistent User Interrface.
    Proof-of-Concept (POC)
    Priorities :-
    1) Create Reference Data
    2) Create Master Data
    3) Create Transaction Data
    4) Create Generic (Data) Platform
    Development Environment :-
    Oracle Login(dba/m3)
    Development Tools :-
    We will develop PoC Applications using Oracle with ApexSQL, IoT and reviewed against (alphabetically) :-
  • Domo
  • IBM Bluemix Garage in London
  • NetSuite
  • Salesforce
    In the Conceptual Data Model on the left We have incorporated Data Models for :-
  • Know your Customer
  • Customer Journey Mapping
  • About Us Contact Us