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
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.
We start by agreeing a Statement of Business Objectives to establish the scope of the Enterprise Data Model.
Logical Enterprise Data Model for Investment Banking
Physical Enterprise Data Model for Investment Banking
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
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 :-
KPI 1 Data Mart
Enterprise Data Model for Paragon
Database Answers Ltd.
December 15th. 2017
© Database Answers Ltd. 2017