How a luxury gelato chain uses Precog to actually get realtime, multi-source analytics
By Jeff Carr
November 7, 2023

A Journey to AI-Driven Realtime, Multi-source Analytics via ELT — In Two Days

Snowflake Gelato is a rapidly growing UK-based gelato company with nine locations in the UK and two internationally. As part of their expansion plans, they needed to improve their analytics.

This case study explores how Ibrahim Khan and Zahra Masood, Snowflake Gelato’s Business Analyst team, leveraged Precog to radically simplify loading data into Snowflake from Cin7 Core (inventory management), MarketMan (restaurant management), Xero (accounting), and Workforce (workforce management). Once effective and dependable ELT was in place, Ibrahim turned to the key area of focus: analysis and reporting.

How hard is it to get real-time data from four SaaS sources?

“Zapier and other solutions were not able to do the job that we needed, which was to build accurate data pipelines in a relatively speedy time.” — Ibrahim Khan

Before adopting Precog, Ibrahim faced several challenges that prevented his business from quickly and easily understanding fundamental drivers (and blockers) of growth.

  1. Time-consuming manual data processing: The company relied on manual data processing from multiple sources, including exporting data and using spreadsheets. This process was extremely time-consuming and was prone to error.
  2. Increasing costs: To meet the demands of the company’s strategists, Ibrahim was looking for solutions. The vendors he approached had estimates exceeding $30,000 — for integrating just four data sources. And the time estimates were between two and three months.
  3. Complexity and delays: Some potential solutions required months of development time to create ETL/ELT pipelines, delaying their ability to leverage data for critical business functions.
  4. Data integration: Key insights would come not from looking at one data source, but they needed complex relationships between their different systems to achieve the right insights.

“The vendors and consultants I reviewed wanted $30,000 and more — and their timelines were months — Precog was affordable and done in a matter of days.” — Zahra Masood

The new era of real-time business analytics

Ibrahim and Zahra found an ideal solution in Precog to address their data analytics needs. Key aspects of the solution include:

  1. Automation: Precog enabled the automation of data collection and integration from various sources, making it a seamless process. This ensured that they had access to fresh, real-time data regardless of what the source was.
  2. Cost-effectiveness: Precog offered a cost-effective alternative to other vendors, making it accessible for a growing company with a limited budget. Precog was 10x more affordable than the competing solutions.
  3. Ease-of-use: The platform is user-friendly and requires minimal maintenance, reducing the overhead associated with data management.

How valuable are real-time insights?

The adoption of Precog brought several benefits to Snowflake Gelato.

  1. Significant time savings: Data preparation time was significantly reduced from 10-15 minutes daily to 30 seconds with Precog.
  2. Operational efficiency: Real-time data access across their entire business allowed Ibrahim to bring deep and meaningful insights to his team.
  3. Improved forecasting and budgeting: The ability to use real-time data for forecasting and budgeting led to more accurate financial planning.
  4. Supply chain optimization: The company could use data analytics to optimize its supply chain, ensuring they were adequately prepared for seasonal changes.
  5. Marketing insights: Data analytics offered insights into customer ordering patterns, enabling the marketing team to tailor their strategies for better results across seasons.
Tableau dashboard using data from Cin7, XERO, MaretMan, and Workforce.com

Tableau dashboard using data from Cin7, XERO, MaretMan, and Workforce.com

The new age AI-driven ELT

“We needed to find something that was easy — that could do all the hard work and heavy lifting for us. And it had to be reliable and affordable as well. That’s what we found in Precog.” — Ibrahim Khan

Snowflake Gelato’s new data management and analytics process exemplifies the unprecedented impact of what Precog’s ELT solution can do for businesses. By automating data collection and loading, teams can spend 100% of their time providing business insights — data preparation and manual loading are fully automated now.

The ease of use and cost-effectiveness of Precog made it an ideal solution for a rapidly growing company that was looking to drive expansion on sound insights. Precog has enabled Snowflake Gelato to make data-driven decisions with confidence, ensuring the company’s continued success and growth in a competitive market.

News and Blog

ETL vs ELT

ETL vs ELT

While ETL allowed customers to maximize limited database performance by filtering data, the marked improvements in the data warehousing space led to a new approach to data integration, ELT.

read more

From Our Customers

Localize

We chose to use Precog because they were the only company willing to handle our complex data connections. Since the beginning, it has been one of those tools that just works solidly and reliably.

Derek Binkley - Engineering Manager
Cured

The Precog platform has delivered data connectors to necessary data sources other vendors could not or would not, and in a very short timeframe.

Ashmer Aslam - CEO Cured
Walnut St. Labs

Precog lets us prototype analytics projects quickly — building marketing dashboards based on data from a variety of sources — without needing a data engineer or developer.

Chris Dima - CEO
Alteryx

We welcome Precog to the Alteryx technology partner ecosystem as a partner extending the capabilities of our platform, further simplifying analytics for our customers.

Hakan Soderbom - Director of Technology Alliances
SouthEnd

We recognized a need in our customer base to perform advanced analytics on SAP data sets. We chose Precog based on its performance and its strong strategic relationship with SAP.

Alfredo Poncio - CEO
SendaRide

Precog is a vital tool — it gives us the ability to pull data from a variety of business sources quickly and cleanly.

Josh Wilsie - VP