Excel Sales Dashboard Case Study | Sales Analysis, Customer Segmentation & Returns Insights

Описание: In this video, I walk you through a complete Sales Analysis project using Microsoft Excel, where we clean transactional sales data, calculate key metrics, and build an interactive dashboard.

✅ What You’ll Learn:

Data cleaning (handling duplicates, cancellations, return rates)

Sales KPIs: Total Sales, Average Transaction Value, Top Products

Customer segmentation using Excel formulas (QUARTILE.INC)

Monthly and regional sales trend analysis

Return rate calculation using SUMIFS

Building a professional, interactive dashboard with slicers

📈 Tools Used:

Microsoft Excel

Pivot Tables, Charts, and Slicers

Excel formulas: IF, SUMIFS, TEXT, QUARTILE.INC, and more

💡 Perfect for:

Aspiring Data Analysts

Excel learners

Professionals preparing for interview case studies

Business analysts and sales teams

🎯 Key Insights Include:

Top 10 products contribute over 60% of total sales

UK leads in both revenue and number of transactions

High return rate on seasonal items

Sales peak in November and December

🔗 Like 👍 | Comment 💬 | Subscribe 🔔 for more Excel and analytics projects!

#ExcelDashboard #SalesAnalysis #DataAnalytics #ExcelCaseStudy #ExcelForBeginners #InteractiveDashboard #CustomerSegmentation #ReturnRateAnalysis