ANLY482 AY2015-16 Term 2

About

Current Run

Projects Up For Grabs!

Grading & Deliverables

Downloads & FAQ

List of Projects

Title	Analytics Practicum Description	Student Member(s)	Project Supervisor	Sponsor
Optimizing Warehouse Processing	The practicum’s project sponsor is a supply chain and logistics company. Currently, its warehouse data are not being utilized. By providing its warehouse data (inbound and outbound) transactions to the team, the sponsors would like the team to create a dashboard to help solve 3 main issues. Firstly, to help sponsor categorize warehouse SKUs into ABC categories (each category refers to how fast the goods move) to facilitate optimizing storage of SKUs in warehouse. Secondly, to provide employees with a high level visualization of the SKUs movement into, within, and out of the warehouse. Lastly, to analyze and suggest possible alternatives to improve the picking process within the warehouse (order picking VS batch picking).	Group01- Team Skulptors LEONG Junkang, Gabriel TAN Siying ZHOU Xuanyi	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	A local multi-national corporation (MNC) Mr Khoo, Head of Operation Innovation & Development (Corporate) Miss Shen, Executive, Operations Innovation & Development (Corporate) Mr Sundar, Process Improvement Executive (Automation)
Analysis of User and Merchant Dropoff for Sugar App	Sugar is an interactive city guide that seeks to encourage a culture of exploration in Singapore and helping local small businesses get discovered. Sugar’s merchants are mainly small local businesses in Singapore. It has a large variety, including cafes, small restaurants, bars, hair salons, gyms, gift shops. The benefits for merchants is advertising to users that are in close proximity to them. Users in turn get discounts on products that are in the closest proximity to them. As Sugar is a relatively young startup in Singapore, it has not yet attained a critical mass of user and merchant numbers. As such, user growth and user experience is vitally important. To reach this critical mass, Sugar needs to minimize user and merchant attrition, and retain vital segments of both groups. Furthermore, as a two-sided market, Sugar needs the network effect and also find out which group(Users or Merchants) adds more value to their bottomline. The objective of our project will be to improve Sugar's bottomline via Merchant Analysis User Analysis Two-Sided Market Analysis Geospatial Analysis We will be using several techniques such as funnel plots, time series analysis, shortest distance analysis(Geospatial) and regression modeling to get insights and subsequently deriving recommendations for Sugar to increase its revenue and growth.	Group02- Team TurnKEY Kang Long Elizabeth Tan Yi Sheng, Lim	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Benjamin Lee Founder and Chief Executive Officer of Sugar Technologies Pte Ltd.
Teppei Syokudo - Improving Store Performance	Teppei Syokudo is a Japanese Food and Beverage chain, under the umbrella of the famous Teppei Japanese Restaurant. In order to drive store performance through controllable factors, Teppei Syokudo is looking at focusing on staff performance. Most F&B businesses, including Teppei Syokudo, do not set detailed KPIs to evaluate how their staff are performing. If Teppei Syokudo is able to track the performance of their staff through relevant KPIs, they will be able to motivate staff to meet these KPIs, which will in turn boost the business’ bottom line.Teppei Syokudo has identified the following KPIs to assess their staff: Percentage of drinks sales (number of drinks sold / number of meals sold) a measurement of how hard the staff are up-selling Labour Productivity (sales $ / working hours) a measurement of how effective the shop manager is in staffing the shop However, the business is uncertain if these are the right KPIs to set. Also, if they are the right ones, they are unsure as to what would be a good target to meet. Another factor for driving store performance is through product portfolio mix. Even though the staff may be up-selling and cross-selling, they may not know the right products to cross-sell to increase the probability of the customer making additional purchases. For example, most customers may tend to purchase Drink X together with Don X. In this case, if a customer orders Don X and is about to make payment, the staff can suggest Drink X to the customer, hence prompting a higher probability for the customer to purchase Drink X.	Group03- Team APSM TAN Jhun Boon YAP Jessie OH Peng Ho	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Itaru Nagao, Managing Director YCP Management Southeast Asia Pte. Ltd. YCP Retailing SEA Pte. Ltd.
Car Park Overspill Study	The objective of this project is to assist Media Research Consultants Pte Ltd (MRC) in understanding the current parking situations in 65 different locations in Singapore. These 65 parking locations compromise of 30 retail malls, 15 retails and Food & Beverage (F&B) clusters in landed housing estates, 10 hawker centers, and 10 community clubs.	Group04- Team ATOM Macus KHOO JunHao YAN ShaoHong Chris YO Wee King	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Media Research Consultants Pte Ltd
Social Media Analytics	The aim of this project is to provide deeper insight into SGAG's social network across its multiple platforms, namely Instagram and Twitter. Our client is the co-founder of the company and he seeks insights that can spur growth in SGAG's follower numbers. Through our analysis and research, we aim to help discover what kind of users are on each platform; the key engagement leaders for each topic; and how wide is the reach of these individuals. The final deliverables will aim to: Visualise the social networks of SGAG Identifying the user segments who engage SGAG's content, as filtered by topics and their reach	Group05- Team AP WANG Shyan Ann NG Tse Siong Sherman YONG Chin Wei	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Karl Mak, Co-founder at SGAG
Skyscanner Content Analysis	The project aims to help Skyscanner analyse its content sites in order to facilitate more effective planning of news articles. It will help understand the factors that affect content performance. The team will analyse content related data from multiple sources to determine what differentiates good and bad content based on certain performance metrics set by Skyscanner. This will be done through Text Based Cluster Analysis, Exploratory Modelling with logistic regression and Data Visualization using Tableau The deliverables include creating a dashboard with visualizations that will help Skyscanner team to better understand performance of content across different content channels. It will be used to validate some of the intuitions they might have about certain content topics/types and to determine the best time to publish them. The dashboard will benchmark certain metrics against pageviews as well as additional attributes that Skyscanner does not currently analyse via Google Analytics, such as the impact of title, text length, theme of article and number of images. Data set includes data from Skyscanner websites for the Singapore, Malaysia and Thailand markets.	Group06- Team SkyTrek Aseem PRABHAT Jedaiah TAN Jia Le NGUYEN Viet Huy	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Ms. Antoinette Tan Content Manager, APAC Skyscanner
Understanding Employee Social Networks	People analytics is a rapidly growing area of business intelligence and big data technology. It uses various facets of people-related data to optimize business outcomes and solve business problems. The application of people analytics with new techniques such as predictive behavioural analytics has helped organisations to save millions of dollars while improving attrition rates, employee engagement and identify underlying training requirements. TrustSphere is the widely recognized market leader in Relationship Analytics. TrustSphere enables forward thinking organizations to unlock the inherent value of their own networks using next generation technology. The solutions provide real-time intelligence and insights which help clients across the globe improve salesforce effectiveness, enterprise-wide collaboration and corporate governance.The motivation behind this project is to assist TrustSphere in verifying the effectiveness of their product through other statistical techniques. Access to TrustSphere’s datasets will allow the team to build a system from scratch using previously unused raw data to better understand turnover and attrition rules. The minimum research points we would like to address: Understand the number of relationships an employee will have at different periods of time in his or her working life Measure the speed of growth at which employee relationships grow in a company Correlations between the sizes of internal and external relationships employees have Through social network analysis, calculate the likelihood of an employee in an informal group leaving a company upon the exit of another closely tied employee Identification of metrics that can help predict the likelihood of an employee leaving	Group07- Team YSR Ridwan Ismeer Sadhvi Ilango Yashraj Jalota	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Greg Newman, Product Manager - TrustSphere
Health Analytics	To build a web application that utilises GIS functions for geospatial planning and analysis. This application aims to facilitate the computation and analysis of Health Promotion Board (HPB) KPI reporting metrics. The insights generated from the application will be used to manage Health Promotion Programme and Outreach Planning.	Group08 - Team HealthTics Erwin Trinh Hiep Dang Khoa Nyein Su Aye	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Health Promotion Board
CodeBetter Analytics: Identifying Patterns in Learning	Students using a web portal to learn programming languages and frameworks will answer a series of questions, which have their timings and results recorded. An analytics dashboard will be built to read from a live Firebase, thus dynamically generating charts and information for students to view their progress. Course conductors may also use this dashboard to better understand the needs of their students and modify their course accordingly.	Group09 - Team KyuuBI Shane GOH Ghee Gin Darren LIM Fei Hong LIM Wei Yang	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Prof. Chris Boesch Associate Professor of Information Systems (Education)
Commuting Patterns in Singapore	The main aim of this project is to understand how the urban form affects one’s decision to either use public transport or to walk by focusing on Tampines as our case study The objectives of our project are: Analyse commuting patterns for the 3 different age groups (i.e Adult, Elderly and Student) • Overall commuting patterns for the 3 different age groups • Inter town commuting patterns for the 3 different age groups • Intra town commuting patterns for the 3 different age groups • Intra town commuting patterns for the 3 different age groups who made at least 4 trips in one week during morning peak period Analyse multimodal transportation patterns for 3 different age groups • Transfer time interval for buses and MRT for the 3 different age groups • Relationship between walking and bus transportation using Student group as a proxy	Group10 - CommuteThere Jeanne Sim Peh Wuen Lim Hui Ting Jaclyn Lim Hui Ting	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)
Uncovering Market-Insights for Charles & Keith	This project aims to help Charles & Keith gain a better understanding of its China market through the use of data-analytics. With the market insights gathered, provide recommendations for the business on how they may apply them to its business to positively affect consumer buying decisions and capture more market share within China. Key objectives of this project involves: Visualise the overall generic consumer purchasing patterns and behaviour within China Identify best-selling products and item set for different regions or tiers of cities Highlight the differences between transactions of different locations in terms of product specifications or types Some business areas where the project findings could be applied: Strategic placement of products within product catalogues In-store shelving decision Strategic marketing promotions to cross-sell and upsell, at a localized market level Suggest Market Basket Analysis algorithm solutions for C&K’s e-commerce site Data set includes sales transaction data from all of Charles & Keith’s stores in China.	Group11-Team AYE Audrey Jee Zhi Ying Edwin Tan Soon Hong Toh Yan Ying	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Charles & Keith Group
Health Promotion Board GIS Application	Our objective is to build an interactive and visual web application that utilises GIS functions for geospatial planning and analysis. It will be able to compute and analyse HPB KPI reporting metrics. The web application should be easy to use to support the staff both technical and non-technical in their many Health Promotion programmes and outreach planning. It will also assist the staff in clear and easy to understand presentations to the executives who have little or no background in GIS analysis so as to be able to plan their operations.	Group12 - Griffins Melissa Lim Seok Yu Tan Wei Liang Tan Yu Ling	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Health Promotion Board
Natasha Studio	Natasha Studio is a dance studio in Singapore that offers various genres of street dance lessons to interested individuals, including Bboying, Hiphop and Kpop. Currently, the company has no formal sales management system and is looking to apply analytics to create more customer satisfaction and increase the competitiveness of the business. Based on discussions with both our client and project sponsor, our business objective is to provide Natasha Studio with recommendations for class types, packages and dance genres that it should offers. To achieve this business objective, the technical goal would be to first create a proper database system to aid in data recording and ensure consistency of data. This would then lay the foundation for our team to apply techniques like market basket analysis to identify customer purchasing behaviours and propose appropriate business actions for Natasha Studio. Thus, our final deliverables would be as follows: 1. Relative Database Management System with a User Interface 2. Identification of Customer’s purchasing behaviours and thus offer appropriate business recommendations	Group13 Team Ameilax Sng Ei Leen Wong Jia Wei Tan Ziling Amy	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Larry Liu Business Manager Natasha Studio
Exploratory Analysis of Indonesian Motor Insurance	To conduct an exploratory analysis on Tokio Marine Indonesia's Motor Insurance segment. Factors that will be explored include (a) Policy growth, (b) Underwriting Profitability and (c) Claim Insights	Group14- Team HEW Huai Zher Elijah Tan Yi Rong Winston Ong Bing Shen	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Benito Mable Vice President, New Opportunities Tokio Marine Asia
Singapore Students Performance Analysis	This project makes use of PISA (Programme for International Student Assessment) data collected during the latest survey of 2012 with regards to Singapore. The aim of this project is to explore the relationship between computer usage in school and secondary-school student performance in reading and mathematics. Building on the current international work done by PISA, our project will bring the analysis to Singapore national level and study various aspects of students of performance relative to their access to computer in and outside of school, in order to provide insights for education policy makers of Singapore Ministry of Education (MOE).	Group15 Nguyen Le Hong Ngoc Poh Jin Hui Zhao Yazhi	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)
Car Park Overspill Study	Land Transport Authority(LTA) aims to do an analysis to understand the current parking situation at these selected locations. The LTA Contract Parking Study was awarded to Media Research Consultants in March 2015 to undertake the Study involving 65 car park locations in Singapore, including 30 retail malls, 15 retail and F&B clusters in landed housing estates, 10 hawker centres, and 10 community clubs. This study was to conduct parking occupancy surveys, human traffic counts, and interview surveys at the selected locations at stipulated times. The study incorporated the conventional method of manual counting as well as deployment of automated counting equipment. Face-to-face interviews were employed for the interview survey segment. In addition to the study and taking of detailed data from field surveys, this project aims to develop a simulation tool that enables the systematic analysis of the impacts of various parameters, using a collected set of quantifiable data.	Group16 Blackbox Chen Xueye Zeng Jiadong Zheng Wei	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Media Research Consultants Pte Ltd
Social Media Content Analysis	This project aims to uncover valuable insights on SGAG’s content attributes in order to achieve audience growth. Using data gathered from SGAG’s facebook page for the year 2015, the team hopes to firstly, conduct exploratory data analysis so as to identify overall performance trends. Next, the team will be performing cluster analysis followed by sentiment analysis, topic analysis and content analysis. Lastly, the team will be building a regression model, which includes findings derived from the analysis conducted, in order to predict better performing future posts. With the insights gained, the team will be providing recommendations to enable data driven content creation, thus allowing SGAG to achieve their aim of greater growth.	Group17 T(eam)ROLL Nur Amirah Bte Mohd Noor Gan Sze Huey	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Karl Mak, Co-founder at SGAG
Optimizing Decision Making in a Connected World	Taylor Nelson Sofres (TNS) is one of the largest research agencies worldwide. They provide actionable insights to help companies make impactful decisions that drive growth. Our team will be involved in the 2015 Connected Life study, which is TNS's global syndicated study to understand connected consumer better. The aim of the project is to build an effective explanatory model that will help to reduce the number of variables needed for a market research study. By identifying pertinent variables and omitting variables that do not add value to the study results, we will be able to effectively reduce the number of survey questions in a study and reduce strain on survey respondents. This helps to increase accuracy of survey results and reduces the cost needed to incentivise respondents to complete long surveys, while meeting the aims of the marketers.	Group18 - Team VisCon Denise Quek Si Ying Tan Wei Song	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Subhashish Dasgupta, SEA Automotive and Regional Client Director at TNS
NUH Inpatient Meals Survey Analysis	National University Hospital (NUH) is one of the leading medical institutions in Singapore with around 50,000 inpatients and 600,000 outpatients. Sodexo is the esteemed provider of meals to the inpatients of NUH and is in charge of maintaining the standards of the meals for the patients. Sodexo is in charge of conducting surveys with the inpatients to gather feedback on the meals that are provided to them in the hospital. The purpose of the survey is also to gain insights on what factors are most important for the patients and recommendations that can be helpful in improving the services provided to them. Sodexo appointed Media Research Consultants, a Mediacorp Enterprise specializing in market research, for conducting and analyzing the NUH In-Patient Meals Audit Survey from 2015-2017. This project is sponsored by MRC Mediacorp. The objectives of the project are: Online dynamic dashboard with data visualizations An analysis of the important attributes of the survey An in-depth analysis of the satisfaction of different attributes by drilling down to wards, patient types and diet types Correlation between different attributes Summarize areas of improvements, customer feedback and suggestion for Sodexo	Group19 DataStat Pooja Tulsyan Akshat Agarwal	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Jason Soriano MRC Mediacorp