Reference: minimum viable data stack for a $1M-$10M Canadian service business (2026, C$100-C$500/month)

reference·Scope: business·Status: current

Created 2026-05-22

For a Canadian service business at $1M-$10M revenue, 5-50 staff, currently living in QuickBooks + spreadsheets + a half-used CRM:

System of record per data type. Don't replace QuickBooks or your vertical SaaS; declare them authoritative for their domains.
Operational database — managed Postgres (Supabase / Neon / Render / Crunchy Bridge): $20-50/month
Lightweight ingestion — dlt (OSS) or Airbyte/Fivetran (managed). Pull from QuickBooks, vertical SaaS, Stripe, Mailchimp, GA: $0-$200/month
Transformations — dbt-core (free) running locally or in GitHub Actions, or dbt Cloud Developer ($100/month)
Analytics engine — DuckDB (free, in-process) or BigQuery (pay-per-query, often <$30/month at SMB scale)
Dashboards — Evidence.dev (free, code-based, version-controlled), or Metabase OSS (~$85/month managed). Avoid Tableau/Power BI at this stage.
Customer-facing data tools (optional) — thin internal-only Next.js or Retool app (~$10/user/month)

That's roughly the cost of one underused enterprise CRM seat.

Single customer view across QuickBooks + vertical SaaS + email + payments
Cohort retention analysis the vertical SaaS can't do
Marketing attribution joining ad spend → closed revenue
Daily-ops dashboards (Lovett Services-style — see Research brief: The Dataset is the Product — when a service business should own its data (piece 12 of 15))
Clean export path for the next system, whatever it is
Better privacy posture: answer a PIPEDA SAR or Law 25 portability request without opening five SaaS tools

Sub-$500K revenue
Solo operator
Owner planning to sell or retire within 18 months
Pre-product-market-fit business model (the schema will change weekly and break everything)
No one in the business — including agency partners — comfortable with SQL