Projects
Purpose of the projects are to build valuable trends and patterns for given data,
and connect numerical analysis with visual analysis
Healthcare Case Study
Application used: SQL, Tableau
Data from healthcare start-up company which helps nurses to book their schedule online freely.
Case study is to optimize reducing cancellation rates and no-call-no-shows on healthcare professionals.
Proposed two suggestions on how to diminish cancellation rates to improve on business.
Cyclistic Case Study
Application used: SQL, Excel, Tableau
This case study is for Google Data Analytics Certificate presented by Coursera.
Purpose of this case study is to perform data analysis for a fictional bike-share company (Cyclistic) in order to help them attract more riders.
Presented three recommendations for Cyclistic and visualized analysis.
COVID-19 Vaccine Progress
Application used: R, Python
As 'Coronavirus update' was one of the top google searches for 2020 and vaccination has been started last December, I analyzed to track daily vaccination per country and per population density.
Visualized most vaccinated country and most used vaccine types using R (ggplot2) and Python (Seaborn, Matplotlib, Plotly)
All about Wine
Application used: R, Python
280k+ wine testers tested worldwide wines based on its appearance, flavor, depth, character, and aroma/bouquet, and finish.
Analyzed correlation between price and points using scatter plots and line regression plots.
Tried to visualize the world map using choropleth map to see which country is contributing the most on wine industry
Great Lakes Ice Coverage
Application used: Power BI
Collected data for all 5 Great Lakes' ice coverage from 1973 to 2020
Displayed average coverage along with trend line across. Also, evaluated anomaly detection and forecasted to view what will happen in next 10 years
