Render 2016 Photo of Analytics
Analytics
Photo of Youth Happiness Index
Youth Happiness Index
  • Slider Image
    Chow Yun Ni
  • Slider Image
    Tan Hui Ru
  • Slider Image
    Fan Sau Ching
  • Slider Image
    Zhang Kai An
  • Slider Image
    Tan Zheng Jie

Youth Happiness Index

Analytics

Course & option:
Diploma in Business Information Technology

Project Title:
Youth Happiness Index

Team Members:
Chow Yun Ni, Tan Hui Ru, Fan Sauching, Zhang Kaian, Tan Zheng Jie

Supervisor:
Ms Dora Chua

Background:
Our client for the project is Starhub. Starhub is a telecommunications company which established in year 2000. They offer a full range of information, communications and entertainment services for both consumer and corporate markets. Beside this, they also manage island wide network that delivers multi-channel. This includes HDTV, Internet TV and on demand services.

Description:
This project aims to answer the question “What makes Singapore youths happy?” by gathering the social media conversations of Singapore youths and analyzing them to find out what are the things they talk about that make them happy. By examining what youths say on social media, the project hopes to form an understanding of what are the activities that brings youths happiness, where are the places they like to hang out to be happy and so on. At the end of the project, we will be able to picture a map of the ‘happy places’ in Singapore as well as understanding how and what makes Singapore youths happy through a series of infographics.

Technology Used:
In order to achieve our objectives, there are 2 kinds of tools will be needed. Tools that help us to collect, organize, and analyze our data and tools that help us to present our findings. We will be mainly using ‘Social Express’, a professional social media tool, with the aid of other tools like ‘hashtagify’ and ‘#tagboard’ to work on our research findings. Photoshop and Illustrator will be using for visual design of the infographics. The ‘happy places’ map will be created by ‘Esri Map with Office’, this geospatial application allows us to plot out our research findings on a map and thus present our findings in a more engaging and visual way.

Potential Opportunities:
With the deliverables of this project, our client could publish the map and infographics to gain youth’s attention and loyalty. They could also use our findings to come out with promotions or business strategies in different area to cater to youth. This project could help our client in increasing the market share among the younger generations in Singapore.

Photo of Yotata (Big Data)
Yotata (Big Data)
  • Slider Image
    Low Jian Hui Samuel
  • Slider Image
    Teo Eng Siang
  • Slider Image
    Teo Wei Chen
  • Slider Image
    Song Jie Ying
  • Slider Image
    Song Gek Peng

Yotata (Big Data)

Analytics

Course & option:
Diploma in Information Technology

Project Title:
Yotata (Big Data)

Team Members:
Low Jian Hui Samuel, Teo Eng Siang, Teo Wei Chen, Song Jie Ying, Song Gek Peng

Supervisor:
Mr Karl Kwan (karlkwan@sp.edu.sg)

Technology Used:
Linux, VMWare, NetBeans, Citrix Receiver, Shell Scripting

Background:
Hadoop is an open source software framework for storing data and running applications on clusters of commodity hardware. It provides massive storage for any kind of data, enormous processing power and the ability to handle virtually limitless concurrent tasks or jobs. Hence, our project is to educate others on the usage of Hadoop.

Description:
Hadoop makes it possible to run applications on systems with thousands of nodes involving thousands of terabytes. Its distributed file system facilitates rapid data transfer rates among nodes and allows the system to continue operating uninterrupted in case of a node failure. This approach lowers the risk of catastrophic system failure, even if a significant number of nodes become inoperative.

Potential Opportunities:
Hadoop can be a useful framework to lower the risk of system failure.  We have taken advantage of its enormous processing power and massive storage to build a system where Hadoop can be used to show off its abilities. A system where users are able to compare between multiple targets. By using the enormous processing power and its ability to store massive data, it can source and compile data to see which target is better.

Photo of Travel Sentiments 15/16
Travel Sentiments 15/16
  • Slider Image
    Shrinithah Sugumar
  • Slider Image
    Nicholas Yu
  • Slider Image
    Ahsika Banu
  • Slider Image
    Muhammad Fazseril

Travel Sentiments 15/16

Analytics

Course & option:
Diploma in Business Information Technology

Project Title:
Travel Sentiments 15/16

Team Members:
Shrinithah Sugumar, Nicholas Yu, Nicholas Sim, Ahsika Banu, Dillon Neo, Muhammad Fazseril

Supervisor:
Miss Dora Chua

Technology Used:
Adobe Photoshop, Premiere Pro, Illustrator, Social Express, TwitterFall, Gramfeed, Microsoft Excel, Microsoft Word, Microsoft Powerpoint

Background:
Travelling has been common for Singaporeans of the 21st century. Many Singaporeans turn to social media to assist them in planning their future travels. Some of what they refer to would be travel agency websites, Facebook posts by family and friends, Instagram posts by friends, blog posts by other Singaporeans who have travelled to the particular countries or the news where they are updated on the latest happenings of the country they wish to travel to. Most of the Singaporean travelers are youths who have just graduated or families who wish to travel during the school holidays. This project is to assist Singaporean youths, families and travelers to decide on which are the most travelled and Instagrammed places overseas.

Description:
This objective allowed us to propose the solution of an article showing the top 5
Instagrammed travel destinations by Singapore Youths. The second objective of the project is to create a website where users are able to view the top travelled places by Singaporeans. Through this project, we will be able to use various social media analytic tools as well as social media platforms to assist us in our findings and final deliverables of an article on Starhub community, a website and an infographic displaying the findings and results.

Photo of SPCA Rescue Application
SPCA Rescue Application
  • Slider Image
    Ong Shao Zong Alvin
  • Slider Image
    Lukas Tham Wei Jie
  • Slider Image
    Sew Wei Jian
  • Slider Image
    Bryan Tay
  • Slider Image
    Lim Jing Wen

SPCA Rescue Application

Analytics

Course & option:
Diploma in Business Information Technology

Project Title:
SPCA Rescue Application

Team Members:
Ong Shao Zong Alvin, Lukas Tham Wei Jie, Sew Wei Jian, Bryan Tay, Lim Jing Wen

Supervisor:
Ms Sophie Koh

Technology Used:
iSentia’s Brandtology, SPSS Text Mining, Android Studio, Appery.io Database, Eclipse

Background:
To provide a platform to the public to report to the SPCA about an injured/lost domestic animals at
the shortest period of time.

Description:
The objective of this project is to increase awareness to the members of the public regarding
SPCA and their services because we feel that many people are still unaware about SPCA and
also have a big misconception towards SPCA’s services as they feel that they will put their
sheltered animals to sleep. From this project that we have done, we hope that it would be able to
change the negative perception of members of the public towards the SPCA.

We would also like to improve the current rescue services that SPCA provide because we feel that
there are still a lot of animals that needs help for rescue. However, most of them are left ignored
instead of being rescued by the members of the public. Therefore, we would like to improve the
efficiency of the current rescue services that SPCA provide through the mobile application service
that we are going to produce.

Potential Opportunities:
Our group would like to expand this mobile application in the future to other animal organizations
in Singapore such as SOSD Dog Rescue & Cat welfare Society etc. If there are more rescue
organizations that are willing to participate in the rescue application programs, the members of the
public would be able to choose to report the cases to their preferred animal welfare organizations.
Hence, this will result in more and more animals that will be rescued in Singapore.
 

 

Photo of Shopping Mall Analytics
Shopping Mall Analytics
  • Slider Image
    Gerald Tay Wen Hao
  • Slider Image
    Tricia Lim Xin Yen
  • Slider Image
    Darren Loo RuiXiang
  • Slider Image
    Lim Xing Wei

Shopping Mall Analytics

Analytics

Course & option:
Diploma in Business Information Technology

Project Title:
Shopping Mall Analytics

Team Members:
Gerald Tay Wen Hao, Tricia Lim Xin Yen, Darren Loo RuiXiang, Lim Xing Wei, Hector Poh Tze Ren

Supervisor:
Mrs Tan Teck June

Technology Used:
Adobe Photoshop, Adobe Dreamweaver , Netbeans, SAS, MSQL, Powtoons, Rawshots

Background:
Apart from the budget as well as the scope of the events, another important aspect of any shopping mall events is also the venue. So we decided to make it into a web application to help event planners to make their events hit greater height by enabling the event planners to input variables they want to filter in our datasets which includes Point of Interest defined as list of shop or stores, or even the mall’s demographics. On top of that, they will also be able to view the sentiments of the mall so as to see what others are talking about through Social Media. With that, it helps the event planners to reach out to their target audience even better and also garner more impact.

Description:
Using data on mall footfall information, shops and also social media listening regarding the mall, Elytis analyse specific chosen category and event type to provide the idea period that the event is to be held alongside with the malls around the chosen mall. This will be done on our website application where they will be able to select their chosen variable to filter out what they need and hence make better judgment. They are also able to make use of Social Media and view what others are talking about in the mall. The project will be completed by the first quarter of 2016.

Potential Opportunities:
Potentials of Elytics is that it can be used by various event planning companies locally so that they would know and understand the trends and therefore make wise decisions as to when to organise a certain event for a certain crowd. That way, it will help in making efficient planning in events and further increase more collaboration with the shopping malls reach their intended audience and impact. If successful, Elytics would also venture abroad to international.

Photo of Postal Finder
Postal Finder
  • Slider Image
    Winson Ee
  • Slider Image
    Alvin Loh
  • Slider Image
    Wong Kin Hou
  • Slider Image
    Chua Yew Fong
  • Slider Image
    Hao Hai Yang

Postal Finder

Analytics

Course & option:
Diploma in Business Information Technology

Project Title:
Postal Finder

Team Members:
Winson Ee, Alvin Loh, Wong Kin Hou, Chua Yew Fong, Hao Hai Yang

Supervisor:
Ms Tan Teck June

Technology Used:
Tableau, SPSS Modeler, Adobe Photoshop, Adobe Illustrator, Powtoons, Android Studios, R Studios

Background:
Our group has decided to look into the many concerns Home Buyers face when looking for their ideal home. The main reason why Home Buyers have such a huge difficulty in choosing a Home is mostly due to location, pricing and sometimes population density. Fortunately we found a solution to make the process of choosing a housing location a lot easier.

Description:
To answer to this problem, we have decided to come up with a matrix and algorithm to assists Home Buyers. This solution will help users determine the most suitable locations based on 3 major considerations; Facilities, Pricing and Population.

Using an API from Quantum Inventions and other outsourced datasets, we have built multiple visualisations with Tableau and SPSS Modeler. A detailed analysis will then be made to improve our concept on our location sourcing algorithm. Finally we have integrated our refined matrix into our mobile application as an interactive platform for modelling.

Potential Opportunities:
Our solution can be distributed to Housing Agencies or integrated into existing Property Mobile Applications such as Property Guru and ST Properties.
 

 

Photo of Healthy Eating
Healthy Eating
  • Slider Image
    Ho Yi Ling
  • Slider Image
    Goh Zhen Fang
  • Slider Image
    Lai Pau Yeen
  • Slider Image
    Liu Zhang Qiang
  • Slider Image
    Xu Guo

Healthy Eating

Analytics

Course & option:
Diploma in Business Information Technology

Project Title:
Healthy Eating

Team Members:
Ho Yi Ling, Goh Zhen Fang, Lai Pau Yeen, Liu Zhang Qiang, Xu Guo

Supervisor:
Mr Tan Chee Seong

Technology Used:
Social Express

Background:
The project we are doing on is ‘Healthy Eating’. With Singapore’s Food and Beverage (F&B) industry having a worth of $3.6 Billion, our client, iSentia Brandtology, is interested in looking into it. Thus, for our project, we will be tying the F&B insights to Healthy Lifestyle Trends and finding out the public’s perceptions towards Healthy and unhealthy Foods with relates to Healthy Eating. Healthy Eating has become a big deal where there is an emerging trend that is happening in the market place, bringing about a shift in consumers’ daily food choices. Hence, we will be looking into the rising issue of Healthy Eating in Singapore, to find out if Singaporeans are adopting Healthy Eating habits with the on-going emerging trend. With iSentia Brandtology’s Social Media Listening Tool, Social Express, we will listen to consumers’ conversations online and extract invaluable insights with the input of useful keywords and appropriate channels. We will be monitoring for a period of 7 months, from 1st February to 1st August.

Description:
Under the monitoring period of 7 months, we will be completing the following tasks:
• Manual Scanning for each of the 4 hypotheses (preferably daily)
• Updating the relevant data into the excel spreadsheets for all 4 hypotheses
• Infographics for the 4 hypotheses
• 5 Reports – 1 for general, 4 for the 4 hypotheses
• Video production
• Poster Design
• Project Management Gantt Chart
We thought of our own Table of Contents in the 5 reports to prove our hypotheses.*

We have assigned different tasks based on everyone’s skill sets.
Analytical (Reports) – Yi Ling and Zhen Fang
Design (Infographics) – Pau Yeen
IT (Presentation – Website) – Zhang Qiang and Xu Guo
We believe that assigning the tasks that best fit each member’s individual skills, we are able to make the best out of it and be very focused on our project objectives.

Whether you’re a student looking to ask questions about school assignments, polytechnic or university modules, and career advices or simply looking to connect to brainy peers on our platform, this mobile application is the perfect platform!

Potential Opportunities:
This Final Year Project (FYP) that we are currently taking is not just a module alone, but a learning process which allows us to gain much experience. We are able to utilise all skills gained throughout our years in Singapore Polytechnic, Business Information Technology, and applying it in our FYP of Social Media Analytics, collaborating with iSentia Brandtology on the topic ‘Healthy Eating’. We hope that through our FYP, we are able to showcase our client, iSentia Brandtology’s capabilities with the use of their technology (i.e. Social Express) in simulating findings to show the possibilities in the Food and Beverage Industry.

 

Photo of Customer Analytics for Telcos
Customer Analytics for Telcos
  • Slider Image
    Kelvin Ng
  • Slider Image
    Lee Zheng Yu
  • Slider Image
    Adriel Lam
  • Slider Image
    Lim Chee Xiong

Customer Analytics for Telcos

Analytics

Course & option:
Diploma in Business Information Technology

Project Title: 
Customer Analytics for Telcos

Team Members:
Lee Zheng Yu(Leader), Adriel Lam(Assistant Leader), Lim Chee Xiong, Kelvin Ng
Not in photo: Ignatius Lim

Supervisor:
Mrs Tan Teck June (june@sp.edu.sg)

Technology Used:
Qlikview, IBM SPSS Modeller version 16, Netbeans IDE, phpMyAdmin, Adobe Photoshop & After Effects

Background:
The telecommunication industry operates in an oligopoly market structure. Having only a few firms competing against each other results in aggressive competition between them. Each wanting to attract as much customers as it can. Hence, retaining customers and having a larger customer base will translate to higher revenues and improved profitability. However, with attractive benefits that competitors offer, retaining the right customers might prove to be a challenging process to handle.

Description:
Telecommunication companies face intense pressure from its customers and government agencies to deliver the fastest possible networks whilst dealing with many other aspects such as customer retention whilst upholding a good reputation to their customers.

Retaining existing valuable customers is a vital aspect to ensuring growth and sustainability. Targeting the right customers to offer incentives to is never an easy task. However, for our project, we focus on making this process simple for our users. Utilizing customer analytics, we analyse big data from telecommunication companies using powerful software. Our solution encompasses the use of Qlikview and IBM SPSS that will give company the power to identify trends, gain a better understanding of their customer’s behaviour and provide the right recommendations that will help their c-level customers and marketing teams make better decisions.

By simplifying the selection process of retaining the right customers who brings value to their company, telcos can now focus their efforts to other key aspects of running a telco.

Potential Opportunities:
Our solution offers exciting opportunities for telcos to maximise profits and streamline operations by making better decisions with analytics.
 
 

 

 

Photo of Churn and Segmentation Analysis
Churn and Segmentation Analysis
  • Slider Image
    Clara Chan
  • Slider Image
    Jasmine Goh
  • Slider Image
    Desmond Tay
  • Slider Image
    Lim Shi Pei
  • Slider Image
    Li Yi

Churn and Segmentation Analysis

Analytics

Course & option:
Diploma in Business Information Technology

Project Title: 
Churn and Segmentation Analysis on Telecommunication Company

Team Members: 
Clara Chan, Jasmine Goh, Desmond Tay, Lim Shi Pei, Li Yi

Supervisor:
Mr Chanon(c_k@sp.edu.sg)

Categories:
Social Media and Analytics

Technology Used
Qlikview, SPSS, Netbeans, MySQL
After Effects, Adobe Illustrator, Photoshop

Background
In the telecommunication sector, telecommunication companies are losing customers everyday. The purpose of this project is to utilise our analytic skills in order to develop and present factual solutions that will help a telecommunication company to make better decisions based on the data set given to us.

Description
We analysed one of Malaysia’s telecommunication company data sets. We have to understand the market industry of the telecommunication sector and the customers. Research found out that the cost of retaining one existing customer is equal to the price of gaining a new one. Also,we have to understand our data set and take note of those which are useful to us in finding reasons of why customer churned.

We started off with data preparation in order to make our data cleaner and neater for analysis. We removed unwanted values and missing values from the data set that we want to use.

Using Qlikview, we generated graphs of findings in order to get insights of the data which help us to understand better of the data.

Following on will be our predictive model, we used SPSS to see the trends, patterns or relationships that led to customer churned. A decision tree is generated and it listed possible outcomes of what we are predicting, therefore acting like a supporting tool for the decision maker to make the best decision for the company.

With that, we build a telecommunication website for the company in order to improve their services and have better chance of retaining their customers. There is two sides of the website which is an administration portal and a customer portal. An administrator can use the website to set up offers for different groups of customers, such as based on whether they are in the list of being a potential churning customer (found out using the analyses done in the previous processes). A customer can use the website to view their bills, usage details, view offers and accept them if is churning customer, and more.

Potential Opportunities
Telecommunication company can get to retain existing customers and gain new ones that will help them minimise losses and maximise profits.

Photo of Big Data Reference Implementation with Hadoop
Big Data Reference Implementation with Hadoop
  • Slider Image
    Tay Dao Song
  • Slider Image
    Benedict Wong Sze Lun
  • Slider Image
    Ang Jin Chuen Eugene
  • Slider Image
    Sibelle Heng Gin Ying
  • Slider Image
    Tang Mingxian Jonathan

Big Data Reference Implementation with Hadoop

Analytics

Course & option:
Diploma In Information Technology

Project Title:
Big Data Reference Implementation with Hadoop

Team Members:
Tay Dao Song, Benedict Wong Sze Lun, Ang Jin Chuen Eugene, Sibelle Heng Gin Ying, Tang Mingxian Jonathan

Supervisor:
Mr Karl Kwan (KarlKwan@sp.edu.sg)

Technology Used:
Hadoop, Linux, Unix, Java, Python, MYSQL, D3.js

Background:
Build a Big Data Query reference model at DMIT Cloud for Teaching and Learning Purposes

Description:
To allow users to find out and explore about the available Post-Secondary Education in Singapore using BigData and MapReduce from Hadoop. It will calculate and MapReduce based on what the users have input to search and output the results by showing it on the Data Visualization (D3.JS) chart. This application will extract data from Facebook.

Potential Opportunities:
With the help of this application Secondary School student will be able to perform a filtering and comparison to find out more about the various Post-Secondary Education in Singapore through viewing graph and comments based on what they have search for.