Project Title Data-Driven Coffee Sales Dashboard & Revenue Optimization Project Description Overv...Project Title Data-Driven Coffee Sales Dashboard & Revenue Optimization Project Description Overv...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Sahoora's avatar
Sahoora Jamshed
• Aug 9
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.
Data VisualizationData AnalysisUI DesignMicrosoft ExcelMicrosoft Power BI
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started