Cover image for Project Title
Data-Driven Coffee Sales

Project Title Data-Driven Coffee Sales Dashboard & Revenue Optimization Project Description Overview This project features an interactive, comprehensive Sales Performance Dashboard designed to track and optimize global coffee revenue. It transforms raw transactional data into actionable commercial insights, empowering stakeholders to identify key growth drivers across multiple product dimensions. Core Metrics Delivered $44.18K Total Sales analyzed to establish clear revenue baselines. 957 Orders Processed to evaluate volume metrics and consumer demand. $46.16 Average Order Value (AOV) monitored to optimize pricing strategies. Key Insights & Analytics Features Sales Over Time Trend Analysis: Multi-variable line chart mapping seasonal demand fluctuations across four distinct coffee beans (Arabica, Excelsa, Liberica, Robusta) from 2019 to 2022. Geographic Performance Tracking: Bar chart isolating top-performing regional markets, identifying the United States as the primary revenue driver ($35K+). Product & Packaging Optimization: Granular breakdown of revenue by coffee type alongside dynamic slicers for roast levels (Dark, Light, Medium) and package sizes (0.20kg to 2.50kg) to identify high-margin inventory. My Role & Technical Impact Data Modeling: Cleaned and structured transactional data to build a cohesive relational schema. UI/UX Dashboard Design: Designed a clean, executive-ready interface with synchronized visual anchors and intuitive layout hierarchies for seamless navigation. Insight Generation: Translated complex timelines into clear trend lines, giving decision-makers immediate clarity on product lifecycles and market demands.

Sahoora Jamshed

I am a data analyst with Software Engineering Foundation.