 |
|
Printer-friendly version
|
|
|
 |
An Access Database is available on demand.
The Specifications are derived from our consulting assignments in Travel, Transport and Logistics. We would be glad to have your comments. If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model. This is a Top-Level Model which shows only the Subject Areas, each of which is shown in its own Model. We have also designed a Dimensional Model for Airline Operations, which is very useful for providing data for Reports and Business Intelligence. And an Azure Demo |
|
Click here to see the Slide-Show for this Scenario.
User Scenario This is the final step in this Scenario which is an Alert call to the CEO's Smartphone on the Golf Course 
|
| KPI Data
Table to support KPIs for Flight Intervals for POC 
|
|
POC Data Mart This Data Mart holds only the data for our POC (Proof-of-Concept) 
|
POC Airport Management Platform (Layers)
|
|
Data Mart (Dimensional) Model (on this page) 
|
|
Basic Data Mart 
|
Logical Data Model for comprehensive Data Warehouse
 |
Proof-of-Concept Data Warehouse
|
Conceptual version of Our Canonical Data Model
|
|
Our Participants ERwin Canonical Data Model
This is a little different from the Conceptual version 
|
We have also created Data Models for these Subject Areas :-
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 24th. 2017