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 64: Line 64:
 
*Drag Position from measures to dimensions
 
*Drag Position from measures to dimensions
 
*Right click and create Group<br>
 
*Right click and create Group<br>
 +
|-
 +
 +
 +
|<center>
 +
[[File:Clean4.png|600px]]
 +
<center>
 +
|
 +
'''Data Preparation: Group'''<br>
 +
*Right click and hold shift to select groups
 +
*1-4 Undergraduate
 +
*6-7 Postgraduate
 +
*8-11 Faculty
 +
*12-13 Staff
 +
 +
<br>
 
|-
 
|-

Latest revision as of 23:39, 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

Ss1.png

Data Preparation: Hiding

  • Hide column NA1-NA26 and comment by right clicking and select hide

Clean2.png

Data Preparation: Pivot

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

Clean3.png

Data Preparation: Group

  • Go to sheets
  • Drag Position from measures to dimensions
  • Right click and create Group

Clean4.png

Data Preparation: Group

  • Right click and hold shift to select groups
  • 1-4 Undergraduate
  • 6-7 Postgraduate
  • 8-11 Faculty
  • 12-13 Staff


Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=IS428_AY2019-20T2_Assign_YIP_JIAN_MING_DataCleaning&oldid=4099’