IS428 AY2019-20T2 Assign YIP JIAN MING DataCleaning

Overview

Data Cleaning

Undergraduate

Postgraduate

Faculty

Staff

Data preparation

Data Cleaning & Preparation File: Raw data 2018-03-07 SMU LCS data file – KLG.xls

Screenshot	Steps
	Data Preparation: Hiding Hide column NA1-NA26 and comment by right clicking and select hide
	Data Preparation: Pivot Select columns from I01-I26 & P01-P27 Right click and pivot
	Data Preparation: Group Go to sheets Drag Position from measures to dimensions Right click and create Group
	Data Preparation: Group Right click and hold shift to select groups 1-4 Undergraduate 6-7 Postgraduate 8-11 Faculty 12-13 Staff