My Galaxy Store Sales Analysis - 2022

📌 Project Overview

This project analyzes My Galaxy Store's sales data using Excel pivot tables to identify key trends and insights. The final report highlights customer behavior, sales performance, and recommendations to improve future sales.

📊 Data Used

The dataset contains order details, including:

• Customer Demographics (Gender, Age Group, State)
• Order Status (Delivered, Cancelled, Refunded, Returned)
• Sales Channels (Amazon, Flipkart, Myntra, Ajio, Meesho, Nalli, Others)
• Total Sales & Revenue

🔍 Key Insights

• Women contribute ~65% of total purchases.
• Maharashtra, Karnataka, and Uttar Pradesh are the top 3 revenue-generating states.
• Adults (30-49 years) account for ~50% of total sales.
• Amazon, Flipkart, and Myntra are the top-performing sales channels.

📈 Conclusion & Strategy

To increase My Galaxy Store sales, focus on:
✅ Targeting women aged 30-49 in Maharashtra, Karnataka, and Uttar Pradesh.
✅ Running ads, discounts, and coupons on Amazon, Flipkart, and Myntra.

🛠 Tools Used

• Microsoft Excel (Pivot Tables, Charts, Reports)

📂 Project Files

📌 My Galaxy Store Data – Raw data, Pivot tables, & Analysis

🔗 Connect with me: Your GitHub Profile