Tutorial 1: Exercise 2.3

Name: Siti Amiha Ayu Binti Amir Biba
Matric No.: WGA 060007
Data Warehousing & Data Mining
WMGA 6317
Tutorial 1: Exercise 2.3 (Page 32)

Measure assumptions:

Scenario analysis: Analysis the revenue, the number of patients and visit occurs on a monthly basis in University Hospital.


The Dimensions:

Time Dimension
Attributes: Year, Month & Day.

Doctor Dimension
Attributes:
Staff ID – unique number in identifying the staff (doctor).
Staff Name – staff’s full name.
Department – Information on the staff’s department. (E.g.: Orthopedics / Emergency / Maternity)
Field – Information on staff’s specialization.

Patient Dimension
Attributes:
Patient ID – unique number in identifying the patient.
Patient Name – Patient’s full name.
Address – Patient’s contact address.
Telephone No. – Patient’s contact number.
Gender – Patients gender.
Age – Patient’s age.
Illness – Detailed information on patient’s medical information.
Remarks – Extra information on patients treatment / specified doctor in charge / allergy