Capabilities

Human-led. AI-enabled.

Most analytics engagements end the moment the consultants leave. Ours don't. We stay. AI lets a lean team move like a big one — drafting transforms, building dashboards, writing alerts — but every change is reviewed and shipped by a human who's accountable to you. You are never left in the dark.

How it works

The stack, end to end.

Six layers, all off-the-shelf, wired together deliberately. Nothing bespoke that you can't walk away with.

LayerToolWhat it does
Data warehouseBigQueryStores raw and cleaned client data. One project per client, fully isolated.
TransformsDataformSQL pipelines from raw → cleaned → dashboard-ready, version controlled and scheduled.
Version controlGitHubEvery transform lives in a repo. Every change is a reviewable diff before it ships.
DashboardsMetabaseClient-facing reporting. Per-client collections, per-client permissions, per-client logins.
HostingRailwayRuns the Metabase app. Cheap, stable, no infra team required.
Force multiplierClaude (Anthropic)Drafts SQL, builds dashboards, writes alerts under our direction. We review every change and own the outcome.
Principles

How we think about data.

Opinions earned from engagements, not from textbooks.

01

Show the variance, not the zero.

Occupancy doesn't live between 0% and 100% — it lives between 85% and 95%. If the difference between a great month and a bad month doesn't show up on the chart, the chart isn't doing its job. Axes get scaled to where the business actually operates.

02

Dashboards read only from deliberate tables.

Nothing in production queries intermediate models. Every dashboard sources from a dashboard-layer table — a deliberate, reviewed transformation. This keeps surprise breakages out of client views when upstream data shifts.

03

If a human does it twice, automate it.

Sending the same follow-up email. Checking the same report each morning. Reconciling the same two spreadsheets. The second time through is the signal. The third time through is embarrassing.

04

The stack is the deliverable.

No lock-in, no black box. Your GCP project. Your GitHub repo. Your Metabase instance. If we vanished tomorrow, the system keeps running — and any competent engineer can pick it up.

05

A human is always on the other end.

AI helps us build and maintain faster than a team our size has any business doing. But it doesn't replace us. When you send a question, a person reads it. When a change ships, a person reviewed it. You are not being handed off to a model.

By industry

What we deliver.

Different problems, same machinery. Here's what the work actually looks like in each vertical we serve.

Property Management

Delinquency, end to end.

Automated chases by tenure and balance. Occupancy and renewal dashboards that scale with your portfolio. Alerts when a property starts slipping, not after the month closes.

Insurance Brokers

Quote pipeline, without the inbox.

Structured submission flows. Information collection that doesn't require chasing. Carrier coordination tracked in one place, visible to the whole team.

CPG Brands

Reporting that pays attention.

Daily and weekly performance dashboards. Anomaly alerts surfaced by AI, not by someone squinting at a line chart. Conversion-rate optimization grounded in what your data actually says.

Ready to figure it out?

Tell us the messy part. That's usually where the work starts.

chris@consultusai.com