Print Version of Showcase Data Models

Home

Ask a Question

Best Practice

Careers

Data Models

Site Map

   Back to the Showcase Models page

   This page shows Industry Data Models for Banks, Insurance Companies, Local Government and Retailers, prepared at the request of
   Microsoft (and shown in bold).
   We have added some more Models to bring the total up to twenty, and a Generic Model is also available.

Here are the current Showcase Data Models

Showcase Data Models

Nr	Industry	Industry Data Models		Other Models and Material
1	Advertising	Top-Level Model	Dimensional Model	Review the Dimensional Model
2	Air Transport	Top-Level Model	Dimensional Model
3	Banks-Investment	Top-Level Model	Dimensional Model	Marketing Pack, FpML Industry Std.	Data Mart for KPI 1
4	Banks - Retail	Top-Level Model	Dimensional Model	Data Marts with Conformed Dimensions	Slide Shows for the Dimensional Model and the Logical Data Model
5	Commercial Properties	Top-Level Model	Dimensional Model
6	Customers and Financial Svcs	Top-Level Model	Dimensional Model	CMI (Customer Master Index)	PMC (Product Master Catalogue)
7	e-Commerce	Top-Level Model	Dimensional Model
8	Education	Top-Level Model	Dimensional Model
9	Entertainment	Top-Level Model	Dimensional Model	Check the Clown Registry Model	And the Clown Registry Data Mart
10	Hotels	Top-Level Model	Dimensional Model	Revenue Data Mart	KPI Data Mart - Revenue per available Room
11	Insurance	Top-Level Model	Dimensional Model	Claims Dimensional Model	Claims KPI Data Mart
12	Law Enforcement	Top-Level Model	Dimensional Model
13	Libraries	Top-Level Model	Dimensional Model
14	Local Government	Top-Level Model	Dimensional Model	MDM Customers	Electoral Register
15	Logistics	Top-Level Model	Dimensional Model	Review both Models
16	Master Data	Top-Level Model	Dimensional Model	CMI (Customer Master Index)	PMC (Product Master Catalogue)
17	Pharmaceuticals	Top-Level Model	Dimensional Model
18	Retail	Top-Level Model	Dimensional Model
19	Travel and Transport	Top-Level Model	Dimensional Model
20	Wine Lists	Top-Level Model	Dimensional Model		Replace by comprehensive Models