Database Answers Clouds and Blue Sky

Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map 
Data Model for Retail Sales Platform 2020 
An Access Database is available.

Here's our End-2-End View for Retail cUstomers.

These Data Models are part of our Reference Data Architecture.

We have set up a Proof-of-Concept like this for BI on the Beach for Retail Banking.
Here are two Data Marts sharing Conformed Dimensions and a Model showing Customers and Inheritance.

Two POC Tables -    - This POC Screenshot shows that Bobby Caldwell went shopping, bought Groceries and a newspapr, met friends and went for Coffee.

KPI Retail Sales

KPI Retail Sales 		KPI Promotion-related Sales added June 15th. 2017.

KPI Promotion Sales
KPIs, Data Warehouse and Data Mart for BI

ERwin Data Mart 		Data Mart for Retail Sales

Data Mart
Our Conceptual Canonical Data Model

Conceptual Data Model 		Our Logical Canonical Data Model

ERwin Data Mart

Barry Williams
January 26th. 2017
Database Answers Ltd.
London, England

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