🏢 Maven MegaMart – Retail Acquisition Analysis

📌 Project Overview

This project analyzes 2M+ retail transactions (2016–2017) to evaluate the feasibility of acquiring a target retail chain.

Using Python (Pandas, NumPy, Matplotlib, Seaborn), the analysis explores:

• 📈 Sales growth trends
• 👥 Customer demographic behavior
• 🛒 Product department performance
• 🎯 Strategic acquisition insights

The objective is to deliver data-driven insights that inform strategic acquisition and expansion decisions.

---

📊 Executive Summary

🔎 Key Findings

• 2017 sales outperformed 2016, indicating steady year-over-year growth.
• Sales peak on Mondays and Tuesdays, suggesting structured early-week purchasing behavior.
• Young single-parent households (19–24) represent a high-value customer segment.
• Lower-income households drive a significant share of revenue, aligning with discount retail positioning.
• Spirits is the leading department among young consumers, highlighting demographic-driven purchasing trends.

📌 Project Highlights

• 2M+ transaction records analyzed
• End-to-end EDA with business recommendations
• Structured for acquisition decision support

🎯 Business Conclusion

The retailer demonstrates consistent revenue growth, strong demographic alignment, and scalable demand patterns - indicating a strategically sound acquisition opportunity.

---

🛠 Technical Approach

Data Sources

• project_transactions.csv – 2M+ transaction records
• hh_demographic.csv – Household demographic data
• products.csv – Product department information

Key Analysis Steps

• Data cleaning and memory optimization
• Time-series resampling and YoY growth analysis
• Customer segmentation analysis
• Department-level performance evaluation
• Strategic recommendation development
• Designed analysis to simulate a real-world acquisition evaluation scenario

---

📈 Key Visual Insights

Monthly Sales Trend

Year-over-Year Comparison

Sales by Weekday

Customer Segmentation – Age

Customer Segmentation – Income

Household Composition Heatmap

Department Performance by Age

🧠 Skills Demonstrated

• Data Wrangling & Transformation (Pandas)
• Time-Series Analysis
• Customer Segmentation
• Data Visualization (Matplotlib, Seaborn)
• Business Insight Development
• Strategic Recommendation Framing

---

🎯 Strategic Recommendations

1️⃣ Sales Optimization

• Introduce mid-week promotions to balance lower-performing days.
• Align inventory planning with peak sales days (Mon, Tue, Sun).

2️⃣ Customer Targeting

• Focus marketing efforts on high-value young single-parent households.
• Maintain pricing alignment with lower-income segments.

3️⃣ Acquisition Outlook

• Consistent revenue growth and strong demographic alignment support acquisition viability.
• Product demand patterns suggest scalable revenue opportunities.

---

📂 Repository Structure

maven-megamart-retail-analysis/
│
├── data/
│ ├── hh_demographic.csv
│ ├── products.csv
│ └── project_transactions.zip
│
├── images/
│ ├── monthly_sales_trend.png
│ ├── yoy_sales_comparison.png
│ ├── sales_by_weekday.png
│ ├── sales_by_age.png
│ ├── sales_by_income.png
│ ├── household_heatmap.png
│ └── department_by_age.png
│
├── maven_megamart_analysis.ipynb
└── README.md

---

🚀 How to Run

1. Clone the repository
2. Install required libraries:

   pip install pandas numpy matplotlib seaborn openpyxl

3. Open and run maven_megamart_analysis.ipynb

---

💼 About Me

I am a data analyst with experience in business-driven analytics, focusing on turning large datasets into actionable insights.

📌 Open to roles in:

• Data Analyst
• Business Analyst
• Retail Analytics
• BI & Reporting

If you would like to discuss this project or explore collaboration opportunities:

---

⭐ If you found this project interesting, feel free to star the repository!