Dimensional Modeling
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
Service Desk
| Hours: | Monday - Friday 8:30 am - 4:30 pm |
|---|---|
| Phone: | 905-525-9140 x24357 (2HELP) |
| Email: | uts@mcmaster.ca |
| Location: | Main Campus BSB Rm. 245 |
| Service Catalog: | |
| http://www.mcmaster.ca/uts | |
Service Bulletins
- There are no Service Bulletins at this time