Sales ops · Production

air up® centralizes data with Fivetran, empowering 97% of employees to conduct complex analytics

The problem

air up faced a fragmented data landscape with siloed information across multiple systems; data analysts had to manually gather data from Excel, SharePoint, and external providers, creating a slow, complex process that delayed reporting and limited the team's ability to make timely, data-driven decisions as the business scaled rapidly.

Workflow diagram · grounded in source
1
Multi-source data integration
integration
“automating data integration from 600+ tables from a variety of sources, including Shopify”
2
Structured data delivery
output
“With Fivetran delivering data in a structured format, we now have high-quality data from all the countries where we operate”
3
Dbt job orchestration trigger
integration
“Fivetran will trigger dbt jobs once data is extracted and loaded into the target database”
4
AI-powered self-service analytics
ai_action
“Veezoo's AI-powered, intuitive platform allows users to ask business questions in plain language, such as, "How many orders from France with our Cola flavor did we have this week?" or "What is the average time between a customer's first …”
5
Predictive sales forecasting
ai_action
“the company has built several models to forecast sales and investigates any deviations to refine these models and gain deeper business insights”
Reported outcome

Fivetran centralized air up's data, enabling 97% of employees to conduct complex analytics and reducing pipeline setup from months to hours.
Veezoo's AI-powered platform now lets all users query complex data in plain language, and predictive analytics models support accurate sales forecasting.

Reported metrics
Employees empowered for complex analytics97%
Data pipeline setup timefrom months to hours
Data tables integrated600+
Share of data from web shopsover 80%
Show all 6 reported metrics
employees empowered for complex analytics97%
data pipeline setup timefrom months to hours
data tables integrated600+
share of data from web shopsover 80%
data-driven decision improvementtremendous increase in both the quantity and quality of data-driven decisions
workforce growth rateworkforce tripling in one year
Reported stack
FivetranShopifyVeezoodbtExcelSharepoint
Source
https://www.fivetran.com/case-studies/bottles-saved-efficiency-gained-air-up-centralizes-data-for-growth
Read source ↗

Frequently asked questions

What did this team achieve with this AI workflow?

Fivetran centralized air up's data, enabling 97% of employees to conduct complex analytics and reducing pipeline setup from months to hours.

What tools did this team use?

Fivetran, Shopify, Veezoo, dbt, Excel, Sharepoint.

What results were reported?

Employees empowered for complex analytics: 97%; Data pipeline setup time: from months to hours; Data tables integrated: 600+; Share of data from web shops: over 80% (source-reported, not independently verified).

How is this sales ops AI workflow structured?

Multi-source data integration → Structured data delivery → Dbt job orchestration trigger → AI-powered self-service analytics → Predictive sales forecasting.

Related sales ops cases