IS428 AY2019-20T2 Assign TIAN. MINGZE

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search

Overview

Data preparation

We are given 2 datasets, Raw data 2018-03-07 and SMU Library Survey Comments. Unfortunately, these two given datasets are not well structured and cannot be directly used. So, I will mainly focus on data cleaning and data preparation in this section.

Raw data 2018-03-07 SMU LCS data file

There are two worksheets in this raw data. The first worksheet record all response data from all participants. The second worksheet contains all the column name (legend) for the first worksheet.

Mz3.jpg



Dashboard

Analysis & Insights

Undergraduate Students

Postgraduate Students

Faculty

Staff

Reference