Task:
Complete a rough design for the Data Warehousing situation described below. In your design, which can be displayed graphically or textually, include 1) contents of fact table – with grain size, and primary key and facts, 2) contents of dimension tables, with primary key, attributes – and what one record corresponds to.
Unfortunately, they have not already created an Enterprise Data Warehouse Bus Matrix (but you can skip that step too – only worry about the one particular business process for now).
Situation:
The StateCapital Credit Card Company is developing a dimensional model centered around the customer charging portion of its operations. It is interested in facilitating its management’s ability to get answers that might aid it increase use of StateCapital Visa Card. This could involve reaching new customers and/or increasing the use by existing customers.