AirPortal

AirPortal

All, Data Analysis

Tools

Invision, Pen & Paper

Link

https://goo.gl/AgGw7d

Challenge

With over 150,000 passengers going through Changi Airport every day, the airport faces the challenge to optimize the visitor experience and match visitors with the right airport amenities and the right information at the right time.

Solution

AirPortal opens up automatically when travelers connect to Changi Airport’s Wifi, no need to download an app. Travelers can either scan the barcode on their boarding pass or simply enter their flight number, and they will see the information that is relevant to them at that moment – from up-to-date gate information to a good restaurant. No information overload.

My Role

I was the product manager in this team. I designed the information flow and recommendation algorithm. I also managed the app prototype development collaboration between the design and software engineering team members and presented the prototype at the Changi Airport Hackathon in San Francisco, CA.

Movie Shot Locations in San Francisco

Movie Shot Locations in San Francisco

All, Data Analysis

Tools

Matlab

Github Code

 coming soon

Goal

 The goal of this project was to analyze and visualize where movies were shot in San Francisco. To achieve this goal, information from different data sources was combined, analyzed and visualized, using some of the spatial data analysis concepts learned in Spatial Data Analysis.

Approach

 The first step in this multi-step process was data gathering. The main dataset used in this project comes from the San Francisco Open Data website and contains a list of movies and TV shows with scenes filmed in San Francisco, some more detailed description of the movie/show like cast and year and – most importantly for the analysis – a textual description of the location where the movie/show was shot. Overall, the dataset contains descriptions of 1586 locations in San Francisco. The dataset was downloaded from the website and imported into Matlab for inspection, cleaning, analysis, and visualization.

Functionality from the Google Geocoding API, the Foursquare API, and the Open Movie Database API was used to get additional data and an external Matlab file exchange program (Google Map Plotter by Zohar Bar-Yehuda) was used to enhance visualization.

For an interactive user experience, a script was created that allowed users to explore the dataset on their own terms. The program prompts users for a location description in San Francisco (eg. ‘Golden Gate Bridge’) or a concrete address (eg. ‘888 Brannan Street’) and a radius in meters within which to search for movie locations. Leveraging the user’s input, the tool then returns a rich variety of information. Most importantly, it returns a map of the location and its immediate surroundings and a list of movies that were shot within the specified radius.

Movies shot here were ‘Burglar’, ‘My Reality’, ‘San Andreas’, and ‘Vertigo.

A second visualization generated was that of a side-by-side plot of movie locations by genre.

Movie shot locations in San Francisco by genre