Difference between revisions of "ANLY482 AY2016-17 Term 1"

From Analytics Practicum
Jump to navigation Jump to search
 
(46 intermediate revisions by 12 users not shown)
Line 14: Line 14:
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; border-bottom:7px solid #6AD9D3; background:#000000; text-align:center;" width="20%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; border-bottom:7px solid #6AD9D3; background:#000000; text-align:center;" width="20%" |  
 
;
 
;
[[ANLY482_AY2015-16_Potential_Projects: Project Up For Grabs| <font color="#FFFFFF">Projects Up For Grabs!</font>]]
+
[[ANLY482_AY2016-17_T1_Potential_Projects: Project Up For Grabs| <font color="#FFFFFF">Projects Up For Grabs!</font>]]
  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; border-bottom:7px solid #1B338F; background:#000000; text-align:center;" width="20%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; border-bottom:7px solid #1B338F; background:#000000; text-align:center;" width="20%" |  
Line 40: Line 40:
 
<tr>
 
<tr>
  
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY1516_G1_Team_Skulptors Optimizing Warehouse Processing]</td>
+
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2017-18_T1_Group1 XXX1]</td>
<td>The practicum’s project sponsor is a supply chain and logistics company. Currently, its warehouse data are not being utilized. By providing its warehouse data (inbound and outbound) transactions to the team, the sponsors would like the team to create a dashboard to help solve 3 main issues. Firstly, to help sponsor categorize warehouse SKUs into ABC categories (each category refers to how fast the goods move) to facilitate optimizing storage of SKUs in warehouse. Secondly, to provide employees with a high level visualization of the SKUs movement into, within, and out of the warehouse. Lastly, to analyze and suggest possible alternatives to improve the picking process within the warehouse (order picking VS batch picking).
+
<td>In today’s world, social media is no longer just a mean of connecting to peers. It has become a place where most of us get our entertainment and news update from, a channel to raise awareness and even a great platform for business startups to launch and manage their business. Locally, SGAG is the epitome of a successful social media business. In spite of their successful journey thus far, many other players have joined SGAG to generate humor contents on social media in recent years.
</td>
+
 
 +
<p>Under such competition, maintaining and diversifying their customer base have been a challenge to SGAG. Furthermore, with the ever growing post volume and traffic, evaluating the performance of its social media posts has become yet another concern to SGAG. Therefore, SGAG wishes to discover meaningful insights from the historical data of its various social media channels such as Facebook and Twitter.</p></td>
 
<td>
 
<td>
 
+
'''Group01-Epiphany'''
'''[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY1516_G1_Team_Skulptors Group01- Team Skulptors]'''
+
* Anita
* LEONG Junkang, Gabriel
+
* Hoe Xiu Ming
* TAN Siying
+
* Sallyana
* ZHOU Xuanyi
 
 
</td>
 
</td>
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
Associate Professor of Information Systems (Practice)</td>
 
Associate Professor of Information Systems (Practice)</td>
<td>
+
<td>Karl Mak, Co-founder at SGAG
A local multi-national corporation (MNC)
 
* Mr Khoo, Head of Operation Innovation & Development (Corporate)
 
* Miss Shen, Executive, Operations Innovation & Development (Corporate)
 
* Mr Sundar, Process Improvement Executive (Automation)
 
 
</td>
 
</td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td>[https://wiki.smu.edu.sg/ANLY482/Analysis_of_User_and_Merchant_Dropoff_for_Sugar_App Analysis of User and Merchant Dropoff for Sugar App]</td>
 
<td>Sugar is an interactive city guide that seeks to encourage a culture of exploration in Singapore and helping local small businesses get discovered. Sugar’s merchants are mainly small local businesses in Singapore. It has a large variety, including cafes, small restaurants, bars, hair salons, gyms, gift shops. The benefits for merchants is advertising to users that are in close proximity to them. Users in turn get discounts on products that are in the closest proximity to them.
 
  
As Sugar is a relatively young startup in Singapore, it has not yet attained a critical mass of user and merchant numbers. As such, user growth and user experience is vitally important. To reach this critical mass, Sugar needs to minimize user and merchant attrition, and retain vital segments of both groups. Furthermore, as a two-sided market, Sugar needs the network effect and also find out which group(Users or Merchants) adds more value to their bottomline.  
+
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2017-18_T1_Group2 XXX2]</td>
 +
<td>
 +
TixCo, a ticketing service provider, has served as the ticketing agent for more than 1,000 events every year. As the leading provider in Singapore, it sells tickets for many events such as pop concerts, musicals, theatres and sports. Since its inception, TixCo aims to make buying tickets readily accessible and convenient for everyone.
  
The objective of our project will be to improve Sugar's bottomline via
+
As TixCo is the only authorised ticketing service provider for certain events, it is crucial for them to cater to the demand of the mass public. Currently, TixCo is unable to anticipate the demand for the event organised and this post challenge for TixCo to fully capture the demand efficiently. As such, any uncaptured demand is an opportunity lost for TixCo. Hence, it is important for them to understanding the demand for an event.
Merchant Analysis <br />
+
</td>
User Analysis <br />
 
Two-Sided Market Analysis <br />
 
Geospatial Analysis <br />
 
 
 
We will be using several techniques such as funnel plots, time series analysis, shortest distance analysis(Geospatial) and regression modeling to get insights and subsequently deriving recommendations for Sugar to increase its revenue and growth.</td>
 
 
<td>
 
<td>
'''[https://wiki.smu.edu.sg/ANLY482/Analysis_of_User_and_Merchant_Dropoff_for_Sugar_App Group02- Team TurnKEY]'''
+
'''Group02- Team Modulo'''
* Kang Long
+
* CHANG Hua Peng
* Elizabeth Tan
+
* CHUA Feng Ru
* Yi Sheng, Lim
+
* NGO Kee Kai
 
</td>
 
</td>
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
Associate Professor of Information Systems (Practice)</td>
 
Associate Professor of Information Systems (Practice)</td>
 
<td>
 
<td>
Benjamin Lee
+
TixCo
 +
</td>
  
Founder and Chief Executive Officer of Sugar Technologies Pte Ltd.
 
</td>
 
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td>[https://wiki.smu.edu.sg/ANLY482/Teppei_Syokudo_-_Improving_Store_Performance Teppei Syokudo - Improving Store Performance]</td>
+
 
<td>Teppei Syokudo is a Japanese Food and Beverage chain, under the umbrella of the famous Teppei Japanese Restaurant. In order to drive store performance through controllable factors, Teppei Syokudo is looking at focusing on staff performance. Most F&B businesses, including Teppei Syokudo, do not set detailed KPIs to evaluate how their staff are performing. If Teppei Syokudo is able to track the performance of their staff through relevant KPIs, they will be able to motivate staff to meet these KPIs, which will in turn boost the business’ bottom line.Teppei Syokudo has identified the following KPIs to assess their staff:
+
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2017-18_T1_Group3 XXX3]</td>
*Percentage of drinks sales (number of drinks sold / number of meals sold)
+
<td>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.
**a measurement of how hard the staff are up-selling
+
<p>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.</p>
*Labour Productivity (sales $ / working hours)
 
**a measurement of how effective the shop manager is in staffing the shop
 
However, the business is uncertain if these are the right KPIs to set. Also, if they are the right ones, they are unsure as to what would be a good target to meet.
 
Another factor for driving store performance is through product portfolio mix. Even though the staff may be up-selling and cross-selling, they may not know the right products to cross-sell to increase the probability of the customer making additional purchases. For example, most customers may tend to purchase Drink X together with Don X. In this case, if a customer orders Don X and is about to make payment, the staff can suggest Drink X to the customer, hence prompting a higher probability for the customer to purchase Drink X.
 
 
</td>
 
</td>
 
<td>
 
<td>
'''Group03- Team APSM'''
+
'''Group03- Qui vivra verra'''
* TAN Jhun Boon
+
* LIU Bowei
* YAP Jessie
+
* PONG Chong Xin
* OH Peng Ho
+
* TEO Hui Min
 
</td>
 
</td>
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
Associate Professor of Information Systems (Practice)</td>
 
Associate Professor of Information Systems (Practice)</td>
<td>Itaru Nagao,
+
<td>National Library Board (NLB)
Managing Director
 
 
 
YCP Management Southeast Asia Pte. Ltd.
 
 
 
YCP Retailing SEA Pte. Ltd.
 
 
</td>
 
</td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td>[https://wiki.smu.edu.sg/ANLY482/AY1516_T2_Team_Atom Car Park Overspill Study]</td>
+
 
<td>The objective of this project is to assist Media Research Consultants Pte Ltd (MRC) in understanding the current parking situations in 65 different locations in Singapore. These 65 parking locations compromise of 30 retail malls, 15 retails and Food & Beverage (F&B) clusters in landed housing estates, 10 hawker centers, and 10 community clubs. </td>
+
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2017-18_T1_Group4 XXX4]</td>
<td>
+
<td><p>Our sponsor is an established insurer, offering an extensive selection of General and Life Insurance products and solutions with a presence in many regions and countries. As one of the world’s most globally diversified and financially secure insurance groups, with portfolios in Marine Cargo insurance, Engineering, Personal Lines, and Life insurance, they have an established presence in Singapore in two specific area, Life Insurance and General Insurance.</p>
'''[https://wiki.smu.edu.sg/ANLY482/AY1516_T2_Team_Atom Group04- Team ATOM]'''
+
<p>Although they have been collecting data required for underwriting at the point of sale, most of the data are stored and kept for compliance purposes. In a bid to remain competitive in the landscape, they want to increase the customer life-time value by exploring the cross-selling potential of products.</p></td>
* Macus KHOO JunHao
+
<td>'''Group04- Team Insured'''
* YAN ShaoHong Chris
+
* Joshua Quek
* YO Wee King
+
* Justin Ong
 +
* Manas Mohapatra
 
</td>
 
</td>
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
Associate Professor of Information Systems (Practice)</td>
 
Associate Professor of Information Systems (Practice)</td>
<td>[http://www.mrconsultants.sg Media Research Consultants Pte Ltd]
+
<td>Undisclosed Insurance Company</td>
</td>
 
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td>[https://wiki.smu.edu.sg/ANLY482/AY1516_T2_Team_AP Social Media Analytics]</td>
+
 
 +
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2016-17_T1_Group5 Intelligence and Analytics in F&B]</td>
 
<td>
 
<td>
<p>The aim of this project is to provide deeper insight into SGAG's social network across its multiple platforms, namely Instagram and Twitter. </p>
+
Traditional POS systems are used mainly for completing orders and payments from a terminal. Data collected from these systems are hence limited to sales figures. A successful F&B business should not only analyse sales figures but also other aspects of the business such as efficiency of the current operations, inventory stocking, marketing campaigns and etc.
 
+
<p> Analytics Cafe will be working with HoiPOS to provide an interactive dashboard of different visualizations of data collected from HoiPOS systems. The project aims to improve HoiPOS’ data visualizations as well as add more visualizations of data analysis to value-add their POS system to clients. This project also aims to be able to apply descriptive analytics and effective visualizations to gain insights not only on the sales performance but also operations and marketing campaigns.
<p>Our client is the co-founder of the company and he seeks insights that can spur growth in SGAG's follower numbers. Through our analysis and research, we aim to help discover what kind of users are on each platform; the key engagement leaders for each topic; and how wide is the reach of these individuals. </p>
 
 
 
<p>The final deliverables will aim to: <br>
 
# Visualise the social networks of SGAG
 
# Identifying the user segments who engage SGAG's content, as filtered by topics and their reach
 
 
</p>
 
</p>
 
</td>
 
</td>
 
<td>
 
<td>
'''[https://wiki.smu.edu.sg/ANLY482/AY1516_T2_Team_AP Group05- Team AP]'''
+
'''Group05- Analytics Cafe'''
* WANG Shyan Ann
+
* Chen Shiqi
* NG Tse Siong
+
* Tan Wei Lin Joanna
* Sherman YONG Chin Wei
 
 
</td>
 
</td>
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
Associate Professor of Information Systems (Practice)</td>
 
Associate Professor of Information Systems (Practice)</td>
<td>Karl Mak, Co-founder at SGAG</td>
+
<td>
 +
HoiPOS
 +
</td>
 
</tr>
 
</tr>
 
  
 
<tr>
 
<tr>
<td>[https://wiki.smu.edu.sg/ANLY482/AY1516_T2_Team_SkyTrek Skyscanner Content Analysis]</td>
 
<td>
 
<p>
 
The project aims to help Skyscanner analyse its content sites in order to facilitate more effective planning of news articles. It will help understand the factors that affect content performance.
 
</p>
 
  
<p>  
+
<td>[https://wiki.smu.edu.sg/ANLY482/ANLY482_AY2016-17_T1_Group6 Using Social Network and Text Analytics to Create a Sales Force Performance Dashboard]</td>
The team will analyse content related data from multiple sources to determine what differentiates good and bad content based on certain performance metrics set by Skyscanner. This will be done through Text Based Cluster Analysis, Exploratory Modelling with logistic regression and Data Visualization using Tableau
+
<td>Advanced analytics have permeated almost every aspect of business management, from sales and marketing to finance and operations. Once carried out through intuition and experience, the human resource (HR) function is now undergoing its own revolution in the form of People Analytics. People Analytics provide HR professionals with data-driven methods to evaluate human capital and uncover critical workforce insights, thus diminishing the “guesswork” and uncertainty that comes with talent management.
</p>
+
<p>This project seeks to assist TrustSphere in gaining insight into how efficiently their sales team communicates within the company’s external and internal network. Furthermore we aim to develop a dashboard that helps them monitor these communications and assess the performance of their
<p>
+
sales employees.</p></td>
The deliverables include creating a dashboard with visualizations that will help Skyscanner team to better understand performance of content across different content channels.  
 
It will be used to validate some of the intuitions they might have about certain content topics/types and to determine the best time to publish them.  
 
The dashboard will benchmark certain metrics against pageviews as well as additional attributes that Skyscanner does not currently analyse via Google Analytics, such as the impact of title, text length, theme of article and number of images.
 
</p>
 
<p>
 
Data set includes data from Skyscanner websites for the Singapore, Malaysia and Thailand markets.
 
</p>
 
</td>
 
 
<td>
 
<td>
'''[https://wiki.smu.edu.sg/ANLY482/AY1516_T2_Team_SkyTrek Group06- Team SkyTrek]'''
+
'''Group06- Team MST'''
* Aseem PRABHAT
+
* Mabel HENG Yi Teng
* Jedaiah TAN Jia Le
+
* Siti Hamidah Binte Abdul HAMID
* NGUYEN Viet Huy
+
* Tarika GUPTA
 
</td>
 
</td>
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
<td>[http://sis.smu.edu.sg/faculty/profile/9618/KAM-Tin-Seong Prof. Kam Tin Seong]
 
Associate Professor of Information Systems (Practice)</td>
 
Associate Professor of Information Systems (Practice)</td>
<td>
+
<td>Ridwan Ismeer<br>
Ms. Antoinette Tan <br>
+
TrustSphere
Content Manager, APAC<br>
 
Skyscanner
 
 
</td>
 
</td>
 
</tr>
 
</tr>
 
 
  
 
</table>
 
</table>

Latest revision as of 13:49, 16 August 2017

Logo.png

About

Current Run

Projects Up For Grabs!

Grading & Deliverables

Downloads & FAQ

 


List of Projects
Title Analytics Practicum Description Student Member(s) Project Supervisor Sponsor
XXX1 In today’s world, social media is no longer just a mean of connecting to peers. It has become a place where most of us get our entertainment and news update from, a channel to raise awareness and even a great platform for business startups to launch and manage their business. Locally, SGAG is the epitome of a successful social media business. In spite of their successful journey thus far, many other players have joined SGAG to generate humor contents on social media in recent years.

Under such competition, maintaining and diversifying their customer base have been a challenge to SGAG. Furthermore, with the ever growing post volume and traffic, evaluating the performance of its social media posts has become yet another concern to SGAG. Therefore, SGAG wishes to discover meaningful insights from the historical data of its various social media channels such as Facebook and Twitter.

Group01-Epiphany

  • Anita
  • Hoe Xiu Ming
  • Sallyana
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Karl Mak, Co-founder at SGAG
XXX2

TixCo, a ticketing service provider, has served as the ticketing agent for more than 1,000 events every year. As the leading provider in Singapore, it sells tickets for many events such as pop concerts, musicals, theatres and sports. Since its inception, TixCo aims to make buying tickets readily accessible and convenient for everyone.

As TixCo is the only authorised ticketing service provider for certain events, it is crucial for them to cater to the demand of the mass public. Currently, TixCo is unable to anticipate the demand for the event organised and this post challenge for TixCo to fully capture the demand efficiently. As such, any uncaptured demand is an opportunity lost for TixCo. Hence, it is important for them to understanding the demand for an event.

Group02- Team Modulo

  • CHANG Hua Peng
  • CHUA Feng Ru
  • NGO Kee Kai
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)

TixCo

XXX3 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.

Group03- Qui vivra verra

  • LIU Bowei
  • PONG Chong Xin
  • TEO Hui Min
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) National Library Board (NLB)
XXX4

Our sponsor is an established insurer, offering an extensive selection of General and Life Insurance products and solutions with a presence in many regions and countries. As one of the world’s most globally diversified and financially secure insurance groups, with portfolios in Marine Cargo insurance, Engineering, Personal Lines, and Life insurance, they have an established presence in Singapore in two specific area, Life Insurance and General Insurance.

Although they have been collecting data required for underwriting at the point of sale, most of the data are stored and kept for compliance purposes. In a bid to remain competitive in the landscape, they want to increase the customer life-time value by exploring the cross-selling potential of products.

Group04- Team Insured
  • Joshua Quek
  • Justin Ong
  • Manas Mohapatra
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Undisclosed Insurance Company
Intelligence and Analytics in F&B

Traditional POS systems are used mainly for completing orders and payments from a terminal. Data collected from these systems are hence limited to sales figures. A successful F&B business should not only analyse sales figures but also other aspects of the business such as efficiency of the current operations, inventory stocking, marketing campaigns and etc.

Analytics Cafe will be working with HoiPOS to provide an interactive dashboard of different visualizations of data collected from HoiPOS systems. The project aims to improve HoiPOS’ data visualizations as well as add more visualizations of data analysis to value-add their POS system to clients. This project also aims to be able to apply descriptive analytics and effective visualizations to gain insights not only on the sales performance but also operations and marketing campaigns.

Group05- Analytics Cafe

  • Chen Shiqi
  • Tan Wei Lin Joanna
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice)

HoiPOS

Using Social Network and Text Analytics to Create a Sales Force Performance Dashboard Advanced analytics have permeated almost every aspect of business management, from sales and marketing to finance and operations. Once carried out through intuition and experience, the human resource (HR) function is now undergoing its own revolution in the form of People Analytics. People Analytics provide HR professionals with data-driven methods to evaluate human capital and uncover critical workforce insights, thus diminishing the “guesswork” and uncertainty that comes with talent management.

This project seeks to assist TrustSphere in gaining insight into how efficiently their sales team communicates within the company’s external and internal network. Furthermore we aim to develop a dashboard that helps them monitor these communications and assess the performance of their sales employees.

Group06- Team MST

  • Mabel HENG Yi Teng
  • Siti Hamidah Binte Abdul HAMID
  • Tarika GUPTA
Prof. Kam Tin Seong Associate Professor of Information Systems (Practice) Ridwan Ismeer

TrustSphere