ANLY482 AY2016-17 Term 1
|
|
|
|
|
|
| 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). |
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) |
A local multi-national corporation (MNC)
|
| 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 |
|
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:
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
|
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. |
|
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:
|
|
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. |
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) |
Ms. Antoinette Tan |
| 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:
|
|
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. |
|
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. |
|
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
Analyse multimodal transportation patterns for 3 different age groups |
|
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:
Some business areas where the project findings could be applied:
|
|
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. |
|
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
|
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
|
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
|
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
|
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. |
|
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. |
|
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:
|
Group19 DataStat
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Jason Soriano MRC Mediacorp |
| Gambling Behaviour Pattern Analysis |
The aim of our project is to allow Singapore Pools to better understand the gambling behaviours of their customers through the identification of gambling patterns, which can be unique across different clusters of individuals. Each cluster might have their own specific ways of splitting their bets, different churn rates, preference for a league, different decision making process, and ways of selecting their winning bets per match. Such behavioural patterns could possibly be linked back to certain demographics pertaining to the cluster, allowing us to further infer reasons behind their gambling habits, and hopefully could help us identify those irresponsible gamblers. For the purpose of the project, the scope of our project is limited to the Sports Betting segment of their Account Customers. The objectives of our project: (1) Profile their existing pool of customers through clustering analysis (2) Create a data visualization of the consumer betting activity (3) Build a dashboard to visualize the profiling and data points |
Group 20 - SMU Analytical Gambling Unit
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Singapore Pools |
