Difference between revisions of "ANLY482 AY2016-17 T2 Group06"
Di.wu.2013 (talk | contribs) |
Di.wu.2013 (talk | contribs) |
||
| Line 52: | Line 52: | ||
3. To analyze the monthly performance data and use data visualization to present the meaningful insights. | 3. To analyze the monthly performance data and use data visualization to present the meaningful insights. | ||
| + | |||
| + | == Project Progress == | ||
| + | [[File:Team06 midterm progress 40.JPG|center|600px]] | ||
Revision as of 23:07, 23 February 2017
|
HOME |
Project Overview
Khoo Teck Puat Hospital (KTPH) is a 590-bed general and acute care hospital, managed by Alexandra Health System. Opened in June 2010, KTPH offers a comprehensive range of medical services and specialist care to the community in the north. KTPH is required to submit various monthly performance report to Ministry of Health. Currently, the business analysts need to do data cleaning and verification manually and generate different report. This tedious process would cause them around 20 days.
Hence, this project aims to use R-language to provide a solution to automate the whole process with less human errors, as well as data visualization outcome to help the data analytics.
Project Motivation
In recent years, digital disruption in every aspects of the commercial world has been prevailing. The ever-increasing trend of digital transformation can be attributed to the widespread adoption of business intelligence and data analytics approaches. Both of which are essential in facilitating organization’s decision-making process and effectively bridging the gap between IT capabilities and business functions. In Singapore’s context, Smart Nation initiative effectively drives adoption of data analytics among industry partners by harnessing the power of data technologies to create substantial business benefits.
In a sense, the rising industry needs drive employers to look out for individuals capable of drawing insights from numerous amount of data in seek of restructuring and optimizing ongoing business processes. As a group of graduating analytics students looking for hiring opportunities, our skills developed so far are mostly in line with market needs, which sparked off our desire to embark on a career in analytics. However, due to syllabus’ constraint, skills developed in courses like, analytics foundation and data mining, are mostly in silos while in actual fact they constitutes an important component of the continuous Exploratory Data Analysis process. Meanwhile, most of our assignments and projects put too much emphasis on constructing the right model in delivering the right insight while neglecting essential steps like, data sourcing, preprocessing and iterative model refining.
Analytics Practicum project not only provides us with a hands-on experience on solving a real-life business problem with analytics methodologies. Most importantly, it draws linkage between skills developed through multiple courses so as to construct an integrated analytics solution. We hope to go beyond ‘low-hanging fruits’ like, simple model construction with numerous assumptions. Rather, we believe that the ‘touch-and-feel’ experience on analytics project lifecycle, will get us further down our career path in the near future.
Project Objectives
1. To automate the data cleaning process according to the required procedures for Specialized Outpatient Clinic (SOC), Acute and Emergency (A&E), and Inpatient (Inpt) data files. To generate clean data and pick out all the dirty data into two separate data files.
2. Use the clean data to generate the monthly reports automatically for Ministry of Health (MOH) in the standard format.
3. To analyze the monthly performance data and use data visualization to present the meaningful insights.
Project Progress
