📦 Amazon Sales Analysis Dashboard

A comprehensive Tableau dashboard analyzing $2.37B in Amazon sales data across regions, channels, and product categories.

📊 View Live Dashboard · 💼 LinkedIn · 🌐 Peerlist · 📧 Email

---

Dashboard Preview

📌 View the full interactive dashboard on [Tableau Publ]ic](https://public.tableau.com/app/profile/priyanshi.rajput/viz/AmazonSalesDashboard_17380474019010/RevenueAnalysis)

---

📋 Table of Contents

• 📌 Project Overview
• 🎯 Background & Goals
• 📊 Key KPIs
• 🔍 Key Insights
• 🛠️ Process
• 👥 Stakeholders
• 🚀 Next Steps
• 📁 Files
• 🛠️ Tools Used
• 👩‍💻 Connect With Me

---

📌 Project Overview

This Amazon Sales Analysis project provides a comprehensive overview of key performance indicators such as profit, revenue, shipping days, and unit sales.

The analysis focuses on:

• 📍 Evaluating profit distribution across regions and countries
• 📡 Identifying channel-specific revenue trends (Online vs Offline)
• 📅 Understanding yearly variations in orders and costs
• 🧾 Examining item-wise metrics — revenue, profit margins, shipments, units sold

By uncovering actionable insights, this study enables Amazon to enhance regional performance, streamline operations, and drive sustainable growth.

---

🎯 Background & Goals

Background

Amazon, as a global e-commerce leader, processes millions of transactions daily across various regions, channels, and categories. Understanding sales trends and performance metrics is crucial for sustaining profitability and operational efficiency.

Goals

Evaluate the impact of shipping days, order priorities, and sales across different products and regions — ultimately guiding decision-making for operational improvements.

---

📊 Key KPIs

💰 Total Revenue	🏆 Total Profit	📦 Units Sold	🚚 Avg Shipping Days
$2,370.7M	$788M	9.0M	23.95 days

---

🔍 Key Insights

🌍 Profit by Region

Region	Profit	Status
Sub-Saharan Africa	$220.8M	🥇 Highest
Europe	$189.6M	🥈 2nd
Middle East & North Africa	$126.3M	🥉 3rd
Australia & Oceania	$89.1M
Asia	$70.9M
Central America & Caribbean	$40.5M
North America	$39.4M	⚠️ Low
India	$11.5M	⚠️ Lowest

---

🌐 Profit by Country (Top 4)

Country	Profit
🏆 Djibouti	$58.2M
🥈 Pakistan	$46.4M
🥉 Samoa	$45.6M
4️⃣ Mexico	$39.4M

---

🛒 Revenue by Channel

Channel	Revenue
🏪 Offline	$1,425.39M
💻 Online	$945.35M

💡 Insight: Offline sales significantly outperform online sales — focus needed on improving the online customer experience.

---

📦 Product Category Analysis

Category	Revenue	Profit	Units Sold
Cosmetics	$724.4M	$288.1M	261 (Highest)
Office Supplies	$530.6M	$102.9M	198
Household	$469.8M	$116.5M	126
Baby Food	$180.1M	$67.6M	—
Clothes	$151.0M	$101.5M	243
Beverages	$63.6M	$21.0M	180
Fruits	Lowest	Lowest	—

💡 Insight: Cosmetics is the most profitable, highest revenue, and best-selling category. Fruits has the lowest performance across all metrics.

---

📅 Orders & Cost Trend (2010–2017)

Year	Orders	Cost
2010	153	$239.0M
2011	252	$155.3M
2012	351 ⬆️ Peak	$343.4M
2013	234	$306.9M
2014	225	$220.6M
2015	171	$100.1M
2016	180	$115.6M
2017	90 ⬇️ Low	$101.8M

💡 Insight: Clear correlation between cost per year and orders per year — lowest cost correlates with lowest order volume.

---

🚚 Revenue & Shipment Days Analysis

💡 Typically, an increase in shipping days leads to a decline in revenue, while faster shipping boosts revenue. Exception observed in 2012–2013 where both rose simultaneously.

---

📋 Order by Priority

Priority	Count
🔴 Critical	378
🟡 High	513
🟠 Medium	324
🟢 Low	441

---

🛠️ Process

📂 Understanding Data
        ↓
🧹 Data Cleaning
        ↓
🗂️ Data Modeling
        ↓
📊 Data Analysis
        ↓
💡 Uncover Insights

---

👥 Stakeholders

Internal Stakeholders

Role	Responsibility
CEO	Strategic direction based on sales insights
CFO	Revenue, profit, and cost analysis
COO	Operational efficiency & shipping
CMO	Marketing impact on sales & revenue

External Stakeholders

• Consumers — Impacted by product availability, shipping times, and pricing

---

🚀 Next Steps & Recommendations

🌍 Regional Strategy

• ✅ Capitalize on high demand in Sub-Saharan Africa & Europe
• ✅ Conduct regional demand analysis to tailor products
• ✅ Identify factors causing low profitability in India & North America

🛒 Channel Strategy

• ✅ Improve online customer experience — product quality, shipping, pricing
• ✅ Boost offline sales via targeted discounts & retention strategies

📦 Product Strategy

• ✅ Expand Cosmetics line into new market segments
• ✅ Investigate high costs in Office Supplies & Household
• ✅ Reconsider Fruits strategy — new pricing, range expansion, or discontinue
• ✅ Improve marketing for Baby Food & Clothes

🚚 Shipping Optimization

• ✅ Optimize delivery routes and leverage faster shipping methods
• ✅ Reduce shipping times where averages are rising
• ✅ Expand the delivery network

---

📁 Files in This Repository

File	Description
Amazon Sales Dashboard.pdf	Full 16-slide presentation
Amazon Sales Dashboard.twb	Tableau workbook file

---

🛠️ Tools Used

Tool	Purpose
	Dashboard & Visualization
	Data Source
	Project Report

---

👩‍💻 Connect With Me

Platform	Link
📧 Email	priyanshi1652001@gmail.com
💼 LinkedIn	Priyanshi Rajput
🌐 Peerlist	priyanshirajput
🐙 GitHub	Data897analysit
📊 Tableau	Public Profile

---

⭐ If you found this project helpful, please give it a star!

Made with ❤️ by Priyanshi Rajput