|
This is an analytic tool used in planning the data warehouse. It is used
to identify and represent the information that is important to people with
business questions. We have broken this into the following three components:
- Conceptual model (on paper only) depicts what information you are
reporting on, and what attributes you are reporting by (e.g. time, geographic
location, etc.)
- Logical model takes the conceptual model and adds data elements, table
definitions and keys to it
- Physical model has actual data (database) and is where we build the
data warehouse using an ETL tool
|
