ANLY482 AY2016-17 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
Identifying Failures in Logistics	The company been managing the distribution network for one of its major clients, handing both reverse logistics and forward logistics, resulting in both inbound and outbound shipments. Thus far, the lack of a dedicated dashboard to show summary tables regarding the status of the shipments have made it very difficult for the program managers and the sales team to monitor and follow up with requests from the client regarding specific shipments. Furthermore, the shift of the company’s direction to be proactive instead of reactive has prompted for the development of systems that would aid in monitoring and also provide analysis for users to not just follow up on cases, but to also seek avenues for further improvements. Hence, we will be working on this project to help formulate an effective solution to their needs whilst providing deeper analysis into the data that will help identify potential problems before they arise.	Group01-Hiryuu Chua Wan Theng Jouta Lim ZiYu Lin Qianpin	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Logistics Company
Kaiso - Observing Customer Behavioural Trends	Kaiso Ticketing is a ticketing service provider for concerts and musicals in Singapore. Established in 2001, Kaiso Ticketing has been collaborating and bringing in numerous independent performance gigs, both locally and overseas to the Singapore scene. Kaiso Ticketing operates mainly through their phone ticketing service, whereby ticket buyers call in to the customer service team to make their ticket booking for concerts and musicals. As companies realise the potential of the e-commerce field, they are increasingly establishing online sites for their customers and Kaiso Ticketing is one of them. Kaiso launched its online purchase site on October 2016 that allows registered customers to place purchases online. This site is an addition to the company’s phone ticketing lines, as part of its remote ticketing services. The online ticketing site serves to be a more convenient option for customers than its predecessors. With the inclusion of this new initiative, Kaiso Ticketing is interested to understand the difference in the customer’s ticketing behaviour before and after the launch. This insight will serve great use to the customer engaging units to understand the characteristics of their customers and engage them better in the future marketing campaigns.	Group 02 - Team Kaikai Lim Wei Fa Low Jianhao Jonathan Yong Lee Jia	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Kaiso Ticketing
Vanitee - Customer Retention, Beauty Professional Activeness and Brand Loyalty Analysis	Vanitee, a beauty services platform, bridges the gap between customers and independent beauty professionals in Singapore. Beauty services range from hairstyling, brows, nails, makeup, massages and facials. As of today, there are approximately more than 1700 beauty professionals and they have served over 20,000 customers so far. Despite their early success over the past 2 years, Vanitee plans to push their business further forward by focusing on their efforts to grow and retain their customer and beauty professional base. Our project aims to utilise techniques such as cluster analysis, survival analysis as well as extrapolation to identify and predict Vanitee's customer retention rate, beauty professional activeness levels and evaluate the effectiveness of their current VIP loyalty program.	Group03 - Team V Chow Si Min Sarah Lim Chang Jun Andrew	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Vanitee
E-commerce Analytics	Lazada Group is a privately owned E-commerce business, an online platform for customers to make product purchases from sellers via online transactions. Lazada currently has millions of products listed where many versions of the same product are being sold. Buyers are experiencing difficulty navigating product searches/catalog,. To help buyers gain quick access to the best products, intelligent ranking orders of all available product items needs to be generated to help buyers make preferred decisions and sellers get better sales. Furthermore, products quality as one of the key drivers of customer experience is hard to determine due to no fixed way to measuring it. A methodology is required to assess what attribute contribute most to the customers’ impression of product quality.	Group04-E-comm Ranon Sim Vincent Tatan Lee Da Young	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Lazada Group
SGAG - Social Media Analytics	SGAG has since continued to grow strong, has over 500,000 likes on their Facebook page and has also expanded to creating videos on Facebook as well as YouTube. As social media and the internet become increasingly widespread in Singapore, users are seen to be trending towards video related content from text based and pictured contents. With its listicles being very successful, SGAG wishes to place more focus on their videos, where competition is of abundance. Therefore, by studying historical data, SGAG would like to find out which kinds of videos are more popular and garners more views, in hopes of knowing the consumer’s preferences to in turn increase viewership.	Group 05 - Team 3GAG Chiang Ling Yi Clara Ang Sennett Khong	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Karl Mak, Co-Founder of SGAG and MGAG
Report Automation and Data Analytics for KTPH	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. Every month, KTPH needs to manually prepare 25 reports based on 4 data files, each of which contains around 60k rows, and submit the reports to Ministry of Health (MOH). The whole process takes about 2-week time every month and it's error-prone, as it involves intensive manual works. As such, our project will focus on automate the data cleaning and report generation process for KTPH, so as to improve the efficiency, accuracy and allow for better time-spending. Moreover, as currently there is a lack of data visualization for KTPH to view the changes in data records documented in reports; our project would also implement a dashboard for KTPH to view the important changes in data records.	Group06 - Enigma Wei Xiaoxin Wu Di Zheng Xiye	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Khoo Teck Puat Hospital (KTPH)
SMU Library Ezproxy Log Data Analytics	The Li Ka Shing Library’s electronic search platform offers a wide array of research resources with over 360,000 books, 80,000 journals, 160 databases and more than 16,000 SMU research publications in its Institutional Repository and Oral History Collection. The extensiveness of the amount of resources would mean nothing if the average user (e.g. You and me) do not utilize it to its fullest capabilities. Therefore, the analytics team (part of Learning & Information Services) in Li Ka Shing Library would like to discover meaningful insights about user behaviour on its electronic resources to provide necessary assistance in forms of library e-resources training, helpdesk and support. However, the current problem is the lack of knowledge to handle the proxy log data collected from the library’s main web page, http://library.smu.edu.sg/. Thus, the proxy log data files are often neglected and not used at all. We would like to realize the full potential of this data by first understanding the user behaviour of library’s electronic resources. After which we would aim to understand the relationship between different search queries and how it varies from certain clusters of users. Lastly, we would dive down to the details and examine the event sequence for unique users, in terms of how their search querying ‘journey’ appears.	Group 7 - BJJ Lim Yu Xiang Bendexter Tan Jun Rong Wang Jingxuan	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Li Ka-shing Library
Social Media Analytics	XYZ is an online content creator that focuses on lifestyle stories for Singaporeans. XYZ gives readers trusted information on what to do in and out of their country. It is half editorial based and half community based where Singaporeans can upload their own reviews and share their opinions about everything Singapore.	Group08 - JAR v.IS Albert Bingei Ho Jun Liang Russell Lim Zhi Wei	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	XYZ Web hosting company
Li Ka Shing Library Entry Data Analysis	There are various ways to measure occupancy of the library but the richest source is from the card reader that registered when students tap in and tap out. This provides us with the library entry logs, which include timestamp and basic school information about the student. To better understand the library usage, the management team is interested to know whether there is any cluster for users entering the library that need to be accounted for, and whether the demand can be predicted. Analysis at individual level on entry is an area that has not been worked on much, so there is more scope to explore. New topics such as hogging rate analysis may also be considered.	Group09 - Guardians of the library Ren Mengxi Wang Sijia Wang Tianjing	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Li Ka-shing Library
Predictive Analytic – how business operation drives the desired outcome in business performance	Pharmaceutical Company L is a company focusing on manufacturing products for illnesses such as asthma, cancer, infections, diabetes and mental health that come in the form of medicines, vaccines and other various consumer health products. This project aims to understand the consumer purchasing patterns and behaviour within Singapore and at the same time, evaluate the effectiveness of different sales and marketing strategies within different areas of Singapore.	Group 10 - Kes MY JX Kesmeen Tan Jia Min Matthew Yee Guan Feng Sim Jing Xiang	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Pharmaceutical Company L
Singapore Students Performance Analysis	The Ministry of Education (MOE) collects and analyses data from schools through Singapore to continually improve on their policies and practices in Education which they set for schools in Singapore. However, most of the data from MOE are not publicly available for research and analysis for people who are not working inside MOE. With that limitation, it is hard to gain insights about education in Singapore to make improvements or suggestions to the education system. An alternative for this is through the publicly available data collected by the Organisation for Economic Co-operation and Development (OECD) through the Programme for International Student Assessment (PISA) global education survey. The OECD PISA global education survey is a triennial international survey which aims to evaluate education systems worldwide by testing the skills and knowledge of 15 year old students in math, reading, and science. The survey has become increasingly influential on politicians who see their countries and their policies being measured against these global school league tables. Asian countries continue to dominate, with Singapore rated as the best, replacing Shanghai, which is now part of a combined entry for China.	Group 11 - Team Plus Chermain Ang Gareth Shaun Ng Wei Long Ong QingHua, Jeremy	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)
KST Bikers Feedback Analysis	KST Bikers is attracting a high volume of feedback from people on issues ranging from track conditions to maintenance of KST Bikers’ bicycles. As a result KST Bikers is spending valuable time and resources addressing these feedbacks which could have been utilized in other areas. In order to improve the use of resources, KST Bikers hopes to reduce the volume of feedback by discovering meaningful insights from its feedback data.	Group12-TSK Transporters Lim Ting Zhi Ng Kiat Keng Sanjay Nelagadde	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	KST Bikers
Global Trade Analytics	A British organisation in Singapore oversees the development and maintenance important and longstanding relations between the United Kingdom (UK) and Singapore. As part of this organisation, the Department for International Trade (DIT) manages trade agreements between UK and Singapore, with about 100 British companies gaining a foothold in Singapore yearly. Every year, the DIT plans and reviews marketing campaigns that UK should take, to encourage its businesses to expand into Singapore. Traditionally, decisions made for these marketing campaigns do not refer to existing historical trade data. Instead, these crucial decisions are built merely upon the sentiments of staff within the department or past successful campaigns. Hence, a user-friendly system which displays crucial trade information will be able to provide insights into UK’s current trade patterns with Singapore, allowing the DIT to make informed decisions.	Group 13 - The Trade Crew Christian Earl Prasetyo Chua San Fong Cornelia Tisandinia Larasati Timothy Tan Swee Guang	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Department of International Trade in a British Organisation
Geo-spatial Operational Insights for National Library Board	In this age of information, we see an increasing need for people and businesses to have a greater access to space and resources to further their personal and corporate needs. Hence, there is the requisite for the libraries to adequately manage this associated increasing demand. However, there exists this difficulty in measuring the operational readiness of the libraries; unlike typical corporations and organisations, the measure of public demand is not in dollars and cents. Furthermore, there have been renovations and relocation of existing libraries and unveiling of new libraries to keep up with the times. These constant changes prompt for a reliable system to measure the effectiveness of past policies, as well as an accurate predictive model to conduct what-if analyses for future plans. This project aims to create a user-friendly system which displays geo-spatial information that can provide operational insights for the NLB.	Group14 GAURI BHATNAGAR THAVANESAN S/O SIVANANTHAN WANG TIANTONG	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	National Library Board (NLB)
Making Better Subject Combination Choices for Students	For many Secondary 2 students in Singapore, choosing and selecting a subject combination for the next two years leading to their GCE 'O' Levels Examinations can be a tough decision. It is sometimes difficult for teachers to decide whether or not to encourage or allow students with borderline grades to take on the subject combination of combined science or double science. Often, many parents want and believe that their children are qualified to take on double science combination (or even triple science). Without any analytical evidence, it makes it difficult for teachers to convince parents that the recommended or proposed combination would be the better choice for their child.	Group15 - Edufy Heng Kok Chin Peh Zhan Hao Tan Yong Kiong, Alson	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Edufy Secondary School
Li Ka Shing Library - Mining for Insights from Users’ Database Request Log	The library subscribes to eBook platforms with contents from a range of publishers. These databases provide contents that have largely enriched the library’s resources and make an integral part of the library repository. When a student user requests contents from the databases, the request goes through the library’s proxy server. The proxy server captures a digital trace for each user request, which contains request url, user ID, and user agent. With the aim of providing easy services to users, the management hope to better understand the usage patterns of the databases. The challenge is to programmatically extract the meaningful user inputs within billions of request record, as most records are irrelevant to the project objectives. Our main focus of the project is to understand the usefulness of the library eBook database in fulfilling the student queries. By analysing the proxy trace, we can define the characteristics of the users as well as examining the usage rate of the database. The success rate of the students queries are also part of target findings. Since the dataset is not static, we aim to provide a processing pipeline to help the sponsor in looking for new findings with new enrolled students in the future.	Group16-ADS Alex Lu Ning Dina Heng Li Gwek Song Rui	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Li Ka-shing Library
Relationship Analytics	TrustSphere is a market leader in Relationship Analytics, delivering solutions through Sales Analytics, Risk Analytics and People Analytics. Their goal is to help clients find the value of their associated networks for improving key business challenges such as sales force effectiveness, enterprise-wide collaboration, participation and contribution statistics and corporate governance. Human Resource Analytics is the idea of using data in the organizational context to understand different factors about employees such as their degree of collaboration and influence. Collaboration, being a crucial part of managing an organization is a valuable determinant in understanding how decisions are made and how relations are built. Furthermore, influence can provide a blueprint of the hubs of information flow and effective change in the organization. Through this project, we aim to provide a way of comprehending these factors through deep data analysis and patterns observed in communication interactions (email and instant messaging) of employees.	Group 17 - APA Prekshaa P. Uppin Akshita Dhandhania Aayush Garg	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	TrustSphere
Analysis of Defaulted Medical Appointments	Hospital X is a pioneer tertiary institution that provides a comprehensive range of medical and rehabilitative services for anyone in need. Currently, Hospital X has defaulted or missed appointments rate of about 21% for first visits and 19% for review visits. Defaulted appointments lead to longer appointment lead times, lower operation productivity and overall lower quality of care.	Group18 - ZAN Loh Yan Zoey Mirania Aishwarya Agarwal Nasrullah Bin Khairullah	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Hospital X
IVAD: Interactive Visual Analytical Dashboard for Analysing Wholesales Pharmaceutical Sales Data	Company Z is a medium-sized pharmaceutical product distributor and wholesaler in Singapore who caters to various healthcare institutes and clinics. Effective management of the supply chain and sales strategies is particularly important for Company Z as it deals primarily with large volume and high-value products at a rapid pace. Hence, even the smallest miscalculation in strategic management would result in significant losses. That said, there is huge potential for insights from the wealth of information that can be found in the sales data. Insights generated with contextual knowledge reinforced by managerial experience and the understanding of the industry/business would ensure tangible positive impacts. The aim of this project is to create and design a dashboard using R and Shiny platforms that can meaningfully present its sales performance.	Group19: Protégé Benjamin Kee Melvyn Teo Jia Hao Vivian Lau	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Pharmaceutical Company Z
Pricing Insights of Automotive Industry in US	Automotive Ventures is a start-up based in Atlanta Tech Village, United States. Automotive Ventures aims to be the top market intelligence tool for the automotive market in United States. Automotive Ventures is currently launching CompetitorPro, a competitive intelligence tool that allow dealers to monitor competitors and benchmark performance. It offers a peek into competitors' sales, inventory and turn-time performance and web analytics. Also, it offers pricing tool advising dealers on price to set to stay competitive.	Group20-Automotive Angels Aaron Mak Kang Sheng Janice Low Kai Hui Sherly Cendana Koalitas	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Automotive Ventures, Competitor Pro
Dressabelle Marketing and Merchandising Analytics	Dressabelle is a leading online fast-fashion retailer in Singapore. Having established themselves online since 2012, Dressabelle have also expanded to 6 physical stores in malls around Singapore. Dressabelle set themselves apart with not one but two fresh fashion collection every week. Their fast-paced nature of their merchandising, logistics and marketing has given little room to explore how data could aid their decision process.	Group 21 - CrispyData Hoe Ying Mei Zac Ler Ze Chen Tan Jia Jing	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Dressabelle
Deriving Consumer insights from Data Analysis	Binge is a leading gaming company in Singapore specialising in multiplayer online games. Players in this game start out with a predefined number of troops with the aim of recruiting and strengthening its army. Players can choose to enter a battle with a selected number of troops to destroy “monsters” of varying skills and level. The rewards are then determined by central computer depending on the risks and level differences. If the player wins – that is if the “monsters” surrender, the player can recruit these “monsters” into their army, however, if they lose, there will be no troops returning from battle. Our task in this project is to analyse and profile customers based on their playing style and to understand the behaviours of different players. In addition, we also aim to understand the extent to which media or social media sites that provide advice to players will affect the types of “monsters” and the number of troops players choose to battle with.	Group 22 - RIS≼ Ranya ARORA Sahana Iva RAGHAVAN LEE Ween Jiann	Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)	Binge