ANLY482 AY2015-16 Term 2

From Analytics Practicum
Jump to navigation Jump to search

Logo.png

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:

  1. Visualise the social networks of SGAG
  2. 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