These are Investment Banking Data Models that we have created based on our experience at Credit Suisse and other Banks. Accounts A key building-block. Brokers Including Addresses and Contacts. Customers Including Addresses and Facilities. Deals - General A starting-point for Deals in general. Deals - FX Shows details of FX Deals. Deals - Simple & Open-Ended Shows a simple starting-point which is open-ended. Financial Instruments Financial instruments can be either cash instruments or derivative instruments. Financial Services Authority The FSA regulates Banks and Financial Institutions. Global Custody Involves processing cross-border securities trades, keeping financial assets safe and servicing portfolios. Settlements Involves settling Trades. Staff Dealers, Traders and more. Transactions Tracking Share Transactions Data Warehouse / Marts Models ... Data Warehouse (1) Before Facilitated Workshop. Data Warehouse (2) After Facilitated Workshop. Discussion with Users identified that analysis by Trader was required. Therefore Trader replaced a Dimension. Similarly for Currencies. Data Warehouse (3) After all Facilitated Workshop. This Final Version includes all the data that will meet the business requirements. Federated Data Marts   Third-party Data Models ... IBM Banking Data Warehouse This is a useful reference.