dbt-building a more pet friendly world
PetScreening's dbt pipeline ends in a machine that prints pet safety tags, not a dashboard.
Overview
PetScreening uses dbt as an operational engine beyond traditional analytics, democratizing data to unlock both insights and complex operations. A key focus is the FidoAlert tag manufacturing system, where dbt transforms customer order data into tested, sequential waves for factory production, enabling rapid scaling from experiment to production workflows that help reunite lost pets with their owners.
What you'll take away
- 01
PetScreening treats a pet-tag printing machine as just another dbt exposure, no different in principle from a BI dashboard, just with a mechanical arm on the other end instead of a chart.
- 02
Bad data here doesn't mean a bad number in a dashboard, it means wasted material: a duplicate join can mean a few hundred wasted tags and real postage, raising the stakes on dbt tests.
- 03
The payoff: more than 1,000 dbt models, a 32x increase in data freshness, and a cut of more than 90% in the time from a new data request to an actionable answer, run by a five-person data team.
Session speakers
Nick Fernandez
PetScreeningWilliam Guicheney
Aimpoint Digital