Executive Summary Retail companies generate vast amounts of transactional data every day. However, data alone has little value unless it is transformed into actionable insights that support business decisions. SQL remains one of the most essential tools for extracting, cleaning, and analyzing business data because it allows analysts to efficiently query large databases and uncover…
Project Overview Studying in another country can provide valuable academic and personal opportunities, but it may also introduce challenges such as language barriers, cultural adjustment, homesickness, and separation from established support networks. In this project, I used SQL to investigate whether international and domestic university students differed in depression, social connectedness, and acculturative stress. I…
Tools: R • dplyr • ggplot2 • lubridate • K-Means Clustering • Customer Analytics Project Overview Customers differ considerably in how recently they purchased, how often they return, and how much they spend. Treating every customer the same can therefore lead to ineffective marketing and missed retention opportunities. In this project, I analyzed 541,909 online…
Overview This project analyzes New York City Airbnb listings to understand the factors that influence listing prices, predict property type, and identify natural market segments within the short-term rental market. Using regression, classification, and clustering techniques, the project connects statistical modeling with practical business insights for pricing, customer targeting, and market positioning. Business Questions Dataset…
After recently completing the Data Science and Machine Learning with R from A-Z course on Udemy, I was eager to put the frameworks I learned into practice. I chose the field of clinical health prediction because it demands “high accuracy” as well as a deep understanding of data preprocessing and model interpretation. The Data: A…
A Staggering Daily Reality I was scrolling through X and came across a map posted by data scientist Samuel Sinyangwe. The data from Mapping Police Violence presented a troubling statistic: in 2025, police in the U.S. killed an average of 3 people per day. Link to Samuel Sinyangwe’s Tweet This map prompted me to download…
When we see a headline about an aviation incident, it’s easy to feel a sense of alarm. However, headlines are snapshots, while data is the full movie. In this project, I analyzed over two decades of NTSB (National Transportation Safety Board) records, focusing on large-scale operators to answer two fundamental questions: Which aircraft appear most…