ANLY482 AY2017-18 Term 2

From Analytics Practicum
Jump to navigation Jump to search

About

Current Practicums

Past Practicums

Grading & Deliverables

Downloads & FAQ

 
Project Title About the Project Student Member(s) Project Supervisor Sponsor
Eatigo.png
Know-Thy-Deals

Eatigo is an online restaurant reservation platform that serves to optimize restaurant capacity, by offering time-based discounts to manage demand. Operating on the principles of yield management, eatigo tries to help connect "empty tables" with "empty stomachs". Since its launch in 2013, eatigo has built a 2 million subscriber base.
However, despite its presence in markets with strong dining out culture, eatigo's reservation rates remain low. This is because only a small percentage of all the subscribers have ever made a reservation, and even amongst those who have, the number of bookings per month is low.
Our project aims to help increase reservation rates among eatigo subscribers.

Group 01 - sat@eatigo

  • Arushi Himatsingka
  • Shubhangi Agarwal
  • Tanushree Rohera
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) eatigo Pte. Ltd.
Prediction and Test analytics for screening project applications on DonorsChoose.org
DonorsChoose.org empowers public school teachers across the United States by giving them a platform to appeal directly to donors on the web to contribute toward the purchase of resources needed for classroom projects for their students. Through charitable crowdfunding, thousands of these requests are fulfilled each year to help bring classrooms to life.


As the number of project submissions is set to increase, DonorsChoose.org needs to find a way to scale the current screening process so that projects can be reviewed and posted as quickly as possible, while retaining consistency in the vetting process.

Group 02 - Josh & Fried Investigations

Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) DonorsChoose.org
AY2017-18T2 Group03 Team Logo.png

OPTEAMIZATION

Our sponsor is a home-grown supply chain solutions company and leading regional supply chain management partner to a number of the world’s leading brands such as Dell, Motorola, Samsung, LG, Exxon Mobil, Unilever and Heinemann. The company has operations all over Asia Pacific, such as China, the whole of ASEAN, India and Korea and they service various industry segments: Chemicals & Healthcare, Consumers & Retail, Electronics & Technology, E-Commerce and Cold Chain.

A strong advocate for technological and operational innovation, the company advocates productivity and sustainability improvements through interactive solutions so that they can provide their diverse consumer-base from various industry clusters with world-class logistics services. With recent interest in an analytics, the company is now looking towards implementing analytical solutions to help manage their operational processes and improve the efficiency of operations with the help of technology. As technology keeps improving, the company needs to stay ahead of their competition by staying relevant and efficient, so our group aims to help them by improving the operations of one of their clients by implementing a dashboard so that visualisations can be done automatically with minimal work from the operations head so that overtime hours can be better managed.

Group 03

  • Chua Weilun, Ben
  • Tay Jing Ying
  • Russell Yap Song Chen
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) A Singapore-based Supply chain Management Company
Social Media Analytics with New Media Company The company is a local news media and content distribution platform based in Singapore. The company was first started as a spin-off project of 9GAG to generate localized content in 2012. Unlike 9GAG which allows users to upload their self-generated content, or using content taken from other social media platforms, the sponsor produces and uploads its own original content. Their content is centered primarily around memes and issues that are relevant to young Singaporeans.

To capture the interests of a wider audience, content generation is currently based on four strategies: relevance to audience, contains well-articulated stories, first to be published, and being unexpected. As of today, the company has approximately an audience size of 4 million per month across its platforms.

However, the company competes within a rapidly changing social media landscape where trends are short-lasting. It is therefore vital for the company to identify how to swiftly capture new trends and optimize their content for their targeted audience to attain a higher reach. This is relevant as the company's profitability is tied to its ability to effectively capture audience. Our project would strive to fulfill such goals by using analyzing their existing content published on their Facebook and YouTube channel.

Group 04

  • Shaun Au Yong Liang Wei
  • Tan Jieying Jaqueline
  • Karen Koh Li Yin
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) New Media Company
Discovering Complexity Of Online Transactions Using Exploratory And Confirmatory Techniques: A Case Study Of Online Payment Gateway Provider In Singapore

With the growing trend of e-commerce, retailers have begun improving their online retail presence to boost sales and market share. This creates a need for reliable financial intermediaries to facilitate their online transactions.

This research paper aims to study the complexity of the online transactions carried out by our sponsor’s merchants, by gaining a deeper understanding of the transaction data and formulating recommendations to improve future decision-making.

In particular, we hope to assess the performance of the merchants, using number of approved transactions per merchant as a key performance indicator. Due to the different nature of businesses, our merchants vary in number of online transactions. As part of data preparation, we used interactive binning to categorize them.

To compare the performance of each merchants in each bin, we used a hybrid approach, merging characteristics of funnel plots with line of best-fit graphs. These graphs provided a better model fit to visualize merchants falling outside the 95% confidence interval. Such merchants are identified as Star and Laggard merchants. We also established a positive relationship between number of transactions and the number of approved transactions.

We then studied the characteristics of transactions carried out by the identified merchants. We used logistic fit to determine possible correlation between various independent variables and number of approved transactions. For any variable that has correlation, we used decision trees to map the expected approved-to-rejected transaction ratios.

Finally, we present a comprehensive discussion on the insights gained through data exploration. We also provide recommendations on how to set benchmarks for each merchant’s performance and improve the approved-to-rejected transaction ratio for merchants.

Group 05 - Team R2Z

  • Randolph Pang Hsieh Yi
  • Ong Rui Zhi
  • Zachary Loke Kei Yun
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Online Payment Gateway Provider Company
Technical Analysis and Time Series Forecasting of Price Movements for Forex Currency Pairs pH7 is a private investment firm that serve clients who are keen to appreciate their wealth and grow their capital. With its expertise in trading of financial instruments and information analysis capabilities, it provides business solutions that are customised to their clients’ needs. Capitalising on cutting edge technology in their work, pH7 has been excelling in efficiency and professional.


The ability to understand and visualize price movements of foreign exchange rates plays an important role in discovering insights for trading companies. Our client signed up with software companies and deployed their own data collection platforms for storing and accessing the latest exchange rate data to gain some insights on the movements of exchange rates. However, their brokerage provided dashboards do not deliver any combined analysis across more than one technical analysis model. Hence, they are interested to understand trends and price movements of currency pairs using technical analysis to enable them to better forecast and make more informed trade executions for their clients.

Our group will be using technical analysis-Bollinger Bands, RelativeStrengthIndex and Time Series Forecasting- ARIMA method to analyze price movements and provide a form of trading action which they could adopt for USD/JPY currency pair. This would allow them to forecast future trends in the finance market and make more informed decisions in their trade executions.

Group 06

  • Chong Zhi Hao Kevin
  • Lim Yan Ling
  • Tee Yu Xuan
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) pH7 Investment
STP+
Team DHL's client has been transforming worldwide logistics since 1969. From creating the International Air Express Industry, to giving flight to a parcel delivering drone, the client aims to connect people regardless of where they are.


Team Data Heavy Legends(DHL) wants to help its client provide its service in the most efficient manner possible. By developing Ship-to-Profile+ (STP+), an all-inclusive and interactive dashboard which correlates operational performance and ship to profile information, we aim to help our client's Group Account Managers(GAM) team produce higher value for all stakeholders alike, and to assist leaders in making more informed decisions.

DHL LOGO.png

Group 07 - Data Heavy Legends

  • Akshay Nayak
  • Rikin Khanna
  • Shalabh Verma
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) [1]

Indiscriminate Parking of Shared Bicycles in Singapore: Highlighting Operational Implications of Data Quality Issues and Analyzing a bike sharing companyoBike’s Responsiveness via Geospatial Analysis
Beginning their operations in January 2017, oBike is Singapore’s first homegrown stationless smart bicycle-sharing company which uses technology to change how transportation is viewed locally. oBike has bicycles located all over the island, and these bikes have built-in Bluetooth locks to enable one-way first and last mile commuting. This provides a convenient and environmentally friendly commute option for all, especially given Singapore’s compact size and interconnected urban areas. Despite intense competition stemming from other bicycle-sharing companies such as Mobike and OFO, oBike has achieved over one million downloads since its inception. Data has revealed that the company has consistently been at the top in terms of total number of application downloads, earning them the title of “Southeast Asia’s bike-sharing leader.”

However, in recent months, Singapore’s Land and Transport Authority (LTA) has issued new rules and regulations, requiring bicycles to be parked in designated yellow boxes around the islands. LTA enforcers survey the island, and issue tickets to bike-sharing companies in the event where bicycles are found to be illegal parked. From the time a ticket is issued, oBike has a mere four hours to move their illegally-parked bicycles. Failure to do so will incur hefty fines. Consequently, oBike’s current challenge is to manage illegal parking of their bicycles.

Group 08

  • Heng Chai Lin Catherine
  • Pang Jia Hao, Shawn
  • Seah Li Jia Desiree
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) oBike Asia Pte. Ltd.
Fablogo.png
Koi Logistics Analysis

KOI is one of the most well-known bubble tea brands in Singapore, founded in 2006. Despite this, it is facing logistics problems in their daily operations such that employees in different branches have difficulty predicting the right amount of ingredients to order. Moreover, space constraints of each branch is different and have to be taken into consideration, since not every branch can order the same amount of quantity, leading to a steep learning curve for new employees.

Current employees also do not fully understand how much ingredients would be needed during promotional periods of certain products. As such, our project aims to focus on predictive analysis tools along with data provided by KOI to better understand correlations between different factors and sales, helping employees make better informed decisions on how much to order in the future.

Group 09

  • Toh Ling Jing, Angie
  • Phang Shi Jia
  • Ryan Chia Cheng Yu
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) KOI Thé Singapore Pte Ltd

Tennet logo.png

Inventory Analytics for F&B Company

Our sponsor is a food-service organisation that owns and manages various renowned restaurant brands. ABC Company has evolved into different concepts, with further overseas expansion. Under these concepts, the group has a total of 13 outlets in Singapore.

Currently, our sponsor is not able to accurately determine the number of ingredients to order for their chain of restaurants. It is often based on guesswork and gut feeling which has often led to excessive holding costs as well as food wastage and in some cases, shortage of ingredients. This is not ideal as it may lead to various issues such as cost due to the non-freshness of the product, throwing of food due to expiry, not enough space in storage, the inability to satisfy customer demand, etc.

Our main objective is to forecast the weekly number of customers visiting each outlet and to help predict the monthly inventory consumption. With these models, the staff can more accurately gauge the optimal inventory quantity and order quantity and not need to rely on gut feeling from previous experience, as is the existing practice. In summary, our business goal is to ensure accurate and optimal orders to fulfil storage, optimising storage space for each individual outlet.

Group 10 - TenneT

  • Lee Weng Ho Mervyn
  • Ong Ming Hao (Michael)
  • Wee De Rong Bryan
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) ABC Company (Information Withheld)
T.W.O logo nobg.png
Alleviating Operational Costs

Company ABC is a local SME within the logistic sector here in Singapore and is a typical example of a company that is currently facing problems maneuvering through its data to derive operational solutions. More specifically, Company ABC is facing an overarching problem of high operational costs which is primarily caused by un-optimized hiring in the various peak and erroneous filling process, which the team aims to solve through analytical approaches.


The team will be utilizing several key software and libraries, as well as taking into consideration the various limitations pertaining to the data, and ultimately aims to reduce the operational costs of Company ABC. Besides having short-term cost reductions, the company may also benefit from greater employee satisfaction and better brand reputation – which could potentially aid the company in achieving its long-term vision of expanding into other countries.

Group 11 - T.W.O

  • Tan Zheng Hao, Marcus
  • Wu Jianhua
  • Oh Yi Hong
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Logistic Company ABC
ARTistique

ARTistique is a champion of the arts scene in Singapore. It offers a range of arts and cultural programmes and activities and seeks to nurture creative excellence. Through their programmes, ARTisque aims to support broad audience engagement and connect Singaporeans of all ages through the arts.
In supporting the arts scene, ARTistique has managed to quantify the qualitative in conducting a nation wide survey which captures sentiments and participation behaviours amongst Singaporeans. As such, with the initial buy-in towards data, ARTistique is interested in exploring the potential of their databank collection spanning the past decade.

Group 12: Team Flair

  • Aaron Poh Weixin
  • Jia Min Leong
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) ARTistique
OPlytics Logo.png
Developing Human Resource Dashboards: A Case Study of a Logistic Processing Company in Singapore
Logistics Company XYZ is a multinational logistics service provider focusing on packaging, storage and distribution of chemical industry products. As logistic solutions continue to be a driving force in today’s environment, Logistic Company XYZ strives to offer personalized solutions to its companies through in-house developments in advanced logistic and engineering technology. With zero tolerance to delays in order fulfilment, the company prioritizes efficiency and accuracy. To do so, the company is constantly looking for ways to adopt smart technology and centralized systems to improve the performance of its people and processes.

Since many of the company’s processes are inevitably labour and skill intensive, training and human development is a key focus in the company’s business strategy to ensure that its people are ready to handle the changing requirements needed to fulfil processes and orders present in today's competitive environment.

In this project, OP+lytics aims to propose targeted recommendations to minimize delays by investigating causes of delay in order fulfilment in the key processes identified and to address these causes related to the human factor through an analysis of employee training records and order fulfilment history. Lastly, OP+lytics aims to create a dashboard for the company to streamline the training required in its workforce while meeting job demands effectively.

Group 13: OP+lytics

  • Chee Yixin Jerlyn
  • Cheow Wan Ling Taffy Joan
  • Park Jaehyun
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Logistic Company XYZ
Anly4821718T2G14Logo.png

ReDeliver

Logistic Company X is one of the world's greatest global market leader in the logistics industry. Company X commits its expertise in international parcel, express, air and ocean freight, road and rail transportation, contract logistics and international mail services to its customers.

Company X is maintaining two data sets, which retrieved from twp different data warehouses. Data set 1 includes all inbound delivery records while data set 2 focuses mostly on B2C inbound deliveries. The first task from Company X is to combine the two data sets of different formatting into an unified data format. On the other hand, due to the high volume of delivery, Company X has a hard time optimizing the delivery schedule. They want to improve the successful first-time delivery rate in order to improve user experience. A visualized dashboard will be built based on the delivery information. We would also asked to find any trends and patterns that are meaningful to our client.

Group 14

  • Tan Yong Jin
  • Wang Miaoqiong
  • Wu Wei
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Logistic Company X
A Comparative Study on Visualization Platforms for the Dashboard Design of a Fast-Moving Consumer Goods Company in Singapore Data visualization software is a powerful analytical tool. With the necessary data, an ideal set of visualizations helps businesses better understand their strengths, weaknesses, and performance against competitors, and make quicker and more effective business decisions. As a project team, we aim to improve our client’s data processing and analytics methods to improve their efficiency, provide clearer and more dynamic visualizations, and allow them to make improved marketing decisions.


Group 15

  • Amanda Lim Hui Wen
  • Cliff Halim Tirtamaya
  • Yorisan Khosugi
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) [Company X]

Group 16 Logo.jpg

Assessing success factors and impact of VWO A's programmes

As one of the biggest and most recognizable Voluntary Welfare Organisation VWOs in Singapore, our sponsor prides itself on being at the forefront of social innovation in the VWO landscape, with their programmes being fully subscribed to by organizations and individuals. Despite having a large reach across different target communities, they have not been able to accurately identify if they have truly made an impact on their beneficiaries, or their key success factors in their programmes. Hence, our project looks at their volunteer force, in order to see whether the beneficiaries are being adequately served.

Group 16 - Village People

  • HON Liang Yi
  • Jonathan Eduard Chua LIM
  • Nur Amirah Binte SAHROM
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Voluntary Welfare Organisation (VWO) in Singapore
Behavioral analysis of users from Database Request Log

With over 250 000 e-books provided by both Lee Ka Shing (LKS) library and Kwa Geok Choo (KGC) law library through the web service at library.smu.edu.sg, SMU library provide an array of collections to cater to support teaching and research across the multiple schools and faculties. Currently, SMU library purchases e-books on certain databases through the Patron Driven Acquisition (PDA) scheme. The PDA scheme allows SMU library to list e-books that are not yet purchased as “available” to SMU community. These e-books are subsequently automatically purchase upon meeting some trigger points when access by the SMU community. At the moment, it has been highlighted that some e-book purchases are triggered by a single unique user due to repeated access. As a result, it diminishes the effective use of PDA funds as the e-books are not widely used across SMU community.

We aim to derive actionable insights from the data based on the behavioural patterns of users and understand the extent of effectiveness that PDA provides in meeting the needs of SMU community.

Group 17

  • Gan Wen Xuan Damien
  • Lewis Poh Yu Gui
  • Louis Tan Kai Huang
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) SMU Library
TeamDAcctnew.png Using Multiple Linear Regression to Analyse Factors Affecting Costs Incurred for Cleaning Projects: A Case Study of a Cleaning and Conservancy Company in Singapore LS 2 Services Pte Ltd is a local cleaning and conservancy company that provides building cleaning services, landscape care and maintenance services activities in Singapore. For each prospective project site, costs incurred is estimated before tender is submitted. Expected costs incurred for each project has always been estimated based on the experience and professional judgement of its top management. However, such a method is not sufficient in cost-estimation as seen from several instances of loss-making projects. In this paper, we use multiple linear regression to build an explanatory model to find out what affects the various cost components incurred for conservancy project types. Explanatory variables such as dwelling units and commercial units converted to Equivalent Dwelling Units (EDU) are derived from identifying the facility descriptions of various project sites. The model being built for each cost component will help identify key possible cost drivers, as well as analyse whether an increase in any of the explanatory variables determined has an impact on manpower headcount as a cost driver.

Group 18 - Team DAcct

  • Low Zhen Qing Jonathan
  • Mok Ping Yan Soma
  • Song Yea Ram
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) LS 2 Services Pte. Ltd.
G19 Logo.png
Library Course Reserve Materials Usage Analysis
This project aims to analyze the usage volume, usage patterns and usage ratio of these course reserve materials over a period of time, and ultimately, be able to provide them insights into their collection policy.

Group 19 - LKS Bookbusters

  • Joanne Ong Shi Ying
  • Koh Wei De John
  • Rachel Tay
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Li Ka Shing Library
Team20 Logo.jpg
Team MaxiMuM
We aim to optimise the online and offline resource availability in the library to maximise the learning effectiveness of SMU students. We further aim to analyse if usage patterns vary between students based on certain attributes like Programme, Year of Graduation and Education Level. This will help in develop actionable insights to alter current training and workshop methodology, search results on keywords and distributions channels of this content.

Group 20 - MaxiMuM

  • Mohammed Lukman Bin Mohamed Syed
  • Mahima Damani
  • Manisha Goyal
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) SMU Libraries Analytics and Research Department
AY1718 T2 Group21 Logo.png
Web Analytics for a Children's Education Company
Brainsmith is a children’s education company based in India that designs and delivers premium educational, learning products and content for early childhood learning and healthy brain development. Their products are targeted at families of higher economic standing with young children and besides having their own website to sell their goods and display their catalogue, they sell their products on various online e-commerce merchants and engages in digital marketing. Brainsmith has been operating for over a year but have conversion rates that are lower the industry average. With the data provided, we plan to use text analysis to identify incoming traffic patterns and clustering analysis to understand the customers’ navigation patterns on the website that leads to either purchases or exiting the website.

Group 21 - Shiksha

  • Poh Wen Jie
  • Prajval Jhunjhunwala
  • Wang Weiting Eunice
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Children's Education Company
Freight Data Analysis

This project aims to study into a critical factor behind XXX’s success as a freight transportation service provider: the price of its corporate shipping contracts. Contract bidding refers to the process of XXX submitting a tender to secure a corporate contract in order to provide its freight services to a company. To secure its shipping contracts, XXX has to go through several bidding rounds with competitors, which include major players such as UPS, Fedex and other companies in the same region. By discovering insights into the factors affecting the bidding price for its shipping contracts, this better allows XXX to understand the thought process and motivation behind the bidding results of its customers, across various industries as well as different countries, and potentially better prepares them for negotiation with their customers for future contract bidding rounds by offering better terms which are of greater concern specifically for different types of customers, thus enabling them to have a higher chance of earning contracts and reaping more profits.

Group 22 - Freighters

  • Teo Pei Sheng Nicholas
  • Zhang Qian
  • Dong Ruiyan
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) XXX


Analysis on Medical Escort Transport Scheme

Our Sponsor provides programmes and services for the elderly and the sick, families, persons with disabilities, and children.

Our project focuses on their Medical Escort Transport (MET) service, which aims to transport homebound elders who are unable to attend medical appointments/treatments on their own and have no suitable or available caregiver to take them to their medical appointment/treatments. Despite being a meaningful initiative, the MET service currently faces profitability issues. Our project hopes to reduce operational costs and improve its efficiency so as to allow them to gain healthy surpluses.

Group 23 - Silver Daisies

  • Carol Chong Siew Fang
  • Loh Xiaoyou
  • Tham Hin
Prof. Kam Tin Seong

Associate Professor of Information Systems (Practice)

XXX Medical Escort Transportation Provider
REOLogo.png
REO
REO is a leading property portal and geo-spatial search engine for Singapore properties through connecting demand and supply side of property market. REO has a subscription based model for commercial users to post and manage their property listings on their portal so its revenue is heavily reliant on its subscribers. To capture the growing demand and supply of the property market, REO needs to fully utilize its vast amount of collected data to increase engagement with its subscribers (commercial users). Our project would focus on analysing the data to increase engagement and creating visualisations to allow the staff to easily comprehend the data

Group 24

  • Liam Pang Shi Liang
  • Ong Geok Ting
  • Tan Rui Feng
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Real Estate Online (REO)
[Sanitised]
ChopeLogo.png
Improving Chope’s marketing campaigns through data analysis
Chope is a Singapore-based restaurant reservation platform which connects diners to restaurants in real-time. In the past, restaurant reservations had to be made through phone calls, which could only be done during operating hours. Chope allows users to make instant reservations with zero booking or cancellation fees, with most of its revenue generated by charging restaurants fixed and per-diner fees for the use of its reservation system. With ambitions of becoming the dominant player in the region, Chope has been rapidly expanding in recent years and now serves over 2000 restaurants in Singapore, Hong Kong, Shanghai, Beijing, Jakarta and Bangkok.

Most of the restaurant reservations on the Chope system are done via its website. Hence, the marketing channel utilised most by Chope is its Electronic Direct Mailer (EDM) to its user base, featuring content such as promotional deals, new restaurant additions and curated lists. As consumers have very varied preferences in the Food and Beverages industry, Chope hopes to improve the effectiveness of its EDM campaigns through better segmentation and personalisation with the help of analytical tools, which they believe would result in an increase in the number of reservations per user from the existing user base, translating directly to more revenue being generated.

Group 25

  • Au Zhe Wei Jonathan
  • Ng Bing Yao Manfred
  • Yak Sze Hao
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) The Chope Group Pte. Ltd.
DataDiversLogo.png
Geospatial Analysis for Branch Location Optimization
PQR is a Singapore based company with over 100 branches spread across Singapore as well as a growing online presence. They have a pronounced focused on providing aid to the community. Their employees are committed to helping the community albeit the elderly, challenged youth or the environment. The company itself, contributes over 60% of their profits to the betterment of the community each year.

PQR has been facing a road block while deciding locations for their upcoming branches. They have conquered central Singapore and need a smarter method to filter out their possibilities. Our project will use location based data and find its relationship with the financial performance of PQR branches all over Singapore. Using this, we aim to find the optimal weightage of variables to supply them the company with, in order to find a location that is most in line with the client’s goals.

Group 26 - Data Divers

  • Shraddha Ramesh
  • Vani Sound
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Company PQR
Effective Dashboard Design for Business Decisions: A Case Study on Air Freight Business Company X is the largest logistics firm in the industry today and they currently operate in over 220 countries and regions. Their large size and global presence have allowed them to forge many corporate accounts with other companies. In this project, we will be focusing on the analysis of air freight data of a particular account with Company X. Effective account management is vital in ensuring optimal service level provided by Company X and customer satisfaction. Despite having numerous datasets, Company X faces issues like tracking operational performance, forecasting shipment volume and spotting trends.By using Power BI, we will build an interactive dashboard to analyse commercial performance. Subsequently, these insights will be used by Company X monitor an account’s shipment behavior, conduct meaningful conversations with customers and better plan their capacity for peak seasons.

Group 27 - KJS

  • Sonea Kribaraja
  • Chew Pei En Jozanne
  • Kanchen Kummar
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Company X
21 JMP logo.jpg
Analysis of Southeast Asian Hub Ports
The Straits of Malacca are one of the world’s most important trade corridors and transshipment regions, accounting for one quarter of the world’s transshipments. Furthermore, the ASEAN region is one of the fastest growing marine trade routes, as it includes many countries with developed and developing maritime infrastructure. There are 3 important ports in the Strait of Malacca, Port of Singapore, Port Klang and Port Tanjong Pelepas. Our sponsor, operates port of Singapore, one of the world’s largest ports.

Expanding a port’s capacity requires a large capital outlay. Furthermore, Singapore incurs a high opportunity cost due to its landmass constraints. Therefore, capacity planning is important to ensure that the port achieves a high utilization rate and maximizes its profit potential.

Through this study, we hope to gain insights into the operation of these ports, and then use their respective strengths and weaknesses to formulate relevant operational strategies.

Group 28 - 21 JMP SPREADSHEET

  • Abhyudit Dev
  • Fabian Lim Wei Xuan
  • Meher Gulati
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) PSA Corporation Limited
Byte Syzed
Byteszed-new-logo.png
Our project sponsor, Erumpere, is a private company that aims to provide meaningful experiences to young children, between 4 to 12 years old. As the company grows, they have faced difficulties in managing their programmes and have had instances where there were too many camps that have been slotted in a week, which causes them to reschedule the programmes on another day because they did not have enough instructors to spread during that instance. The problem also extends to allocation of resources whereby there are insufficient resources and last minute problems that arise due to the lack of a proper management system to forecast the demands of the programmes.

Group 29 - Byte Syzed

  • Edwin Peter
  • Abdul Shafiq Bin Mohd Yussaini
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Erumpere
APex Logo.PNG

APex

XYZ Web hosting company is an independent media publisher that focuses on travel and lifestyle stories for Singaporeans. They give locals trusted hyper-local information on what to do in and out of their country. This is done through their website, YouTube channel, Facebook page and Instagram. Their website is one part editorial based and one part community based where members can upload their own reviews and have their say about everything Singapore. Today, XYZ Web hosting company reaches over 3 million Singaporeans each month.

Our group aims to synthesize data from multiple platforms such as Facebook, Instagram, Youtube and blogs to deliver coherent and strategic insights for XYZ to improve their social media outreach as well as plan for content creation.

Group30 - APex

  • Eric Yeo Pu Zhong
  • Ivan Tan Yong Siang
  • Tang Shing Hei
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) XYZ Web hosting company
Bannernew.png

Team Pedal On

Our sponsor is Singapore's first homegrown stationless smart bikesharing company which uses technology to change how transportation is viewed locally. It allows commuters to travel during one-way first and last mile commuting – via bicycles located all over the island. As the use of smart bike sharing becomes more prevalent, the number of indiscriminate parking is on the uprise too. There has been many notifications and fines issued by authorities like Land Transport Authority (LTA), Town Council and NParks regarding bike users not parking within the marked out yellow box.

The project objective(s):
1. To identify where and when, indiscriminate parking is likely to occur so as to better manage the bikes before reports are made by citizens and government agencies.

2. Focus on a specific area in Singapore to see how better optimization can be done on the allocation of bikes.

Group 31

  • Chia Chek Wei
  • Lim Ching Ye
  • Lim Yee Khang
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Bike-sharing Company
Pharma G Logo.png

Interactive Visual Analytical Dashboard

Pharma G is among the world's leading pharmaceutical firms manufacturing products for illnesses such as asthma, infections epilepsy and bipolar disorder in the form of medicines, vaccines and other various consumer health products.

With close to 100 brands of different medications under their belt and clients from the various medical sectors, it is an enormous challenge for anyone to monitor the performance of the sales of these products. Our sponsor wishes to be able to view and analyze the performance of her sales teams in order to provide a succinct business report to upper management.

Hence, this project aims to help the business better understand how the business has performed using an interactive data visualization dashboard.

Group 32

  • Cheng Zheng Yang
  • Lee Mei Huey Pauline
  • Louis Reinaldo Raharja Hadiatmajaya
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Pharmaceutical Company G