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: Hide Unused columns Hide NA columns 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 Drag position from measures to dimensions Right click and create Group