Five projects built around real café operations. Two dataset analyses using SQL, BigQuery, and Tableau. All seven are documented end-to-end.
Built a SKU-level tracking system with reorder thresholds and usage monitoring. Cut the owner's weekly resupply runs from 5 to 2.
Modeled ingredient cost vs. selling price for every menu item. Surfaced margins ranging from 27% to 91% — giving the business its first clear view of what was actually profitable.
Consolidated POS revenue data, expense tracking, and COGS into a single reporting model. Identified that beverages drove 49% of revenue at ~60% gross margin.
Documented every operational process — SOPs, training roadmaps, shift roles, and daily workflows. Replaced verbal hand-me-down procedures with a written system.
Custom website built for Lotus Café — HTML, CSS, and JavaScript. No templates. Deployed on Cloudflare Pages with a custom domain.
Exploratory data analysis of 100k+ row Brazilian Olist dataset. SQL in BigQuery — CTEs, window functions, NTILE percentile ranking. Four findings visualized in a Tableau dashboard.
Part 2 of 2 — 99k+ orders mapped through a fulfillment pipeline. Five findings including a selection bias catch in the repeat purchase analysis. Late deliveries drop review scores by 40%.