Projects using Google BigQuery in ChandigarhProjects using Google BigQuery in ChandigarhI designed and built Distill IQ, a full-stack retail pricing intelligence platform for a US-based liquor business. The application processes and presents large-scale pricing data through interactive product surveys, competitor comparison analytics, raw data exploration, and user/access management. I worked across the React frontend, Python backend, APIs, BigQuery data layer, business logic, and UI components to build the platform from the ground up.
Key features:
Pricing Survey: 5,200+ SKUs, 110+ brands, search and advanced filtering
Competitor Analytics: Compare products across markets with average, median, mode, price ranges, and price gaps
Market Analytics: Interactive price distribution, historical trends, and competitor comparison
Raw Data Explorer: BigQuery-backed data exploration with filtering, pagination, and export
User Management: User accounts, roles, permissions, market access, and catalog management
Reusable UI: Tables, filters, cards, charts, forms, and responsive components