CASE STUDY
There isn’t any comparable platform in the market; Colrows is the all-in-one solution
SSP Group plc is a leading global operator of food & beverage venues in travel hubs, running over 3,000 units across nearly 40 countries and employing around 49,000 people. Specialising in airports, train stations, and other transit locations, SSP delivers a diverse range of outlets from sit-down restaurants and cafés to bars, quick service restaurants, lounges and food-led convenience stores. The company’s brand portfolio balances international, national and local concepts to suit the needs of varied clientele.
Reduction in data management overhead
faster issue resolution rate for front-line staff
Improvement in team collaboration
SSP Group manages large amounts of data related to local events, businesses, and communities, which is crucial for decision-making. Daily data crunching is necessary to track business performance, design marketing strategies, and launch campaigns. As the business grew, managing this increasing data became more complex, requiring more efficient tools and systems.
The tech team faced issues with different developers using various database clients like DBeaver, Squirrel, and Toad. This inconsistency led to:
Disorganization: No standardized approach for managing queries or scripts.
Collaboration Issues: Developers maintained separate copies of work, making it hard to share and track progress.
Version Control Problems: The lack of centralized management made it difficult to maintain consistent versions of scripts.
Similarly, Front-line staff struggled to access real-time data for customer inquiries and issue resolution. This led to:
Delayed Responses: Staff had to rely on other teams to retrieve data, slowing down response times.
Inefficient Processes: The lack of an easy-to-use system made accessing data cumbersome for front-line teams.
SSP Group built an in-house system to address front-line workers but it became burdensome as the business grew. The system required constant updates, struggled to scale with increasing data demands, and needed continuous refinement to keep up with evolving business needs.
In summary, SSP Group faced several interconnected challenges related to data management, team collaboration, and accessibility. From inconsistent database tools and complex access management to building an internal data system that couldn't keep up with the business's evolution, these hurdles slowed the team's ability to work efficiently and effectively.
Additionally, SSP Group was in process of setting up their data science team at the same time and they were looking for a platform with Python Notebooks capability.
Colrows' SQL Editor addresses many of the disorganization challenges faced by our tech teams. This modern editor enhances the SQL development experience by enabling collaboration across the team and simplifies tech stack by completely eliminating the need for bastion hosts.
The conversational interface breaks down knowledge barriers, providing real-time data access and reducing reliance on the tech and data teams for insights.
With seamless integration into Python Notebooks, Colrows is an ideal solution for SSP Group’s data science team, allowing for complex analysis and insights within one unified platform.
"Colrows is a complete solution for a firm like SSP Group; It turned out to be a one-stop solution for us"
Jayesh Pawar
Head of Analytics, SSP Group
After deploying Colrows, Lokal App underwent a significant transformation in its data management approach. The platform’s seamless integration with various data sources eliminated inconsistencies caused by multiple database clients, allowing the tech team to standardize database management and optimize query handling.
The collaborative use of SQL Notebooks among teams made work much more enjoyable, while its integration with Slack simplified data and query sharing across teams.
Colrows’ conversational interface was an immediate hit with the customer success team, providing real-time access to data and enabling them to resolve customer inquiries and issues much more efficiently. This also led to significant savings by replacing the in-house system.
The overall experience with Python notebooks has been exceptional—fast, reliable, and seamless.
"There are no tools currently available on the market that compare, and the pricing is incredibly reasonable"
Jayesh Pawar
Head of Analytics, SSP Group
Join SSP Group and countless other organizations that have revolutionized their approach to data analytics with Colrows.