If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

This diagram shows the two important Data Layers of Business Intelligence and Operational Data.
Another diagram shows the Data Layers and some representative Entities in the Operational Data Layer.

Here’s the Apex specs the POC Conceptual Model BI on the Beach for Retail Customers and an End-2-End View

Apex Specs

Canonical Data MOdel

This table shows how the Entities in the Canonical Data Model map onto the Canonical Model for Retail Customers.
Note that we have combined Roles with Organisations and People for simplicity.
This follows the design of our POC Cloud Reference Data Architecture.

Nr. Canonical Data Model Retail Customers
1 Assets Stores
2 Documents Invoices, Sales Receipts
3 Events Customer Purchase, Print Sales Receipt
4 Locations Stores
5 Organisations Suppliers
6 People Customers, Staff
7 Products / Services Products
8 Suppliers Suppliers
POC Conceptual Model for Retail Customers


Retail Sales XML Demo for Notre Dame

IBM offers a Retail Data Warehouse.
Oracle also offers a Generic Retail Model, which is compliant with the US Association for Retail technology Standards (‘ARTS’) Industry-standard Model.

Top Level Data Layers for Retail Customers
Newsletter