Competitor Store Analysis Platform
A price and market tracking system for e-commerce
- 3 pazaryeri
- Sources
- Otomatik
- Collection
- Power BI
- Reporting
Overview
For a business selling on marketplaces, the most expensive missing piece of information is the competitor's price. When you notice a price change late, you lose not just that sale but your position in search rankings.
This platform grew out of a concrete need I encountered while working as a data analyst at Asylove. Product and price data from competing stores on Amazon, Etsy and eBay is collected regularly, normalised into a single data model and made comparable. Matching the same product across different stores makes it possible to compute the real price gap.
Through the Streamlit interface, the user picks a category, store and date range and sees price distribution, assortment breadth and change over time. Analysis results were also fed into Power BI and folded into management reporting. The system's real gain is speed: a competitor sweep that previously took days by hand became an automated pipeline.
Highlights
- Regular data collection from multiple marketplaces
- Matching the same product across stores
- Price distribution and time series visualization
- Feeding into Power BI management reporting
Objectives
- Notice competitor price changes early, not late
- Automate the manual competitor sweep
- Ground pricing decisions in data
Solution
- Normalising marketplace data into one schema
- Building the product matching logic
- An interactive filtering interface with Streamlit
- Merging analysis output into Power BI
Approach
- 01Identifying with the sales team which decisions get made
- 02Building the collection and normalisation pipeline
- 03Interface development and hooking it into reporting
Outcomes
- A competitor sweep that took days became an automated pipeline
- Pricing decisions became data-supported
- Gaps in assortment became visible
- Analysis results were integrated into management reporting
Challenges
- Reconciling data formats across different marketplaces
- The same product listed under different names
- Keeping data collection sustainable and regular
Selected Work
Similar projects
KC House Dataset Exploratory Analysis
Exploratory analysis of the King County house price dataset: statistically examining and modelling the variables that determine price.
Word Cloud Generator
A web application that generates customisable word clouds from text data, combining frequency analysis with visualization options.
Audio-to-News-Article Agent
An AI tool that turns an audio recording first into text, then into a structured news article, combining speech recognition and natural language processing in a single pipeline.