Please enable JavaScript.
Coggle requires JavaScript to display documents.
DWH- Week 4, Retail Store - Case Study, Dimensional Model, Data Modeling…
-
-
Dimensional Model
Elements
Facts or Measures
-
Sales Number, Budgets, Profit.
Business Item, A business Transaction.
-
-
-
Dimensions
-
Answer queries such as, who, what, where and when of a fact.
-
Modeling Steps
- Select The Business Process (Subject)
- Identify Dimensions.
- Identify data results from business processes, descriptions or context of each measurement.
- Identify Facts and Measurements.
- What are the numeric units
- Build The Dimensional Model
- Star Schema
- Snowflake Schema
- Determine Granularity or Grains:
- What a row in the fact table exactly represents
- Grain is the level of detail in fact table measurements.
-
Data Modeling Techniques
Entity Relational
Entities, Attributes, and Relationships Between Them
-
Dimensional
Measures, Facts and Dimensions
-