LOOM Brand Designs

Services / Software & Data

Data Systems

Pipelines, warehouses and reporting.

from $490

ServiceProject4–8 weeks
Multi-channel retailersAgenciesOperations

The systems that turn scattered data into decisions: pipelines that pull from your store, ads, CRM and accounting; a warehouse where it is clean and joined; and dashboards that answer the questions people keep asking in meetings.

We design the data model around the questions first, then build the pipelines and the reporting on Google Cloud, BigQuery and Looker Studio (or your existing stack). Everything is monitored, documented and handed over with training.

Choose your weave

Packages

Dashboard

Reporting Dashboard

One dashboard the whole team reads.

$490

one-time

Up to three sources connected to a Looker Studio dashboard, with every metric defined once and a handover session.

  • Data sourcesUp to 3
  • Warehouse
  • Scheduled pipelinesNative connectors
  • Dashboards1
  • Metric definitions
  • Monitoring & alerts
  • Training & handover
Timeline
1 week
Revisions
One round
Start a brief
Most Popular

Warehouse

Warehouse Starter

Your data, clean and joined, in BigQuery.

$1,490

50% deposit to start

A BigQuery warehouse with monitored pipelines from up to five sources, clean documented tables and three dashboards.

  • Data sourcesUp to 5
  • WarehouseBigQuery
  • Scheduled pipelines
  • Dashboards3
  • Metric definitions
  • Monitoring & alerts
  • Training & handover
Timeline
4–6 weeks
Revisions
Reviewed every sprint
Start a brief

Platform

Data Platform

Every source, every team, one model.

Custom

Scoped after a discovery call

Unlimited sources, a governed data model, dashboards for every team and the foundation for automation and AI, scoped after a discovery call.

  • Data sourcesUnlimited
  • WarehouseBigQuery or your platform
  • Scheduled pipelines
  • DashboardsUnlimited
  • Metric definitions
  • Monitoring & alerts
  • Training & handover
Timeline
6–10 weeks
Revisions
Reviewed every sprint
Book a call
CompareReporting Dashboard$490Warehouse Starter$1,490Data PlatformCustom
Data sourcesUp to 3Up to 5Unlimited
WarehouseBigQueryBigQuery or your platform
Scheduled pipelinesNative connectors
Dashboards13Unlimited
Metric definitions
Monitoring & alerts
Training & handover

What you get

  • Data modelPDF, diagramSources, entities, joins and the metrics defined once.
  • PipelinesScheduled cloud jobsScheduled, monitored ingestion from each source.
  • WarehouseBigQueryClean, documented tables and views in BigQuery or your platform.
  • DashboardsLooker StudioThe reports the business needs, with definitions on every metric.

How it works

  1. 01

    QuestionsWeek 1

    What the business needs to know, who needs it and how often.

  2. 02

    Model and sourcesWeeks 1–2

    Entities, metrics, source systems and access.

  3. 03

    BuildWeeks 3–6

    Pipelines, warehouse, quality checks and dashboards.

  4. 04

    HandoverWeek 6+

    Documentation, monitoring, training and a support period.

Included

  • Data model and metric definitions
  • Pipelines for the agreed sources
  • Warehouse set-up
  • Dashboards
  • Monitoring, documentation and training

Not included

  • Cloud and connector fees
  • Historical data cleanup beyond the agreed scope
  • Machine learning models (see AI & Automation)

What changes

  • One number for revenue, spend and margin across channels
  • Reports that update themselves
  • A foundation for automation and AI on top

What we need from you

  • Access to the source systems
  • One person who owns the definitions of the metrics
  • A cloud account, or we set one up under your billing

Service levels

Response time
Within one business day
Support
Email, WhatsApp, Video call
Guarantee
Unlimited revisions until it is right, within the agreed scope.
Tools we useBigQueryGoogle CloudLooker StudioCloud FunctionsPythonTypeScript

Loose threads

Questions,
answered

Shopify, WooCommerce, Amazon, Google Ads, Meta, GA4, HubSpot, Klaviyo, Xero, QuickBooks and most systems with an API. Spreadsheets too.

Tie the first knot

Let's start on data systems.

Start a brief
    Data Systems and Dashboards — LOOM Brand Designs | LOOM Brand Designs