ANLY482 AY2015-16 Term 2
|
|
|
|
|
|
| Title | Analytics Practicum Description | Student Member(s) | Project Supervisor | Sponsor |
|---|---|---|---|---|
| Optimizing Warehouse Processing | Today, a local multi-national corporation faces the same adversity as many others – the plight of unworked data. Visualizations of the data provided by their in-house warehousing solution has proven to be difficult and much of the information is not placed to better use. The company hopes to solve 3 main issues, namely how they should categorize their warehouse supplies into ABC categories (each category refers to how fast the goods move) to store their goods in the best location available, how can their data be visualized better so that it is easier for employees to see, and how can their warehouses be utilized to the fullest to ensure minimal wastage. Our team, Skulptors, will be developing a dashboard application to solve the issues of this company. Control charts will be used to depict control of the movement of the SKUs, identifying which type of products have excessive or lack of movements from the warehouse. Treemaps will be used to identify products or SKUs that have minimal utilization of warehouses, and also to identify which warehouse location is not fully utilized. Java add-ons will be used to facilitate additional functions, such as allowing the upload of an excel file to update the database. This allows for our solution to remain sustainable. Time series line graphs will also be used for easy display of inflow and outflow rate of specified SKUs. |
|
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 minimise user and merchant attrition, and retain vital segments of both groups in order to preserve the network effect of Sugar’s platform. This is done via 3 means: Voucher Redemption |
|
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 |
| To be confirmed | To be confirmed |
Group05- Team AP
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | To be confirmed |
| Skyscanner Content Analysis |
The project aims to help with Skyscanner's analyse its content sites in order to facilitate better planning. It will help understand the factors that affect content performance. Deliverables include creating a dashboard with visualizations that will help Skyscanner team to track the performance of articles across weeks and months, matched to trends and seasonality. 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. The team will also analyse content pages to determine what differentiates good and bad content based on certain performance metrics. This will be done through Text Mining (Topic Analysis), Content Crawling, MLR and matching with Google Trends API. 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 |
| To be confirmed | To be confirmed |
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | To be confirmed |
| Urban Analytics for Planning Support System | In conjunction with a government initiated project - Re-imagining Tampines, this project aims to analyse the liveability of Tampines based on the connectivity between each residential blocks to the nearby facilities that are within walking distance. Site visits will be conducted to measure the actual distances taken to travel to the nearby facilities using a mobile application by QGIS called MapIt!
Together with the demographic data provided by the sponsor, we aim to analyse how residential areas in Tampines are well-served to the public, as well as provide recommendations to our analysis and observations to improve connectivity in the area, thereby promoting walking to the residents. |
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | To be confirmed |
| 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 | To analyse the purchasing behaviour of Natasha Studio’s customers and provide sales and marketing recommendations. |
Group13 Team Ameilax
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Larry Liu,
Business Manager Natasha Studio |
| Marketing Analytics at Tokio Marine | To develop a database analysis to formulate a demographic and psychographic profile of Tokio Marine's customers | Group14- Team HEW
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Benito Mable
Vice President, New Opportunities Tokio Marine Asia |
| KTPH Public Health |
The project is part of an ongoing effort to adopt data visualization to monitor public health by KTPH. Based on data from health screening and KTPH alignment programs, a dashboard can be constructed to assist health officers of KTPH to observe public health conditions, single out unhealthy individuals, and monitor their health progress. Additionally, the dashboard serves as a means to evaluate effectiveness of KTPH alignment programs to improve public health, and provide insights that can refine these programs to better target the population in future. As a follow-up of an IS480 project by team Cinquefoil, the aim is to improve the KTPH dashboard by adopting a richer set of visualization techniques, so as to enable a more user-centric data querying and discovery process. Specifically, KTPH users will be able to use the dashboard to identify unhealthy individuals of the population, the areas they are in, take appropriate actions and monitor the results of such actions As such, the objectives of our analytics project consist of the following:
|
Group15
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Khoo Teck Puat Hospital & SMU T-Lab |
| 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 |
| Visualizing & Analyzing of Decision Making in a Connected World | The aim of this project is to help marketers from the FMCG industry to identify target consumer profiles, digital media platforms, and as well as devices to allow for more targeted marketing strategies, thus maximizing return on investment (ROI) on their business decisions. Our team will be developing an interactive and dynamic dashboard that will allow end users to visualize data findings and generate actionable insights through the data from the Connected Life study. |
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Subhashish Dasgupta,
SEA Automotive and Regional Client Director at TNS |
| Inpatient Meals Survey | To be confirmed |
Group19
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Jason Soriano MRC Mediacorp |
|
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 |
To be confirmed |
Group20
|
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) | Singapore Pools |
