Difference between revisions of "IS428 AY2019-20T2 Assign YIP JIAN MING DataCleaning"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 53: Line 53:
  
 
*Right click and pivot<br>
 
*Right click and pivot<br>
−
|-
+
 
−
|<center>
+
[[File:Clean2.png|600px]]
 +
<center>
 +
|
 +
'''Data Preparation: Group'''<br>
 +
*Drag position from measures to dimensions
 +
*Right click and create Group<br>

Revision as of 23:27, 15 March 2020


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

Clean1.png

Data Preparation: Hide Unused columns

  • Hide NA columns and comment by right clicking and select hide

Clean2.png

Data Preparation: Pivot

  • Select columns from I01-I26 & P01-P27
  • Right click and pivot

Clean2.png

Data Preparation: Group

  • Drag position from measures to dimensions
  • Right click and create Group
Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=IS428_AY2019-20T2_Assign_YIP_JIAN_MING_DataCleaning&oldid=4016’