Capabilities

Everything we actually work with

This is the full list, for anyone who arrived looking for something specific. It is what we build with — what we sell is the four things on the previous page, because a system beats a script every time.

Reporting & business intelligence

  • Power BI — desktop, service, gateways, workspaces
  • Microsoft Fabric — lakehouse, warehouse, pipelines
  • DAX measures, calculation groups, time intelligence
  • Power Query and M transformations
  • Row-level security and role-based access
  • Paginated and print-ready reports
  • Custom dashboards built to a brief, not a template
  • Looker Studio, and Excel where Excel is genuinely right

Data architecture & engineering

  • Data architecture and dimensional modelling — star schemas, fact and dimension design
  • Slowly changing dimensions, surrogate keys, conformed dimensions
  • SQL scripts — stored procedures, views, functions, migrations
  • T‑SQL, PostgreSQL, MySQL and Snowflake SQL
  • ETL and ELT orchestration, incremental refresh, partitioning
  • Warehouses on Microsoft Fabric, Snowflake, Postgres and Azure SQL
  • Deduplication, reconciliation and data-quality checks
  • Versioned, reviewable transformations

Python & scripting

  • Python scripts for data processing and scheduled jobs
  • pandas pipelines, cleaning and reshaping
  • FastAPI services and internal endpoints
  • PDF, Excel and document generation from raw data
  • API integrations and authenticated data pulls
  • Google Apps Script for Sheets-based systems
  • Excel VBA where a familiar front end matters
  • Logging, retries and alerting built in

AI systems & workflows

  • AI workflow automation using the OpenAI and Claude APIs
  • Document extraction, classification and routing
  • Summaries and drafted write-ups generated from real data
  • Narrative sections in reports, produced from the numbers rather than guessed
  • Retrieval over your own documents and records
  • Prompt and output validation, so results stay checkable
  • Cost caps and rate limiting, so the bill cannot surprise you
  • Wired into the tools your team already uses

Automation platforms

  • Zapier, Make and Power Automate
  • Pure Python automation where a platform would only add cost
  • Webhooks, schedules and event triggers
  • Error handling, retries and dead-letter handling
  • Alerting, so nothing fails silently
  • Spreadsheet systems that consolidate and validate themselves

Web portals & applications

  • Custom web portals with unlimited logins and role-based access
  • Next.js and React front ends in TypeScript
  • Node.js and Python back ends
  • Supabase and Postgres, with auth and roles wired in
  • Embedded and rebuilt analytics inside your own app
  • Self-service file upload with validation and mapping
  • Branded domains, and deployment you own
A word on how we sell this

We do not sell these by the hour

You can hire plenty of people to write a SQL script or a Python job, and if that is genuinely all you need, that is a reasonable thing to buy. What we build is the system around it — the thing that keeps running once the script is written, so nobody has to call a developer the next time the data moves. That is why the pricing is per outcome rather than per hour.

See how it is priced

Looking for something not on this list?

Ask. If it is adjacent to data, reporting or automation, the answer is usually yes — and if it is not something we should be doing, we will say so and point you somewhere better.

Book a 30-minute call What we build