Search DAS42.com

Get Started

Fragmented Data, Limited Visibility.


The client’s business depended on a clear read of how each restaurant and truck performed against the company’s overall numbers.

Its data lived across numerous applications and platforms, at inconsistent levels of granularity, with no reporting layer built for actual users.

The team asked DAS42 to build a business intelligence system that could consolidate that data into KPIs and business metrics covering revenue, costs, financial performance, user journeys, customer service, and marketing.

The Solution

A Unified Business Intelligence Platform.


DAS42 recommended a modern data platform built on Snowflake, Fivetran, and Looker. Looker gave Finance, Customer, Marketing, and other teams the data models, reports, and visualizations to make decisions on accurate, relevant information, with data views across:

  • Restaurant, fleet, and customer KPIs
  • Marketing KPIs
  • User journeys and purchase funnel analytics
  • Investor reporting
  • Enterprise-wide inventory
  • Food and packaging standard costs at the recipe and raw-ingredient level
  • Labor costs for chefs, customer service, and culinary employees
  • Material expiration costs
  • Order issue analysis, including credits and refunds
  • Purchasing expenses and freight costs
  • Menu- and order-level revenue and allocated costs

DAS42 also brought in Snowflake’s Data Cloud and Fivetran to build an automated pipeline that replicates business data into the cloud warehouse.

Snowflake gave the team a central repository their people could access directly. Fivetran kept that access fast, without manual pipeline maintenance.

To make sure the platform actually got used, DAS42 set up administrative best practices for each tool and trained business, advanced, and administrative users.

THE RESULT

With the new platform live, the client can trust the data guiding its growth strategy.


The team now tracks food, beverage, and packaging consumption down to the raw-material level, along with labor and other costs per order item.

They can also break out variable costs – from freight to payment processing fees – and see exactly how each one moves their margins.