Archive Category: Data Analysis
23 September 2025
VRSD Analysis
🚗 Case Study: Vehicle Repair Shop Data Analysis 📌 Objective The goal of this project was to analyze customer behavior, vehicle patterns, job performance, parts usage, and financial metrics for a vehicle repair shop. Using SQL, I created queries that answered key business questions and revealed actionable insights for growth and efficiency. 🔧 Data Preparation […]
23 September 2025
Outlier Detection Using Geospatial Analysis
📊 Case Study: Detecting Outliers in Election Results Using Geospatial Analysis Background Election transparency relies on consistency across polling units in the same area. When one polling unit records results that are significantly different from its neighbors, it may indicate irregularities or errors that require investigation. Objective The goal of this project was to identify […]
16 September 2025
YouTube Success Factors: An EDA
Case Study: YouTube Success Factors — Exploratory Data Analysis Objective Identify what video features, like length, tags, publish time, and category, are linked to higher views and engagement. Data & Approach Used YouTube metadata and performance logs from a Kaggle dataset. Cleaned data (handled missing values, parsed tags and timestamps, converted categories). Ran exploratory data […]
16 September 2025
Demographics Analysis
📊 Case Study: Telecom Demography & Service Dashboard 🔍 Project Background The telecom industry generates massive amounts of customer and service data. For this project, I worked with artificial telecom data from California, USA, aiming to explore who the customers are, how they use services, and what factors drive churn vs retention. I wanted to […]
16 September 2025
Keyword Analysis
Case Study: Keyword Research for Language Learning Apps 🔹 Project Overview The goal of this project was to help a stakeholder with a new language learning app identify high-potential keywords that could boost visibility in a competitive market. Using data-driven keyword research, I built a content strategy that balances search volume with competition, ensuring the […]