 |
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
|
Printer-friendly version