Post-COVID Recovery for SIA

Categories: excel, modelling, SIA, spreadsheet Optimizing Passenger-Cargo Fleet Allocation By: Ang Su Yiin, Gabriella Pauline Djojosaputro, Gordy Adiprasetyo, Kendra Luisa Baylon Gadong, Nguyen Nhi Thai An, Ulysses Chong Min Zhen This was written as part of the requirement for the Spreadsheet Modeling module for MITB. For executive report, please view: Executive Report 1. Problem Statement With the halt of international travel due to COVID-19, the global aviation industry is one of the industries that was hit the worst.

November 18, 2020 Read
Predicting H1N1 Vaccination

Categories: predictive, regression, decision tree, SAS Enterprise Miner This was written as part of the requirement for the Data Analytics Lab module for MITB. Predicting H1N1 vaccination based on flu survey. For executive report, please view: Executive Report 1. Introduction The H1N1 outbreak in April 2009 swept across the world and caused a global pandemic. CDC estimated that the H1N1 virus claimed the lives of 151,700 – 575,400 people worldwide during its first year of circulation.

November 15, 2020 Read
The Math of Happiness

Categories: R Shiny, regression The Math of Happiness: An analysis of factors that influence happiness. By: Ang Su Yiin, Anne Nguyen Nhi Thai An, E-Lynn Toh, Foo Kai Loon, Sean Samuel Prajs, Tay Kai Lin This was written as part of the requirement for the Applied Statistical Analysis with R module for MITB. Shiny app available at The Math of Happiness 1. Introduction The quest for happiness is an elusive pursuit for many.

November 10, 2020 Read
Market segmentation of Philippines’ market

Categories: market segmentation, k-means, latent class, clustering, SAS JMP This was written as part of the requirement for the Data Analytics Lab module for MITB. Market segmentation of Philippines’ market based on expenditure patterns of households. For executive report, please view : Executive Report - Segmentation 1. Objective This report aims to group the Philippines’ consumer market into target segments based on similar spending patterns on hypermarket items using clustering methods in JMP.

October 18, 2020 Read
Hotel booking cancellations

Categories: exploratory, confirmatory, hotel booking, SAS JMP This was written as part of the requirement for the Data Analytics Lab module for MITB. An analysis of guests’ booking and cancellation trends for two Portuguese hotels. For executive report, please view : Executive report - hotel booking 1. Overview Changing Landscape of the Hotel Industry According to D-Edge, the rise of online travel agents (OTAs) has caused hotels in Europe to experience a shift in distribution channel mix – in particular, from the websites of hotels, to OTAs (particularly Booking.

September 20, 2020 Read