Data Model for Turtle Conservancy
Back to the Home Page

Step 1 - Start with our Canonical Data Model

Canonical Data Model
Step 2 - Modify it for Turtle Conservancy
to create a Conceptual Data Model.

Conceptual Data Model
Step 3 - Create a Logical Data Model
to generate a physical Database.

Logical Data Model
Step 4 - Finally, create a Dimensional Model
to generate Reports.

Dimensional Data Model


Step 5 - First we set up the KPIs ...
For example, a 20% increase in Sales...

Cellphone ECG Monitor
Step 6 - When a "spike" is recognised ...

Cellphone ECG Monitor
Step 7  - An Alert is triggered ...

Phone Alarm
Step 8 - And a message is sent to
the CEO's Smartphone

BI on a Golf Course for an Airport-in-a-Box


Barry Williams

© Database Answers Ltd. 2017