Online Retail Sales Analysis Project | Excel Dashboard & Business Insights | Placement Project

In this project, I performed a complete sales analysis on an Online Retail dataset for the years 2009–10 and 2010–11 using Microsoft Excel.

The project includes:
✔ Data Cleaning & Preparation
✔ Cancellation Analysis
✔ Product Revenue & Quantity Analysis
✔ Customer Segmentation
✔ Country-wise Invoice Analysis
✔ Monthly Sales Trend Analysis
✔ Interactive Excel Dashboards

Tools & Functions Used:
🔹 Pivot Tables & Pivot Charts
🔹 SUMIFS, AVERAGEIFS, IF, COUNTIFS
🔹 PERCENTILE.INC & QUARTILE.INC
🔹 Dashboard Design & Data Visualization

This project demonstrates how raw retail transaction data can be transformed into meaningful business insights using Excel.

Files:
https://drive.google.com/drive/folders/1PD8zDcNZl1yvxMHJhEe3KJdiWjNyKK8e?usp=drive_link

#ExcelProject #DataAnalytics #ExcelDashboard #RetailAnalysis #BusinessAnalytics #DataVisualization #MicrosoftExcel #SalesAnalysis #DashboardProject #CloudyML

Видео Online Retail Sales Analysis Project | Excel Dashboard & Business Insights | Placement Project канала Ranjeet Singh Deogan