Coordination across a large design team breaks down at data translation: too many file formats, too much room for miscommunication. This pipeline extracts a model's KPIs the moment a new version is published and pushes them into one format every team can read.
Context
IAAC · Barcelona
Year
2026
Stack
Speckle · Automation · Data pipelines · BIM
Brief
An automated pipeline that transforms raw 3D model metadata into structured cloud spreadsheets. This makes complex geometric data easily accessible and adaptable for various end-uses, from simple data reading to feeding live web platforms.
01 · Problem
The geometric, textual and numerical data a design team generates is enormous, and the missing link isn't better analysis: it's a single, legible format everyone downstream can actually use. The Studio's Data Team needed raw geometry to arrive already structured for its KPI database.
02 · Pipeline
The automation pulls architectural KPIs (areas, use ratios, evacuation distances) straight from the 3D model and processes them into a structured Excel or Google Sheet, with summary matrices by tower, level and program ready for immediate validation.
03 · Validation
The tables run from a per-geometry summary to validation tables that flag errors and version-to-version changes (matching, missing or modified) so a stale export is caught before it reaches anyone who'd act on it.
