Arunika
Our Work
AI / Data Analysis

MarketPulse EDA

An exploratory data analysis project for an online marketplace SME — uncovering buying patterns, peak hours, and top categories to sharpen their marketing strategy.

3

Key growth insights

50K+

Transactions analyzed

1mgg

Delivery time

The Challenge

An SME running an online marketplace had 2 years of transaction data sitting unused in spreadsheets. They had a gut feeling about which products performed best — but no data to back it up or guide their promotional spending.


Our Solution

We conducted a comprehensive EDA on 50,000+ transactions — cleaning the data, identifying patterns, and delivering a clear slide deck with actionable recommendations.

  • Data cleaning & normalization of 50K+ records
  • Time-series analysis by hour, day, and month
  • Product category performance ranking
  • Customer segmentation by frequency & value
  • Correlation analysis between promotions and sales spikes
  • Final report with 3 prioritized growth recommendations

Tech Stack

Python Pandas Matplotlib Seaborn Jupyter Notebook PowerPoint

The Result

Analysis revealed 3 high-impact insights: peak buying hours (7–9 PM), an underperforming category draining ad budget, and a loyal customer segment not targeted with retention offers. The client improved ROI by 22% the following quarter.

Got a project in mind?

Drop us a message and we'll get back to you within 24 hours.

Tell Us About It