The InStore Group, an Inc. 5000 company, is a leading provider of retail merchandising and fulfillment services with nationwide coverage. Their comprehensive offerings include warehousing, order processing, shipping, tracking, customer service, shipment preparation, inbound and outbound logistics, returns processing, e-commerce fulfillment, inventory management, and POP fulfillment services. They also handle picking, packing, and shipping for retail and e-commerce clients, providing end-to-end merchandising support and ensuring efficient execution across thousands of stores nationwide.
Web-Based Retail Analytics & Merchandising Dashboard
Charlotte, NC, USA
Retail Merchandising & Fulfillment
1k - 5k
The scope included designing and developing InStore Reporter, a retail analytics and merchandising dashboard for The InStore Group, an Inc. 5000 company in the USA. The platform integrates with the Natural Insights (NI) API to fetch, deserialize, and store data from nationwide store visits, surveys, and field activities. Built using .NET Core, Angular, MSSQL, and AWS Lambda/EventBridge, the system delivers accurate, real-time, and user-friendly reporting with strong data integrity. It supports role-based user flows and interactive visualizations, including executive summaries and map-based store tracking, to equip stakeholders with actionable insights at scale. By replacing manual reporting with a centralized, automated solution, the platform helped The InStore Group make faster, data-driven decisions, optimize merchandising execution, and drive measurable improvements in sales, profitability, and market share.
Built a scalable retail analytics platform tailored to The InStore Group’s nationwide operations.
Integrated the Natural Insights API for automated, real-time data collection and synchronization.
Delivered Financial, Daily, and Operational dashboards offering actionable insights and real-time performance tracking.
Integrated ChatGPT and Google Maps APIs for anomaly detection, and store-level visualization.
Enabled seamless execution and monitoring of merchandising operations across all 50 states.
Delivered 40% faster access to insights, empowering retail managers to act swiftly on strategies.
Reduced manual reporting time by 60%, allowing teams to focus on high-value execution tasks.
Clients experienced a 20–25% uplift in product availability & sales due to real-time tracking and analytics.
The AI assistant lets users ask natural-language questions and receive instant, data-backed answers, reducing reliance on technical analysts and accelerating decision-making.
Seamless tracking of ongoing and completed projects across diverse regions with real-time visibility.
Delivering accurate insights into field execution, compliance, and performance.
Turning large-scale survey data into actionable insights that drive retail strategies.
Ensured through robust Natural Insights API integration, deserialization, and validation processes.
AI automatically analyzes daily survey data, visit performance, and image metadata to generate real-time project summaries and executive-level insights.
By automating tasks like report generation, anomaly detection, and performance summarization, the system reduced human intervention and optimized resource utilization.
InStore Reporter has given us reliable, near real-time visibility across nationwide projects through seamless Natural Insights integration and accurate dashboards. The AI summaries and query interface have simplified performance analysis and helped our teams make faster, data-driven decisions.
