This repository contains a business analytics case study analysing Q1 2025 sales performance, customer behaviour, and discount campaign effectiveness for a fashion retail brand (Simple Threads).
The objective of this analysis was to convert raw transactional data into actionable insights that support strategic business decision-making.
- How did the business perform in Q1 2025 in terms of revenue and customers?
- Which products and categories drove the most revenue?
- How did different discount tiers impact customer spending?
- Is there a relationship between product price and purchase amount?
- What opportunities exist for improving retention and campaign efficiency?
- Total revenue of ₹20,730 generated from 21 unique customers in Q1 2025
- Strong positive correlation (~0.95) between product price and amount spent, indicating premium products drive revenue
- Women’s Skirts emerged as the top revenue-generating category
- 20% discount tier produced the highest average order value (₹706), outperforming lower discount levels
- Majority of customers made a single purchase, highlighting retention opportunities
- Data Cleaning & Validation
- Exploratory Data Analysis (EDA)
- Correlation Analysis
- Campaign Effectiveness Analysis
- Data Visualisation & Insight Communication
Tools: Python, Pandas, Matplotlib
📄 The report PDF is uploaded separately in this repository.
The report contains the full analysis, visualisations, insights, and strategic recommendations.