“Sherloq has become my bread and butter for everyday SQL usage.”
Amir Engel, Head of Analytics at WeSki
Executive Summary
Core Locations: Headquarters: Herzliya, Israel
Industry: Travel and Hospitality (specializing in Ski Holidays)
# of Employees and Data Department: 55 employees with Head of Analytics
Business Model: B2C
Data Stack: Snowflake, DataGrip
Main Points
Challenge:
SQL queries were scattered across systems and emails, leading to inefficiencies and misalignment.
There was no centralized place for key company SQL and metrics, causing discrepancies and lack of alignment.
Difficulty in reusing and documenting existing SQL queries and for future analysis, resulting in time wasted recreating queries.
Solution:
Sherloq centralized SQL queries, making them easy to reference and maintain consistency.
Broad search functionality allowed them to quickly find queries that were saved on-the-fly.
Version control and direct updates from the SQL editor ensured queries stayed up-to-date and synchronized.
Sherloq’s sharable query links created transparency by allowing the wider team to access relevant SQL queries, helping them understand the work behind each analysis.
Impact:
Weski saved 90+ SQL queries in four months, streamlining their analysis process.
Sherloq became the one place for all SQL for the Head of Analytics, improving efficiency, enabling SQL reference for other stakeholders, and supporting scalable growth.
Background: About Weski
Weski is a dynamic travel company specializing in providing hassle-free, customizable ski holidays. Offering a one-stop platform for booking everything from flights and transfers to accommodation and lift passes, Weski simplifies the ski trip planning process for travelers.
With a commitment to providing flexible payment options and unbeatable prices, Weski serves both seasoned skiers and first-timers, ensuring every guest can experience the ultimate winter getaway. Their customer-first approach and years of experience in the travel industry have earned them a reputation for reliability and exceptional service in the ski holiday market.
As of early 2025, the company has a team of 55 employees.
As the company scaled, the need for reliable analytics became crucial to their day-to-day operations. That’s when the Weski team brought in their Head of Analytics, to manage data analytics efforts.
The Challenge:
Scattered SQL and Inefficient SQL Management
The Head of Analytics was hired to enhance Weski’s data analytics processes and improve analytics efficiency. Having experienced the benefits of Sherloq at his previous company, he recognized its potential and brought it with him to Weski to address key SQL management challenges.
As part of building Weski’s data analytics department, the need for organized, accessible, and reusable SQL code became critical.
Without a central repository, queries were stored in multiple places and often difficult to track.
While they used DataGrip as their SQL editor, it was not ideal for saving and managing SQL queries. DataGrip is excellent for query writing and running, but lacks built-in features for organizing, centralizing, sharing, and version-controlling SQL queries in a collaborative environment.
Key challenges included:
Lack of centralization:
SQL queries, especially ad-hoc that needed to be reused for different analysis and purposes, were scattered across different systems and emails, leading to misalignment in data results and inefficiencies in data workflows.Time-consuming manual processes:
Tracking changes and reusing SQL code without a formal structure was tedious and error-prone.Reusing Existing Queries for Future Analysis:
Without a central repository, it was difficult to repurpose existing SQL queries for new analyses, resulting in wasted time recreating queries.Centralized Place for Company Metrics:
There was no unified location for key company metrics, leading to discrepancies in data reporting and a lack of alignment across departments. Ensuring everyone accessed and used the same definitions and calculations was a challenge, especially as the company grew.
The Solution:
Centralized SQL Management and Built-in Integration
Sherloq provided Weski with a centralized solution that saved all SQL queries in one easy-to-use platform. It integrated seamlessly into their existing workflow on DataGrip, allowing them to work within the tools they were already familiar with.
Key Points and Benefits for Weski:
- Centralized Knowledge:
All SQL queries were housed in one central location, creating a single source of truth for all ad-hoc queries and ongoing metrics. They could easily reference past work, reducing redundancy and improving consistency.
The broad search functionality allowed them to find any saved query quickly, even if they could only remember part of it, making retrieval much more efficient.
Indicative folders, names, descriptions, and tags made it easy to categorize queries, ensuring that even as the number of queries grew, they could still be found quickly.
The ability to create SQL versions ensured that all queries were kept up-to-date and in sync. Additionally, the option to update versions directly from the SQL editor made it easy to maintain consistency without disrupting their existing workflow.
- Alignment on Analysis, Metrics, and SQL:
With only one data person managing everything, ensuring alignment on company metrics, analysis, and SQL was crucial. Sherloq helped establish a single, consistent source of truth for all data queries, fostering reliable data results and transparency across the organization. This helped prevent discrepancies and ensured everyone was working with the same data, improving trust and collaboration within the team.
Although Weski had only one data professional, Sherloq’s sharable links allowed for wider team access. Every analysis created ended with a Google Sheet summary, where a tab labeled “Queries” contained links to relevant SQL queries in Sherloq, promoting transparency and helping others understand the work behind each analysis.
- Increased Efficiency:
Significant time saved by eliminating the need to manually search for or recreate past queries. With all SQL queries organized and searchable, the process became more streamlined.
Repetitive tasks such as query documentation and formatting were automated, freeing up time for more strategic analysis and insights.
- Scalability:
As Weski grows, Sherloq offers the flexibility to scale with the team. New team members can easily onboard, accessing all the organized SQL work already stored in the platform.
The integration with AI-powered features also provides the team with future-proof tools to take their data management to the next level as their needs evolve.
The Impact:
Dozens of Saved Queries in Just a Few Months
In 4 months, and with a team of 1 data person, Weski has saved over 90 SQL queries on top of Sherloq as part of their existing analysis process. Weski’s Head of Analytics stated that has become his bread and butter for his daily analysis work.
For a growing startup like Weski with one data professional, Sherloq became the go-to for their day-to-day work. It enabled them to manage SQL queries more efficiently, create alignment in their data analysis, and integrate seamlessly with their existing tools.
Sherloq’s SQL repository was an invaluable asset in helping Weski streamline their data workflows, laying a foundation for continued growth and success.
