Data Model for the Motor Trade


Printer-friendly version

Careers

Data Model for the Motor Trade

An Access Database is available.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
There might also be a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.

Click here for a top to bottom view of BI Data.

1) Here is a Framework for Digital Initiatives
It provides a vehicle for communication between Business Users and the Data Community.

2) This is the Conceptual Model

We have Subject Area Models for :-

3) This is the Master Data Conceptual Model for Customers and Vehicles.
The Cross Reference Tables match Brand-specific IDs to Master IDs.

ERD Data Model

4) This is the Entity-Relationship Diagram (showing Key fields)
It corresponds to the Conceptual Model shown at Item 2 above.

ERD Data Model

5) Getting Started
5.1 Establish a Steering Group
5.2 Review the Framework for Digital Initiatives
5.3 Determine the Priorities -

Data Dictionary

Data Governance

Data Stewards
5.4 Agree the scope of the Conceptual Model

Master Data