Database Answers
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map 
Data Model for Agile  Oil Business   
An Access Database is available.

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.

Agile Oil Business Data Model showing Subject Area Models

Links to the Subject Area Models :-
Oil Business
  • Crude Oil Trading (In progress)
    1. Marketing Funnels
    2. Sales Lifecycle

  • Exploration & Production (In progress)
    1. Offshore Drilling Equipment
    2. Oil Companies
    3. Oil Production(In progress)
    4. Planning (In progress)

  • Financial Mgt (In progress)
    1. Financial Accounting (In progress)
    2. Management Accounting

  • Forecasting
    1. Demand Planning
    2. Management Accounting

  • HR Managment
    1. Payrolls
    2. Personnel Management (In progress)

  • Logistics & Shipments
    1. Forklift Truck Servicing
    2. Fuel Stock
    3. Oil Company Deliveries
    4. Inventory Management
    5. Transport Mgt (In progress)
    6. Vehicle Mgt (In progress) 

    Oil Business Data Platform 

    contains :-

  • Transactions (Deals,etc)

  • Master Data (Clients, etc)

  • Reference Data (Account Types,etc)

    • A Phased migration to our Agile Oil Business Approach :-
Step 1. Set-up Working Party with Sign-off approval
Step 2. Agree Functional Areas in Phases
Step 3. Design of the Enterprise Data Model
Step 4. Agree design of the Data Warehouse
Step 5. Talk to Users and agree Requirements
Step 6. Design Data Marts based on Templates
Step 7. Establish Data Governance Procedures
Step 8. Prove Step-by-Step Functionality
Step 9. Obtain Sign-off from approved Signatories

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    January 21st. 2018


    © Database Answers Ltd. 2018
    About Us Contact Us