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
Notice
Upgrade your MAC ID password today
McMaster is strengthening its password system and all MAC ID passwords established before February 19, 2013 must be changed.
- Upgrade before
May 29, 2013
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 Catalogue: | |
| http://www.mcmaster.ca/uts | |
Service Bulletins
- There are no Service Bulletins at this time