Date: 14 November 2025

Tools: Excel (Pivot Tables, Slicers, Timeline, Dashboard Design)

🔍 Project Overview

An interactive Excel Retail Sales Dashboard analyzing 3 months of retail transaction data (Jan–Mar 2023).

Includes dynamic KPIs, pivot-based charts, slicers, timeline filters, and heatmaps to help understand product, region, and monthly performance.

🎯 Decision Context

This dashboard supports exploratory review of retail sales performance, helping stakeholders quickly spot weak months, loss-making products, and discount-heavy patterns that may require deeper financial analysis.

🎯 Objectives

• Build a clean, business-ready Excel dashboard
• Analyze best/worst-performing regions, products, and months
• Measure discount impact on profitability
• Identify loss-making products
• Provide interactive filters for deeper analysis

🚫 Scope & Limitations

• Based on a small, short-term retail dataset (3 months)
• Focused on descriptive and exploratory analysis