ANLY482 AY2016-17 Term 2
|
|
|
|
|
|
| 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. |
|
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
|
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
|
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
|
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
|
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. |
Group06 - Enigma
|
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
|
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
|
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
|
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
|
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.
|
Group 11 - Team Plus
|
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
|
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. |
Group 13 - The Trade Crew
|
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
|
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
|
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
|
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
|
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
|
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. |
|
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
|
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
|
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≼
|
Prof. Kam Tin Seong
Associate Professor of Information Systems (Practice) |
Binge |
