Skip to content

Latest commit

 

History

History
40 lines (34 loc) · 1.23 KB

README.md

File metadata and controls

40 lines (34 loc) · 1.23 KB

Ecommerce_Sales_Analysis

Successful ecommerce businesses need to optimize every stage of the customer journey, from first touch to purchase. This ecommerce dashboard is a curated set of metrics, KPIs and other data that’s designed to highlight, in the clearest possible way, trends, anomalies and information related to an online store that regularly warrants attention.

Dashboard Link: https://public.tableau.com/views/EcommerceSalesAnalysisDashboard/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link

Attributes present in given Dataset:

  1. Additional Order items
  2. Category Name
  3. Customer City
  4. Customer Country
  5. Customer Fname
  6. Customer Id
  7. Customer Segment
  8. Customer State
  9. Customer Zipcode
  10. Market
  11. Order Customer Id
  12. Order Date
  13. Order Id
  14. Order Region
  15. Order Item
  16. Total
  17. Order Quantity
  18. Product Price
  19. Profit Margin
  20. Profit Per Order
  21. Sales

Metrics Used in this Analysis

  1. Sales - Category wise, region wise
  2. Market Share
  3. Customer Acquisition Per month
  4. Profit
  5. Margins
  6. Order Quantity
  7. Product category analysis

image