Power BI Toy Stores KPIs

Overview

This project demonstrates the power of data visualization and analytics in uncovering valuable business insights. Using Power BI, I analyzed a multi-store dataset to identify trends, evaluate performance, and recommend actionable strategies for improvement.

Key Features of the Dashboard

  1. Total Revenue and Profitability Metrics
    • Total revenue for the analyzed period: 658,194
    • Total orders: 41,830
    • Total profit: 258.15K
  2. Top Product Categories
    • Toys lead in sales, followed by Arts & Crafts and Games.
    • Visual comparisons reveal how each category contributes to total orders and revenue.
  3. Revenue Trends Over Time
    • Monthly revenue trends show clear seasonal peaks and dips, providing actionable insights into customer buying behavior.
  4. Interactive Filtering
    • Users can dynamically filter by store location types (Airport, Commercial, Downtown, Residential) to customize the analysis and identify location-specific patterns.

I look forward to your inputs and feedback.

Share your love