Microsoft
A retail group operating in a highly competitive category was making pricing decisions based on monthly manual competitor checks. By the time data reached buyers, market conditions had already shifted.
The team lacked real-time competitive visibility. Pricing decisions were reactive, margin was being eroded by competitors moving faster, and there was no systematic way to monitor hundreds of SKUs across multiple competitor sites.
Built an Azure Functions pipeline to scrape and ingest competitor pricing data across target SKU lists daily.
Designed a price index model normalising competitor prices against own prices by category and brand.
Integrated the pricing data warehouse with Power BI for buyer-facing dashboards with alerting on significant price movements.
Implemented historical trend tracking to identify seasonal pricing patterns by category.
Pricing team gained daily visibility across 2,400 tracked SKUs.
Average time to respond to a competitor price move reduced from 3 weeks to 48 hours.
Margin improvement of 3.2% on monitored categories within the first two quarters.
Microsoft