What is the grain of the data that we will look for? 2. What are the dimensions?
Question:
What is the grain of the data that we will look for?
2. What are the dimensions? What type of dimensions are there?
3. What are the facts?
2 Define conceptual and logical data model to inform design
Now that you have identified the dimensions and facts important to your service line manager, you need to
begin translating this into a model that would be suited for an analytic database. Here are the steps we will
follow2:
1) High-level model with granularity. A good place to start is to create a conceptual data model. It can be a
simple bubble chart or an ERD with simple
2) Detailed design with table-by-table attributes.3 You should include use surrogate keys, define primary
and foreign keys and identify logical relationships through expression of cardinality.
3) Validate the deign with IT and Business stakeholders
4) Finalize the design
Part II-
since you defined the grain in Part 1, use the high-level conceptual framework approach and develop the
simple conceptual model for a Star Schema below.
See below for our design session results! You can use these for Part II
- What is the grain of the data that we will look for?
- Individual record/order
- What are the dimensions? What type of dimensions are there?
- Date
- Country
- Supplier
- Order
- What are the facts?
- Average No. of Orders by Country
- Average No. of Orders by Supplier
- Average amount of orders by country
- Average amount of orders by Supplier
- All of these facts should distinguishable by date ranges (year, month, week, specific day, quarter)
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts