Difference between revisions of "ZAN Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
Line 47: Line 47:
 
<br/>
 
<br/>
 
The main objective of the project would be to develop the following:
 
The main objective of the project would be to develop the following:
# Creation of an application to sort SKUs by A, B and C categories
+
The objective of the project would be to develop the following:
#* To provide employees with a high level view of the flow and demand changes for different SKUs. This allows higher level management employees to make important decisions based on it (e.g. eliminate SKUs which are extremely slow moving as they are taking up warehouse space which can be otherwise optimized.)
+
# Analysis of Hospital X's inpatients data
# Dashboard for quick visualization of inbound and outbound rate for different SKUs
+
#* To understand the data domains
#* Inbound rate: X-axis and y-axis to be date against number of inbound in pieces, carton and pallets per day.
+
#* To identify the contributing factors that lead patients to defaulting appointments 
#* Outbound rate:  X-axis and y-axis to be date against number of inbound in pieces per day.
+
#* To analyse any pattern among the patients that defaulted their appointments
#* This reduces both the time and manpower needed for the manual analyzing of data as it provides a general trend and flow of SKUs. For instance, when an employee notices a particular product’s supply running low he will be able to call for a refill immediately.
+
#* To evaluate the feasibility of creating a predictive model or a description model
# Warehouse Utilization Tool
+
# Recommendations based on findings
#* To help employees understand fill and flow rate of the warehouse based on historical data.
+
#* To help stakeholders understand the analysis of the findings
#* To determine pick rate of warehouse locations and identify most used and least used locations.
+
#* To consider the feasibility of a visual aid such as dashboard to aid in the stakeholders' future reference
 
<br/>
 
<br/>
  
Line 61: Line 61:
 
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Provided Data</font></div>
 
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Provided Data</font></div>
 
<br/>
 
<br/>
The data will be obtained from the in-house Warehouse Management System (WMS). The company updates the database whenever goods are being received (inbound) and released (outbound). For the purpose of the project’s analysis, the team will be given one year worth of data for each of the companies' SKUs.  The size of the data is expected to be approximately 4.2 million rows of data (4 excel sheets) for each company. For each of the companies, there will be 3 sets of data provided, namely:
+
The data is withheld until the NDA agreement is signed
# Product master sheet
 
# Product inbound report
 
# Product outbound report
 
 
<br/>
 
<br/>
  
Line 70: Line 67:
 
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Methodology</font></div>
 
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Methodology</font></div>
 
<br/>
 
<br/>
The data will be obtained from the in-house Warehouse Management System (WMS). The company updates the database whenever goods are being received (inbound) and released (outbound). For the purpose of the project’s analysis, the team will be given one year worth of data for each of the companies' SKUs.  The size of the data is expected to be approximately 4.2 million rows of data (4 excel sheets) for each company. For each of the companies, there will be 3 sets of data provided, namely:
+
Work in progress
# Product master sheet
 
# Product inbound report
 
# Product outbound report
 
 
<br/>
 
<br/>
  
Line 79: Line 73:
 
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Project Scope</font></div>
 
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Project Scope</font></div>
 
<br/>
 
<br/>
The data will be obtained from the in-house Warehouse Management System (WMS). The company updates the database whenever goods are being received (inbound) and released (outbound). For the purpose of the project’s analysis, the team will be given one year worth of data for each of the companies' SKUs. The size of the data is expected to be approximately 4.2 million rows of data (4 excel sheets) for each company. For each of the companies, there will be 3 sets of data provided, namely:
+
While the project will revolved around the above objectives, our project sponsor is flexible to allow us to explore other possible relevant analytical tools or techniques that would enhance the findings.
# Product master sheet
+
#The dataset is limited to records from 2015 to 2016, which prevent any seasonal or yearly analysis
# Product inbound report
+
#The dataset is only pertained to our project sponsor’s department, which tends to younger patients from the age of 18 years old and below.
# Product outbound report
 
 
<br/>
 
<br/>
  
 
<!--Content End-->
 
<!--Content End-->

Revision as of 10:46, 31 December 2016


HOME

 

PROJECT OVERVIEW

 

PROJECT FINDINGS

 

PROJECT MANAGEMENT

 

DOCUMENTATION

 

ABOUT US

 


Project Description


Hospital X is a pioneer tertiary hospital that provides a comprehensive range of medical and rehabilitative services for children, adolescents, adults and the elderly.This project plans to make use of the dataset provided by our project sponsor to analyse if there is any relationship between the variables and to create a predictive model for likelihood of a patient in defaulting appointments.


Motivation


Our project sponsor is a medical professional working for Hospital Y. He specialises in tending to younger patients from the age of 18 years old and below. Patients are usually referred to Hospital X by other medical institutions or they booked an appointment directly. Currently, Hospital X experiences high defaulted or missed appointments rate of about 21% for first visits and 19% for review visits. Defaulted appointments lead to longer appointment lead times, lower operation productivity and overall lower quality of care. Freeing up the time wasted by patients’ no-show would improve utilisation of slots, and even reduce appointment wait time for other patients. By sponsoring this project, our sponsor also hopes to tap into the under-utilised administrative data that is collected by the hospital daily.

Objective & Goals


The main objective of the project would be to develop the following: The objective of the project would be to develop the following:

  1. Analysis of Hospital X's inpatients data
    • To understand the data domains
    • To identify the contributing factors that lead patients to defaulting appointments
    • To analyse any pattern among the patients that defaulted their appointments
    • To evaluate the feasibility of creating a predictive model or a description model
  2. Recommendations based on findings
    • To help stakeholders understand the analysis of the findings
    • To consider the feasibility of a visual aid such as dashboard to aid in the stakeholders' future reference


Provided Data


The data is withheld until the NDA agreement is signed

Methodology


Work in progress

Project Scope


While the project will revolved around the above objectives, our project sponsor is flexible to allow us to explore other possible relevant analytical tools or techniques that would enhance the findings.

  1. The dataset is limited to records from 2015 to 2016, which prevent any seasonal or yearly analysis
  2. The dataset is only pertained to our project sponsor’s department, which tends to younger patients from the age of 18 years old and below.