alexstudio3,github

Project portfolio

Here are some examples how I use advanced data analytics to solve real life business challenges, including original code and presentation documents.

Singapore Airbnb listing price prediction and analysis (Python) Presentation

Using Linear Regression and ML models to predict Airbnb listing price in Singapore
Using Tableau to visualise Airbnb market in Singapore
Correlation analysis

Credit card acceptance prediction (Python & Tableau) Presentation

Explored (using Tableau) which kind of customers should we target for credit card offer
Using different models (KNN, logistic Regression, Random Forrest) to classify whether customer will accept credit card offer

Song recommendation engine (Python) Presentation

K-means classification model based on song features

Code examples

Song recommendation engine

Data Visualization projects

World renewable energy vs access to electricity Flourish story

Created flourish story on the trends of global renewable energy vs access to electricty for different regions

SQL projects

Global deforestation enqury Presentation Document

Used SQL queries to generate insights for world forestation coverage

Udiit-twitter (SQL database modelling and design) Document

Used SQL to create database and migrate existing data on for twitter application

Other SQL projects are upon request.

alexstudio3's Projects

credit_card_acceptance

https://docs.google.com/presentation/d/1THirtKhxeS1ZpheJsFknsSMIPiUilJTBGUl5iTFwHT8/edit?usp=sharing

flight_delays

Udacity Business Analytics Data Visualisation project

My Insight Data Engineering Fellowship project. I implemented a big data processing pipeline based on lambda architecture, that aggregates Twitter and US stock market data for user sentiment analysis using open source tools - Apache Kafka for data ingestions, Apache Spark & Spark Streaming for batch & real-time processing, Apache Cassandra f or storage, Flask, Bootstrap and HighCharts f or frontend.