Dynamic Sales Trends Analysis

Overview

This project analyzes sales data across Spanish cities to uncover trends, seasonal patterns, and the impact of promotions on sales and revenue.

Key Insights

• Seasonal Analysis:
  • Summer is the highest-performing season, generating 64K units sold.
  • Winter and Fall follow closely with 62K units each.
• Promotions:
  • "20% Off" promotion leads to the highest sales volume (65K units sold).
  • "Buy 1 Get 1 Free" follows with 63K units sold.
• Top Cities:
  • Malaga is the most profitable city, generating €57K profit.
  • Valencia and Barcelona follow closely with €56K and €53K profit respectively.
• Weather Conditions:
  • Cold and snowy weather slightly increase revenue compared to sunny days.

Data Insights

• Total Revenue: €1.31M
• Total Profit: €262.48K
• Total Quantity Sold: 247.59K
• Profit Margin: 20%

Dashboard Features

• Interactive slicers for season, weather condition, location, and promotion.
• Detailed visuals highlighting key trends and insights.
• Drill-through capabilities to analyze performance by category and location.

Tools and Technologies

• Power BI for data visualization and insights.
• Python for data preprocessing and cleaning.

How to Use

1. Download the .pbix file.
2. Open in Power BI Desktop to explore interactive insights.
3. Use slicers to filter by season, city, and promotions.