Database Answers Wall Street Road Sign
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Enterprise Data Model for Investment Banks   
An Access Database is available on demand.

The Specifications have been derived from our consulting assignments at Credit Suisse and other Investment Banks.

We would be glad to have your comments.

Here is the Marketing Pack.

If you are new to Data Models, this page of one of this 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.

There is also a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.

Teradata offers a Financial Services Logical Model, and IBM offers a Banking Data Warehouse.


Logical Enterprise Data Model for Investment Banking

Physical Enterprise Data Model for Investment Banking

We start by agreeing a Statement of Business Objectives to establish the scope of the Enterprise Data Model.

Once we have agreed the Statement of Business Objectives we can create a draft Top-Level Model with associated Subject Areas, each of which is shown in its own Model.

This is an example of a Statement of Business Objectives for an Investment Bank :-
"Our Business objectives are to offer a range of Services to Clients, which can be either organizations or High-Net-Worth Individuals.
These Services will involve completing Deals for our Clients in which our Staff will participate with the purpose of achieving acceptable returns on investment.
Brokers may participate in these Deals, which will all be completed by Settlements.
Deals may involve multiple Currencies and incur subsequent Transactions, such as adjustments.

The Enterprise Data Model will establish the data available for a Data Warehouse to meet Business Intelligence requirements."

We have also created Data Models for these Subject Areas :-
  • Accounts
  • Customers
  • Deals
  • Settlements
  • Staff
  • Data Mart
  • KPI 1 Data Mart
  • Enterprise Data Model for Paragon

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    December 15th. 2017


  • © Database Answers Ltd. 2017
    About Us Contact Us