Work
Analytics Case Studies
End-to-end data analysis projects in SQL, pandas, and Google Sheets. Every project is a full case study: business problem, methodology, working code, findings, and recommendations.
01
SQLE-Commerce Revenue & Customer Segmentation
PostgreSQL deep-dive into 100k marketplace orders covering revenue trends, RFM segmentation, and how delivery delays drive 1-star reviews.
02
pandasTelecom Customer Churn Analysis
EDA in pandas on 7,043 telecom customers where month-to-month contracts, electronic checks, and missing tech support emerge as the churn triple-threat.
03
Google SheetsMarketing Campaign ROI Dashboard
Google Sheets build: automated 6-channel marketing dashboard with QUERY, ARRAYFORMULA and pivot reporting that surfaced an 18% efficiency gain.
04
SQLHR Analytics: Attrition & Compensation Equity
SQL analysis of HR records: overtime triples attrition, sales reps quit at 40%, and percentile analysis exposes pay compression in key roles.
05
pandasLoan Default Risk at 2.26M Rows
pandas at scale: 2.26M loans processed in chunks with dtype tuning. Default rates climb 6x from grade A to G, and small-business loans default at nearly twice the book average.
06
SQLNYC Yellow Taxi Demand & Tipping Patterns
BigQuery analysis of 38M+ NYC taxi trips covering demand peaks, airport economics, and why cash trips make tipping data lie.
07
Google SheetsInventory Control & Reorder Automation
Google Sheets system: ABC analysis plus automated reorder points for 850 SKUs, modeled to cut stockouts from 6.2% to under 2%.
08
pandasRetail Profitability: The Discount Cliff
pandas margin analysis of 10,800 retail order lines. Tables lose $17.7k, and profits fall off a cliff once discounts pass 20%.