End-2-End Data Models for Asset Management

End-2-End Data Models for Asset Management
Back to the Home Page

Step 8 - Define the KPI Tables

Step 7 - Define the Data Mart Model
This is typically used to store KPI Data.

Step 6 - Define POC Tables
Our Asset Management Service is primarily planned for Utilities including
Electricity, Gas, Water and Transport, such as Airport, and Rail.

Step 5 - Generate the Asset Register Physical Data Model

Physical Data Model for Asset Management

Step 4 - Asset Register Logical Data Model
Corresponding Tables

Getting Started Conceptual Data Model for Asset Management

Step 3 - Define the Asset Register Conceptual Business Data Model

Step 2 - Define Sample Data
A. Asset Hierarchy :-
1. Category, eg Domestic
2. Supertype, eg Cutlery
3. Type, eg Spoon

B. Lifecycle Phases :-
These can be common to all types of Assets and typically include :-
1. Acquire
2. Use
3. Maintain
4. Dispose

C. Status :-
1. Needs Maintenance
2. OK
3. Ready for Disposal

Step 1 - Start with our Canonical Data Model