Data Analysis Using MS Excel — Cart Store 2024

Introduction

This project involves a comprehensive data analysis of Cart Store's annual e-commerce sales operations for the year 2024. The analysis was conducted using Microsoft Excel, employing advanced features such as Pivot Tables, data cleaning techniques, conditional formatting, and an interactive Dashboard to extract meaningful business insights from raw transactional data.

Cart Store is an Indian fashion e-commerce retailer selling products across platforms like Amazon, Myntra, Flipkart, Ajio, Nalli, and Meesho. The dataset spans the full calendar year 2024, covering 31,047 order records across 8 product categories, multiple customer demographics, and geographic regions across India.

Key Features

• Complete data cleaning — removed duplicates, corrected inconsistencies, and standardized all fields.
• Multi-dimensional Pivot Table analysis across month, channel, category, state, gender, and age group.
• Interactive Excel Dashboard with dynamic Slicers for real-time filtering.
• Revenue, order volume, and customer demographic breakdowns with visual charts.
• Data-driven business recommendations based on analytical findings.

Tools & Technologies

• Primary Tool: Microsoft Excel 2024
• Features: Pivot Tables, VLOOKUP, IF Formulas, Conditional Formatting, Slicers
• Visualization: Bar Charts, Pie Charts, Line Graphs, Interactive Dashboard
• Data Cleaning: Remove Duplicates, Find & Replace, TRIM/CLEAN, Text-to-Columns
• Dataset: Cart_Store.xlsx — 31,047 records, 21 columns, 12 months of sales data

Data Analysis Pipeline

The project follows a structured 5-step data analysis pipeline:

1. Data Collection — Received raw transactional sales data (Cart_Store.xlsx).
2. Data Cleaning — Fixed errors, removed duplicates, standardized Gender and Channel fields.
3. Data Processing — Added calculated columns: Month, Age Group. Created Processing Data sheet.
4. Data Analysis — Built Pivot Tables across all dimensions; applied formulas for aggregation.
5. Visualization — Created Charts and an interactive Dashboard with KPI summary.

Implementations

1. Data Cleaning Module — Standardized Gender column (fixed 'Menyntra' → 'Myntra' etc.), removed duplicates, validated all 21 fields.
2. Pivot Table Module — 6 Pivot Tables: Monthly Sales, Channel-wise, Category-wise, State-wise, Gender-wise, Age Group-wise.
3. Dashboard Module — Interactive sheet with Slicers, KPI cards, and visual charts for quick business overview.
4. Reporting Module — Structured analysis with findings and recommendations compiled into project report.

Screenshots & Images

Place your Excel Dashboard and Pivot Table screenshots in images/ folder.

Future Scope

• Integration with Power BI or Tableau for advanced interactive visualizations.
• Predictive sales forecasting using Python or Machine Learning models.
• Real-time dashboard connected to a live order management system.
• Automated monthly reporting pipeline using Excel Macros (VBA).
• Customer segmentation using RFM (Recency, Frequency, Monetary) analysis.

Conclusion & Next Steps

The project successfully demonstrated how Microsoft Excel can be used as a powerful data analysis tool for real-world e-commerce datasets. By applying systematic data cleaning, Pivot Table analysis, and visual dashboards, key revenue drivers, customer patterns, and geographic strengths of Cart Store were clearly identified.

With future enhancements like Power BI integration and ML-based forecasting, the analysis framework developed in this project can evolve into a scalable, real-time business intelligence solution.