Project Archive
A collection of data-driven solutions, dashboards, and automated pipelines.
Each project represents a business question answered.
Coffee shop Sales Analysis
Excel Pivot Tables DashboardCoffee shop sales analysisThe business questionA coffee shop owner needed to understand which products, times of day, and customer patterns were actually driving revenue — and where operational inefficiency was quietly costing money.What I didCleaned and structured 12 months of transactional data in Excel. Built dynamic Pivot Table dashboards segmented by product category, hour of day, and day of week. Applied VLOOKUP and IF-based formulas to flag underperforming SKUs and surface revenue concentration risk.Key findingMorning hours (7–10am) generated 61% of daily revenue despite representing only 23% of operating hours — recommending targeted staffing and upsell strategies during that window could lift daily revenue by an estimated 8–12%.
Emirates Customer Reviews Data Analysis
Emirated customer reviews data analysis
🚀 Automating Loan Application Processing with Machine Learning 🤖💰
🚀 Automating Loan Application Processing with Machine Learning 🤖💰
Product Sales Analysis: Optimizing Sales Methods for New Stationery Line
In response to changing consumer behavior, the company tested three different sales strategies to identify the most effective approach for this new product line: Email: Targeted emails at launch and 3 weeks later. Call: Direct phone calls from the sales team (avg. 30 mins/customer). Email + Call: An initial email followed by a shorter needs-assessment call (avg. 10 mins/customer).
Hi! Ask me about Raj's skills or projects.