Difference between revisions of "ANLY482 AY2017-18T2 Group19 Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
Line 55: Line 55:
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SPONSOR INTRODUCTION</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SPONSOR INTRODUCTION</u></font></div>
  
Fujitsu-SMU Urban Computing and Engineering (UNiCEN) Corp. Lab is part of the Urban Computing & Engineering Centre of Excellence (CoE), a Public-Private Partnership between Agency for Science, Technology and Research (A*STAR), Fujitsu Limited (Fujitsu) and Singapore Management University (SMU) established on 15 Oct 2014. UNiCEN focuses mainly on two research areas, namely Dynamic Mobility Management (DMM) and Maritime & Port Optimisation (MPO). These two areas place emphasis on solving problems associated with crowds, congestion and queues, and resource management.
+
Singapore Management University Library consisting of Li Ka Shing Library and the Kwa Geok Choo Law Library, offers a variety of study spaces, including quiet areas for a more focused study and project rooms for collaborative discussions, as well as a 24 hours learning commons. The libraries offers a variety of resources including books and course reserve materials which allows students to get more information on the subject matter.
  
  
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>PROJECT INTRODUCTION</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>PROJECT INTRODUCTION</u></font></div>
  
This project aims to provide a staff scheduling and route plan for nurses who are providing routine checkups and other services to the elderly in the comfort of their own homes. We aim to develop an algorithm, taking into consideration the appointment duration, traveling time to the patient’s location and other constraints to optimise the schedule for the nurses. This algorithm will be able to be used by all home health care foundations in the future to help them schedule their nurses efficiently.
+
The client, SMU Libraries, aims to be able to consistently offer an improved user experience by ensuring that library users have access to library resources. The main policy currently enacted in this aspect would be the library’s collection policy which outlines the scope of what resources are appropriate to acquire and to retain in fulfillment of the SMU Libraries’ mission and vision. One type of resource in question is the course reserve collection section. Course reserves materials are come in the form of print and online and are high in demand. This project aims to analyze the usage volume, usage patterns and usage ratio of these course reserve materials over a period of time, and ultimately, be able to provide them insights into their collection policy.
We will build a simple web application to allow the user to upload a csv file of the patients’ locations and prefered appointment time. The system will then run the algorithm which will give a detailed breakdown of the nurses’ schedules. The schedule will include the start and end time for a patient at a location.
+
(Further analysis may also include the comparison between a 3-hours-loan and print 3-days-loan, which may give the team insights on their loan policy.)
  
  
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>MOTIVATION</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>MOTIVATION</u></font></div>
  
Singapore is experiencing an aging population, experiencing an increase in median age from 40 to 40.5 years old and 12.4% to 13% for the population aged 65 and above in 2017. This results in an increase in difficulties that the elderly face, such as disabilities or being frail, in order for them to go to a hospital to have their checkup. This may cause discomfort and a less than satisfactory check-up throughout the whole process from going to and from the hospital and thus the need for home healthcare services are increasing.
+
SMU libraries’ mission includes possessing the capability in providing seamless access to information using innovative and leading edge technology. They are committed to delivering exceptional services and building dynamic relationships with the SMU community. As such, they are constantly seeking out ways in which they can improve users’ experience in the libraries. Experience is derived not only in terms of the provision of space for users to study in, but also in terms of the quality of materials available to the users. This project focuses on the provision of course reserve materials.
Health Minister Gan Kim Yong estimated an increase in 7600 more places in day, home and palliative care by 2020. The current situation may still be acceptable where nurses are given the cases and locations and they will plan it out themselves. However when the number of cases per nurse increases exponentially, the current system may not provide the most efficient services to the patients.  
+
By providing useful insights, we aim to be able to help our fellow course mates in being able to access course materials easier while ensuring SMU libraries’ continued adherence to its ‘just in time’ access policy for both electronic and print resources.
By working on this project, we hope that we are able to maximise the level of satisfaction for the elderly during their check-ups while utilising the nurses efficiently by planning the shortest route to achieve the most number of services in a day.
 
  
  
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>OBJECTIVES</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>OBJECTIVES</u></font></div>
  
1. Provide an algorithm for the scheduling of staffs that maximises the followings:
+
This project aims to design a dashboard that enables the following analysis:  
*Maximizing number of matches of prefered time slots from patients
+
# Usage analysis of both print and online Course Reserve materials
*Maximizing number of revisiting nurses to patients instead of a new nurse each visit
+
# Usage comparison between print-3-hours-loan and print-3-days loan
*Maximizing utilisation of nurses in a day
 
2. Provide a UI for staffs to see their schedules
 
  
3. Provide dashboard to show the staff utilisation rate, plot out the route of the nurse for the day and inform where they should be at the current time
 
  
  
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SCOPE OF WORK</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SCOPE OF WORK</u></font></div>
  
1. Data Preparation
+
# Data collection  
*Data collection
+
# Data cleaning  
*Data cleaning
+
# Exploration of data  
*Exploration of data
+
# Model generation
2. Model Planning
+
# Data visualisation
*Problem Definition
 
*Generation of model objective and constraints
 
3. Model Building
 
*Development of algorithm
 
4. Model Evaluation
 
*Model validation
 
*Improvements in model score and per client’s recommendation
 

Revision as of 22:24, 14 January 2018


G19 Home.png   HOME

 

G19 Overview Icon.png   PROJECT OVERVIEW

 

G19 Findings Icon.png   PROJECT FINDINGS

 

G19 Management Icon.png   PROJECT MANAGEMENT

 

G19 Documentation Icon.png   DOCUMENTATION

 

G19 To Main Page icon.png   BACK TO MAIN PAGE


 

[[BACKGROUND]]


SPONSOR INTRODUCTION

Singapore Management University Library consisting of Li Ka Shing Library and the Kwa Geok Choo Law Library, offers a variety of study spaces, including quiet areas for a more focused study and project rooms for collaborative discussions, as well as a 24 hours learning commons. The libraries offers a variety of resources including books and course reserve materials which allows students to get more information on the subject matter.


PROJECT INTRODUCTION

The client, SMU Libraries, aims to be able to consistently offer an improved user experience by ensuring that library users have access to library resources. The main policy currently enacted in this aspect would be the library’s collection policy which outlines the scope of what resources are appropriate to acquire and to retain in fulfillment of the SMU Libraries’ mission and vision. One type of resource in question is the course reserve collection section. Course reserves materials are come in the form of print and online and are high in demand. This project aims to analyze the usage volume, usage patterns and usage ratio of these course reserve materials over a period of time, and ultimately, be able to provide them insights into their collection policy. (Further analysis may also include the comparison between a 3-hours-loan and print 3-days-loan, which may give the team insights on their loan policy.)


MOTIVATION

SMU libraries’ mission includes possessing the capability in providing seamless access to information using innovative and leading edge technology. They are committed to delivering exceptional services and building dynamic relationships with the SMU community. As such, they are constantly seeking out ways in which they can improve users’ experience in the libraries. Experience is derived not only in terms of the provision of space for users to study in, but also in terms of the quality of materials available to the users. This project focuses on the provision of course reserve materials. By providing useful insights, we aim to be able to help our fellow course mates in being able to access course materials easier while ensuring SMU libraries’ continued adherence to its ‘just in time’ access policy for both electronic and print resources.


OBJECTIVES

This project aims to design a dashboard that enables the following analysis:

  1. Usage analysis of both print and online Course Reserve materials
  2. Usage comparison between print-3-hours-loan and print-3-days loan


SCOPE OF WORK
  1. Data collection
  2. Data cleaning
  3. Exploration of data
  4. Model generation
  5. Data visualisation