Difference between revisions of "ANLY482 AY2016-17 T2 Group09: Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
 
(8 intermediate revisions by 3 users not shown)
Line 34: Line 34:
 
<font size =3 face=Georgia >
 
<font size =3 face=Georgia >
  
Li Ka Shing (LKS) Library is the first library of Singapore Management University, officially opened on 24 February 2006. The Library is named after Hong Kong businessman Dr. Li Ka-shing, and the Li Ka Shing Foundation donated and endowment to the library for collections. The main objective of the library is to offer an interactive study and research space for SMU community.
+
Li Ka Shing Library (LKSLIB) is the first library of Singapore Management University, officially opened on 24 February 2006. The Library is named after Hong Kong businessman Dr. Li Ka-shing, and the Li Ka Shing Foundation donated and endowment to the library for collections. The main objective of the library is to offer an interactive study and research space for SMU community.
  
The LKS library includes four floors that comprise about 8,800 square meters with 1,800 seats. Inside the library, there are a variety of spaces including open spaces for individual and collaborative use, learning commons which opens 24/7, quiet areas that for individuals to focus on their work, project rooms with LCD panels, investment studio, postgraduate lounges etc. As a modern library, it is also well equipped with high-speed wireless network, color printers, scanners, public computers with professional financial software available, up-to-date newspapers and magazines, collections of lifestyle videos and games, and this is also the reason why LKS library is so attractive for SMU community.  
+
The LKSLIB includes four floors that comprise about 8,800 square meters with 1,800 seats. Inside the library, there are a variety of spaces including open spaces for individual and collaborative use, learning commons which opens 24/7, quiet areas that for individuals to focus on their work, project rooms with LCD panels, investment studio, postgraduate lounges etc. As a modern library, it is also well equipped with high-speed wireless network, color printers, scanners, public computers with professional financial software available, up-to-date newspapers and magazines, collections of lifestyle videos and games, and this is also the reason why LKSLIB is so attractive for SMU community.
  
 
</font>
 
</font>
 
</div>
 
</div>
 
  
 
==<div style="background: #000033; padding: 13px; font-weight: bold; text-align:center; line-height: 0.3em; text-indent: 20px;font-size:26px; font-family:Book Antiqua"><font color= #ffffff>Project Background</font></div>==
 
==<div style="background: #000033; padding: 13px; font-weight: bold; text-align:center; line-height: 0.3em; text-indent: 20px;font-size:26px; font-family:Book Antiqua"><font color= #ffffff>Project Background</font></div>==
Line 46: Line 45:
 
<font size =3 face=Georgia >
 
<font size =3 face=Georgia >
  
In our project, our focus is on analyzing the library entry information from the card reader logs. The card readers are located at the entrance of the library, both located at the main entrance of LKSLIB and at the linkbridge side entrance, and students need to tap their card whenever they enter the library. This provides us with the entry information, which includes timestamp and basic information about the student. To better understand the library usage, the library management team is interested to know whether we could find a pattern about the usage of library for a particular user group (e.g. Information Systems undergraduate, Year 2), and if any business insights could be drawn from the data. We will also work on developing a web application with interactive dashboard using R to visualise the insights of the LKS Library entry data.
+
In our project, our focus is on analyzing the library entry information from the card reader logs. The card readers are located at the entrance of the library gantries, both located at the main entrance of LKSLIB and at the linkbridge side entrance. Students need to tap their card whenever they enter the library. This provides us with the entry information, which includes timestamp and basic information about the student. To better understand the library usage, the library management team is interested to know whether we could find any usage pattern for library of a particular user group (e.g. Dean’s List student), and see if any other business insights could be drawn from the data. We will also work on statistical analysis in order to confirm on our insights.
 +
 
 +
We use R to build a web application to clean the raw data and use Tableau to do data visualization to compare the usage level for dean’s list and non-dean’s list students, Singaporean students and international students. Then, we will do one-way ANOVA confirmative analysis using SAS JMP.
  
 
</font>
 
</font>
 
</div>
 
</div>
  
==<div style="background: #000033; padding: 13px; font-weight: bold; text-align:center; line-height: 0.3em; text-indent: 20px;font-size:26px; font-family:Book Antiqua"><font color= #ffffff>Motivations</font></div>==
+
==<div style="background: #000033; padding: 13px; font-weight: bold; text-align:center; line-height: 0.3em; text-indent: 20px;font-size:26px; font-family:Book Antiqua"><font color= #ffffff>Motivation</font></div>==
 
<div style="margin:20px; padding: 10px; background: #ffffff; font-family: Trebuchet MS, sans-serif; font-size: 95%;-webkit-border-radius: 15px;-webkit-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96); -moz-box-shadow:    7px 4px 14px rgba(176, 155, 121, 0.96);box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);">
 
<div style="margin:20px; padding: 10px; background: #ffffff; font-family: Trebuchet MS, sans-serif; font-size: 95%;-webkit-border-radius: 15px;-webkit-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96); -moz-box-shadow:    7px 4px 14px rgba(176, 155, 121, 0.96);box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);">
 
<font size =3 face=Georgia >
 
<font size =3 face=Georgia >
  
The management team of LKSLIB are striving for better customer experience, especially the physical study environment in LKSLIB. To get more information from the library user, they have collected information from social media platforms, user surveys feedbacks, etc. However, unlike the information about online search request, it was hard for them to collect statistics about the physical usage of the library, especially the usage of a specific user group.
+
LKS library is the main study area for SMU students. The management team of Li Ka Shing Library is striving for better user experience. Unlike e-book usage or search request which data can be easily collected, they have little information about physical usage of the library, especially the usage of specific user groups. Our group has been studying in SMU for four years, and we are motivated to know how our peers are using the library as well.
LKSLIB utilizes card reader to control the entrance of the library, and when student approaches the entrance and taps in, a log will automatically be generated with the student information and the timestamp. Recently, the library management teams decide to look into this dataset to have a better understanding about the physical usage of the library. Combined the card reader log with the student database, they could get the entrance information about each single library user, but this is not enough. With the help of data analytics technology, the management team is looking for more detailed insight about the students’ usage of the physical library.
 
  
 
</font>
 
</font>
Line 65: Line 65:
 
<font size =3 face=Georgia >
 
<font size =3 face=Georgia >
  
1. Understand usage pattern
+
We aim to study the correlation between the two sets of variables:
*Peak hours
+
 
*Peak day of week
+
*Dean's Lister vs. Non-Dean's Lister
*Academic weeks vs. Term break
+
*Singaporean Students vs. International Students
*Exam period vs. Non-exam period
+
 
2. Compare usage level
+
Exploratory data analysis (EDA) is an approach to analysis data sets to summarize their main characteristics. Bar charts are usually used to present the grouped data with rectangular bars with lengths proportional to the values that they represent in order to show the comparison among categories. Primarily EDA is often used for seeing what the data can tell us and explore the data to see the possible hypotheses that could lead to model fitting and hypothesis testing. In our study, we use EDA to have an overview of the analysis and draw a primary conclusion from that.  
*Across schools
+
 
*Undergraduates vs. Postgraduates
+
Compared with EDA data visualization, statistical test in terms of one-way ANOVA brings a number of advantages and great statistical power due to increased precision and more informative interpretation of the results. It provides us with deep insights on the relationships between different variables and statistically prove our hypothesis based on the data. In our case, we use one-way ANOVA test to further validate the conclusion we drawn from EDA process. With our statistical test result, we reject or accept our null hypothesis, and this provides us with statistical support for our final conclusion.
*Freshmen vs. Seniors
+
 
*Alumni vs. Non-alumni
+
</font>
 +
</div>
 +
 
 +
==<div style="background: #000033; padding: 13px; font-weight: bold; text-align:center; line-height: 0.3em; text-indent: 20px;font-size:26px; font-family:Book Antiqua"><font color= #ffffff>Methodology</font></div>==
 +
<div style="margin:20px; padding: 10px; background: #ffffff; font-family: Trebuchet MS, sans-serif; font-size: 95%;-webkit-border-radius: 15px;-webkit-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96); -moz-box-shadow:    7px 4px 14px rgba(176, 155, 121, 0.96);box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);">
 +
<font size =3 face=Georgia >
 +
 
 +
<center>
 +
[[File:MethodologyGroup09.png|850px|center]]
 +
</center>
 +
 
 
</font>
 
</font>
 
</div>
 
</div>

Latest revision as of 11:49, 24 April 2017


Back To Main Home   Project Overview   Project Findings   Project Management   Documentation


SMU Library.jpg

Li Ka Shing Library (LKSLIB) is the first library of Singapore Management University, officially opened on 24 February 2006. The Library is named after Hong Kong businessman Dr. Li Ka-shing, and the Li Ka Shing Foundation donated and endowment to the library for collections. The main objective of the library is to offer an interactive study and research space for SMU community.

The LKSLIB includes four floors that comprise about 8,800 square meters with 1,800 seats. Inside the library, there are a variety of spaces including open spaces for individual and collaborative use, learning commons which opens 24/7, quiet areas that for individuals to focus on their work, project rooms with LCD panels, investment studio, postgraduate lounges etc. As a modern library, it is also well equipped with high-speed wireless network, color printers, scanners, public computers with professional financial software available, up-to-date newspapers and magazines, collections of lifestyle videos and games, and this is also the reason why LKSLIB is so attractive for SMU community.

Project Background

In our project, our focus is on analyzing the library entry information from the card reader logs. The card readers are located at the entrance of the library gantries, both located at the main entrance of LKSLIB and at the linkbridge side entrance. Students need to tap their card whenever they enter the library. This provides us with the entry information, which includes timestamp and basic information about the student. To better understand the library usage, the library management team is interested to know whether we could find any usage pattern for library of a particular user group (e.g. Dean’s List student), and see if any other business insights could be drawn from the data. We will also work on statistical analysis in order to confirm on our insights.

We use R to build a web application to clean the raw data and use Tableau to do data visualization to compare the usage level for dean’s list and non-dean’s list students, Singaporean students and international students. Then, we will do one-way ANOVA confirmative analysis using SAS JMP.

Motivation

LKS library is the main study area for SMU students. The management team of Li Ka Shing Library is striving for better user experience. Unlike e-book usage or search request which data can be easily collected, they have little information about physical usage of the library, especially the usage of specific user groups. Our group has been studying in SMU for four years, and we are motivated to know how our peers are using the library as well.

Objectives

We aim to study the correlation between the two sets of variables:

  • Dean's Lister vs. Non-Dean's Lister
  • Singaporean Students vs. International Students

Exploratory data analysis (EDA) is an approach to analysis data sets to summarize their main characteristics. Bar charts are usually used to present the grouped data with rectangular bars with lengths proportional to the values that they represent in order to show the comparison among categories. Primarily EDA is often used for seeing what the data can tell us and explore the data to see the possible hypotheses that could lead to model fitting and hypothesis testing. In our study, we use EDA to have an overview of the analysis and draw a primary conclusion from that.

Compared with EDA data visualization, statistical test in terms of one-way ANOVA brings a number of advantages and great statistical power due to increased precision and more informative interpretation of the results. It provides us with deep insights on the relationships between different variables and statistically prove our hypothesis based on the data. In our case, we use one-way ANOVA test to further validate the conclusion we drawn from EDA process. With our statistical test result, we reject or accept our null hypothesis, and this provides us with statistical support for our final conclusion.

Methodology

MethodologyGroup09.png