Case Study

Retail Analytics Company for Large Retailers

This client transforms massive amounts of retail data into actions that improve availability, reduce waste and drive profit. Their AI-powered platform surfaces operational issues in real time and guides store teams on exactly what to do next. It’s a retail execution engine for large, data-heavy retailers.

Challenge / Scope

• Integrate data from Teradata and BigQuery into SQL Server
• Track stock and phantom inventory across retail operations
• Support ~40 SQL Servers handling this large volume, busy retail data which had not previously been looked after

The Outcome

• Successfully built data pipelines handling Teradata and BigQuery integration
• Implemented tracking system using T-SQL, PowerShell, and SSIS
• Maintained high availability across 40 SQL Server instances
• Standardised environments (both SQL and Windows) along with alerting, monitoring and proper maintenance tasks

Key Services Provided

• Data engineering and ETL development
• SQL Server DBA tasks (maintenance, indexing, HA failover, patching)
• T-SQL, PowerShell, and SSIS development
• Reporting infrastructure support

---

Interested in discussing any points raised in this case study?

Contact us today and speak to one of our team who will be happy to assist you with your enquiry.

View All Case Studies