top of page

COVID-19
PROJECT

Data Exploration and Visualization using SQL and Tableau

In this project, I used SQL Sever to explore real life data about the ongoing global pandemic COVID-19. Through the exploration, I discovered insight about the cases, deaths and vaccinations data that is happening through the entire world. To top that off, I created a dashboard in Tableau with the information I discovered through my queries within SQL Sever.

Portfolio: Text

TRAVEL INSURANCE
PROJECT

Data Visualization and Logistic Regression Model using R

In this project, I used R to visually explore a data set about a company's travel insurance data with the tidyverse package 'ggplot2'. Along with the visualizations, I built a logistic regression model as a method for binary classification. To further evaluate the logistic regression model, I used different metrics such as cross-validation, sensitivity, specificity and the ROC curve.

Portfolio: Text

HOTEL BOOKINGS PROJECT

Data Cleaning, Exploration and Visualization using SQL and Tableau

In this project, I used SQL Sever and Tableau to clean, explore and visualize data about hotel bookings. Some of the things I cleaned within the data set includes the dates, columns and much more. Then, I used queries to compare the bookings between city and resort hotels while visualizing it with a dashboard in Tableau.

Portfolio: Text

RENTAL BIKES PROJECT

Correlation using Python

In this project, I used Python to work with correlation. I wanted to find out what variables had an effect on the amount of bikes rented each day. Through this project, I cleaned the data and used a correlation matrix and scatterplots to achieve my objective.

Portfolio: Text

©2021 by Tracy Lam. Created with Wix.com

bottom of page