Sales-and-Customer-Dashboard-with-Dynamic-Filtering Dashboard_Link
Welcome to my interactive Tableau project analyzing sales and customer data for a US-based superstore. This project showcases how data visualization can drive insight-led business decisions through intuitive and interactive dashboards.
🔗 Live Dashboard: View on Tableau Public
To build a dynamic dashboard that helps stakeholders:
- Analyze sales trends across regions and categories
- Understand customer behavior by segment and geography
- Identify business opportunities and performance gaps
- 📅 Time Period: 2014–2017
- 📦 Records: ~9,900 orders
- 🧾 Fields: Order Date, Sales, Profit, Quantity, Region, State, Segment, Category, Sub-Category, Customer Name
- 🛠️ Tableau Public – Data visualization and dashboard design
- 📊 Excel / Google Sheets – Data cleaning and exploration
- ✅ Filters: Region, Segment, Product Category
- 📈 KPIs: Total Sales, Profit, Quantity
- 🌍 Visuals: Sales by Region & Sub-Category
- 📆 Trends: Monthly performance analysis
- 👥 Segment-wise profit & sales (Consumer, Corporate, Home Office)
- 📍 Customer distribution by state
- 🏆 Highlights of top customers and high-value regions
- 🏆 West Region had the highest sales and profit
- 🛠️ Technology category drove the most revenue
- 👥 Consumer Segment accounted for over 50% of total sales
- 📉 Mid-year months showed a 15–20% drop in sales → promo opportunity
- 🌎 High-value customers concentrated in states like California
- ⚡ Accelerated performance analysis by 60% using filters & visuals
- 📊 Enhanced data storytelling with interactive dashboards
- 🎯 Improved visibility into customer trends and segment behavior by 70%
- 🧠 Supported strategic decision-making for marketing & regional growth
This project demonstrates my ability to:
- Turn raw data into meaningful insights
- Design user-friendly dashboards for business use
- Communicate complex trends in a clear and visual way