Ritchie Design ServicesData & BI consultancy Book a call
Microsoft Fabric & Power BI · Glasgow & UK-wide

A data platform your business
can trust, audit and afford.

I design, build and run data platforms on Microsoft Fabric and Power BI for mid-sized firms. You deal with me directly from the first call to handover. Nothing gets passed between a salesperson, an architect and a delivery team.

20+ yearsworking on the operational processes behind the numbers
120+changes released through review on one client platform
One personscoping, building and supporting your platform
Services

What I can help with

My core stack is Microsoft. The fundamentals behind it (dimensional modelling, dbt, version control and automated testing) work on any platform.

Fabric platform build & rescue

Separate environments, source control and automated deployment. I can set these up from scratch or untangle an existing workspace.

Data modelling & warehousing

Star schemas and tested dbt models, so every report works from the same numbers.

Monitoring & reliability

Alerts and a platform health report, so failures are caught before anyone in the business notices them.

Capacity & cost review

Measure what each item on your Fabric capacity really costs, then cut the waste.

Migration to Fabric

Moving SSIS packages and older SQL Server reporting onto Fabric without breaking the reports people rely on.

AI readiness

Preparing semantic models for Copilot and data agents, then piloting them with measured accuracy and cost.

Power BI reporting

Reports built on one governed model rather than a scatter of one-off datasets.

Team training

Git, CI/CD, dbt and AI-assisted development with tools like Claude Code, taught on your own platform.

I measure before I change anything, and I leave you with a platform you own and can run.

Selected work

What that looks like in practice

Case study · Engineering & project services

From fragile reports to a production data platform

A UK engineering and project-services group had reporting built up over time in Microsoft Fabric. There was no safe release route, loads could fail without anyone being told, and connections broke every week.

  • Release process with review and an approval gate
  • Tested dbt models, so reports agree with each other
  • Alerts on failed or stalled loads
  • Capacity cost measured per item, and an AI pilot with a measured cost
Read the full case study →
Example · Project controls

The weekly planning report that now runs itself

A weekly planning report depended on manual Primavera P6 exports feeding an Excel workbook that had grown so large it was unstable. Someone had to work late every week to hit the deadline.

  • Automated pipeline from the P6 APIs into a database
  • Data modelled and tested with dbt
  • More accurate data, and a report that runs itself
  • Planners back on planning, and nobody working late
Ways to work together

Fixed-price starting points

Three fixed-scope options let you see how I work before committing to anything bigger. Each one has a clear scope and a price agreed up front.

Fabric & Power BI Health Check

£2,500 + VAT, fixed
Around 4 days · written report & walkthrough
  • Environments, source control and how changes reach Production
  • Monitoring: what fails silently today
  • Connections and access: personal logins vs service accounts
  • Model and DAX quality
  • A prioritised fix list with effort estimates
Enquire

Capacity & Cost Review

£1,950 + VAT, fixed
Around 3 days · written report
  • Capacity use per item, per hour, from Microsoft's own metrics
  • How much headroom you really have
  • Wasted work: idle steps, over-frequent refreshes
  • Whether you could move up or down a capacity size
Enquire

Team Workshop

£1,500 + VAT, per day
On-site or remote · up to 8 people
  • Git & CI/CD for Fabric and Power BI
  • dbt fundamentals for analysts
  • AI-assisted development with Claude Code
  • Run on your own platform and data
Enquire
Platform builds, rescues, migrations, AI pilots and contract work depend on what you already have, so I quote them after a discovery call. Many clients start with a Health Check. If you go ahead with the work it recommends within three months, its fee comes off the bill.
How it works

Measure first, change second, hand over properly

01

Discovery call

A free 30-minute call to understand the problem and whether I'm the right fit.

02

Measure

I look at what's really there (cost, failures, how changes are made) before proposing anything.

03

Build

Short iterations with regular demos. Every change goes through source control and review.

04

Handover

Code, documentation and runbooks stay in your own repository. You own all of it.

About

Hi, I'm Marc Ritchie

I started out in design, planning and project management on North Sea platforms and engineering projects, then moved into data. More than 20 years on, I still understand the operational processes behind the numbers. That's why I build platforms around how your teams actually work.

Today I'm an independent data and BI consultant working through my own company, Ritchie Design Services Ltd. I'm based in Glasgow, work UK-wide and remotely, and speak professional working Spanish.

  • Ritchie Design Services LtdData consultant · 2008 – present
  • Power BI & data warehouse consultancyTier-1 UK contractor · 2024 – present
  • UK engineering & project-services groupBusiness Analyst, Project Engineer, Instrument Designer · 2006 – present
  • Lloyd's Register · Talisman Energy · ConocoPhillipsDesign, planning & data roles · 1999 – 2006
Microsoft FabricPower BIdbt T-SQLPython / PySparkSQL Server / SSIS Azure DevOpsPrimavera P6Claude Code
Get in touch

Running on Fabric, or planning to?

Tell me a bit about what you're trying to fix. I'll reply within one working day to arrange a free 30-minute call.

I'll only use your details to reply to your enquiry. See the privacy notice.