| OLTP System | Data Warehouse |
| Operational User | Managerial Users (Decision Makers) |
| Operational | Strategic Decision |
| Pattern – predictable | Pattern – unpredictable |
| Record transaction (e.g. student enrolment) | Analysis Basis |
| Transactional Data | Details to summary data |
| Factual Data | Relationship (insight) |