Amazon Sales Dashboard

Problem:

KPIS: - profit, Revenue, Shipping days, Units Sales 

Business Use cases: - 

1. Analyse the profit by region 

2. Analyse the profit by Countries 

3. Channel Revenue Analysis  

4. Order per year 

5. Cost per year 

6. Revenue and Shipment Analysis 

7. Items wise revenue, profit margin, shipments, Number of units sold 

Insights: -

Profit by Country: -

Djibouti has Highest Profit with $58.2 million, followed by Pakistan at $46.4, Samoa at 45.6million and Mexico at $39.4 million.

Profit by Region:-

High Profit Regions

• Sub-Saharan Africa: $220.8M

• Europe: $189.6M

• Middle East and North Africa: $126.3M

  Low Profit Regions

  • India: $11.5M

  • North America: $39.4M

Revenue by Channel:-

Revenue: Offline sales significantly outperform online sales.

Order and Cost Per Year: -

• Between 2010 and 2012, we observed an increase in order volume. Concurrently, costs decreased until 2011 and then began to rise through 2012.

• A sharp decline in both order volume and costs is evident from 2012 to 2015. Furthermore, after 2016, we observe a continued sharp decrease in order volume, accompanied by fluctuations in cost.

• There is a clear correlation between cost per year and orders per year, with the lowest cost per year correlating with the lowest order per year, and vice versa.

Revenue and Shipment Data Analysis: -

1.Typically, an increase in shipping days correlates with a decline in revenue, whereas a reduction in shipping days leads to an increase

in revenue.

2. However, from 2012 to 2013, both shipping days and revenue exhibited an upward trend, indicating a potential exception to the usual pattern.

3 .Conversely, from 2013 to 2014, both shipping days and revenue declined, suggesting a different operational dynamic during this period.

Revenue, Profit, Unit Sold , Cost by Item: -

• Cosmetics are the most profitable, highest costly product and highest selling product category.

• Office Supplies and Household are the second and third highest revenue generating categories, but their profits are low.

• Baby Food and Clothes have relatively high revenue, but a lower unit sold compared to other categories.

• Fruits have the lowest revenue and unit sold.

• The unit sold is high in the "Beverages" category compared to the profits generated.

• Although office supplies and household have a low number of units sold, they rank second and third highest in cost Price.

Conclusion:-

The Amazon Sales Analysis using Tableau has provided insightful data on Profit Performance on Region and Country, Revenue Chanel Analysis , Profit, Unit Sold, Cost , Revenue on Item, Order per year. Key finding include expand products in high profitable Region and Country , Focus on expanding the cosmetics items , help to know the reason of high cost of office supplier and Household, new pricing model and for fruits, check fruits quality, lowest cost per year correlating with the lowest order per year.

By focusing on the insights such as decreasing order per year , Improving Item, worst Item, Highest Profitable Region Amazon can drive higher sales , higher profit , customer trust , Market demand.

Thank You