Categories: Power BI / Practice Datasets
Tags:

Supplement Sales Data Analysis Dashboard Tutorial

About the dataset:

This dataset captures weekly sales data for a range of health and wellness supplements from January 2020 to April 2025. It includes products across various categories such as Protein, Vitamins, Omega, and Amino Acids. Sales data is collected from multiple e-commerce platforms, including Amazon, Walmart, and iHerb, and spans several geographic markets, including the USA, UK, and Canada.

Dataset Link: https://www.kaggle.com/datasets/zahidmughal2343/supplement-sales-data

Dashboard Description

This Power BI dashboard provides a comprehensive analysis of supplement sales data across three major e-commerce platforms—Amazon, Walmart, and iHerb—from January 2020 to April 2025. Let’s break down each section:

🔢 Top KPI Cards (Across the top row)

  1. Total Revenue:
    💰 $22.91 million generated in total sales.
  2. Average Price:
    🏷️ $34.78 is the average selling price of the supplements.
  3. Units Sold:
    📦 658,000 units were sold.
  4. Units Returned:
    🔄 6,714 units were returned.
  5. Return %:
    📉 1.02% of sold units were returned—relatively low, suggesting customer satisfaction or low returnability.

📊 Total Revenue and Average Price by Category (Bar + Line Chart)

  • Categories like Vitamin, Mineral, and Performance lead in total revenue.
  • The line chart overlays the average price per category, showing that despite some categories having lower revenue, their prices may be higher (e.g., Omega or Amino).

🧁 Total Revenue by Platform (Donut Chart)

  • Revenue is almost evenly split across:
    • Amazon: $7.86M (34.28%)
    • Walmart: $7.67M (33.47%)
    • iHerb: $7.39M (32.25%)

This indicates a balanced market presence on all three platforms.

🗺️ Total Revenue by Location (Map)

  • The map visual highlights North America (particularly the USA) as the dominant region in terms of revenue.
  • The UK and Canada also contribute significantly.

🔀 Sum of Revenue by Location and Product Name (Sankey Chart)

  • This Sankey chart visualizes the flow of revenue for top products like:
    • Ashwagandha
    • BCAA
    • Biotin
    • Collagen Peptides
    • Creatine
  • It shows how much each product contributed to revenue in Canada, UK, and USA.

🎛️ Filter Panel (Right Sidebar)

Interactive slicers for:

  • Category
  • Location
  • Platform
  • Product Name

These allow users to drill down into the data for deeper insights.