New Year, New You?

In this new year, what are your missions, visions and goals?
Kindly leave your thoughts in the COMMENTS SECTION ONLY.

Thank you.

Regards.

What's your Google Hit?

Dear Data Miners,

Kindly 'reveal' the number of hits you got from Google by leaving it in the comments section. Please do not make any new posts just to put in your "hits".

Thank you.

Regards.

Tutorial 1

Tutorial 1 - Star Schema for University Hospital Data Warehouse

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

Tutorial 1

Star schema for UH data warehouse

data warehousing and data mining

Exercise 2.3 : University Hospital Star Schema

Tutorial 1 - Star Schema for University Hospital Data Warehouse