An interactive Excel dashboard analyzing global sales & logistics data to track performance, demand trends, and profitability across regions and products.
This project transforms raw business data into a dynamic dashboard enabling real-time insights into sales performance, customer demand, and operational efficiency.
- Total Orders: 50K+
- Revenue Scale: Multi-million dataset
- Geographic Coverage: Multiple countries & regions
- Data Scope: Sales, Shipping, Payments, Products
- Microsoft Excel (Advanced)
- Pivot Tables & Pivot Charts
- Slicers & Interactive Filters
- Data Cleaning & Transformation
- Data Visualization
- Top Products Contribution: ~30% of total sales
- High-Demand Regions: Top regions contribute ~60% of revenue
- Dominant Payment Method: ~45% usage share
- Standard Shipping Usage: ~50% of orders
- Profit Variation: Significant gaps across markets
- Sales concentrated among top-performing products (~30%)
- Clear visibility of high vs low-performing categories
- Top regions contribute ~60% of total revenue
- Uneven demand distribution across countries
- One payment method dominates with ~45% share
- Indicates customer preference trends
- Standard shipping used in ~50% of orders
- Order status analysis reveals operational flow & delays
- Significant profit variation across markets
- Identifies high-margin vs low-margin regions
- Clear order trends over time
- Helps in demand forecasting and planning
- Enabled data-driven decision-making via interactive dashboard
- Identified top products and high-demand regions
- Improved visibility into logistics and order performance
- Supported profit optimization and strategic planning
Dashboard.xlsx→ Final interactive dashboarddata.csv→ Raw datasetpdf/→ Dashboard export
Usman Javed
Data Analyst
Open to internships & freelance opportunities