Showcase Data Models


Printer-friendly version

Home

Careers

   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.

Specifications for Proofs-of-Concept (1) and (2) of "BI on the Beach" have been created to show how the Microsoft BI Stack is used.

Here are the current Showcase Data Models

Showcase Data Models

Nr	Industry	Industry Data Models	Dimensional Models	PW Dimensional Models	Other Material
1	Advertising	Top-Level Model	Dimensional Model	PW Dimensional Model
2	Airline Operations	Top-Level Model	Dimensional Model	PW Dimensional Model
3	Banks-Investment	Top-Level Model	Dimensional Model	PW Dimensional Model	Marketing Pack, FpML Industry Std and Data Mart for KPI 1
4	Banks - Retail	Top-Level Model	Dimensional Model	PW 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	PW Dimensional Model
6	Customers and Financial Svcs	Top-Level Model	Dimensional Model	PW Dimensional Model	CMI (Customer Master Index) and PMC (Product Master Catalogue)
7	e-Commerce	Top-Level Model	Dimensional Model	PW Dimensional Model
8	Education	Top-Level Model	Dimensional Model	PW Dimensional Model
9	Entertainment	Top-Level Model	Dimensional Model	PW Dimensional Model	Check the Clown Registry Model and the Clown Registry Data Mart
10	Hotels	Top-Level Model	Dimensional Model	PW Dimensional Model
11	Insurance	Top-Level Model	Dimensional Model	PW Dimensional Model	Claims KPI Data Mart
12	Law Enforcement	Top-Level Model	Dimensional Model	PW Dimensional Model
13	Libraries	Top-Level Model	Dimensional Model	PW Dimensional Model
14	Local Government	Top-Level Model	Dimensional Model	PW Dimensional Model	Electoral Register and MDM for Customers
15	Logistics	Top-Level Model	Dimensional Model	PW Dimensional Model
16	Master Data	Top-Level Model	Dimensional Model	PW Dimensional Model	CMI (Customer Master Index) and PMC (Product Master Catalogue)
17	Pharmaceuticals	Top-Level Model	Dimensional Model	PW Dimensional Model
18	Retail	Top-Level Model	Dimensional Model	PW Dimensional Model
19	Travel and Transport	Top-Level Model	Dimensional Model	PW Dimensional Model
20	Wine	Top-Level Model	Dimensional Model	PW Dimensional Model	Replace by comprehensive Models