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.
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.
What that looks like in practice
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
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
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
- 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
Capacity & Cost Review
- 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
Team Workshop
- 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
Measure first, change second, hand over properly
Discovery call
A free 30-minute call to understand the problem and whether I'm the right fit.
Measure
I look at what's really there (cost, failures, how changes are made) before proposing anything.
Build
Short iterations with regular demos. Every change goes through source control and review.
Handover
Code, documentation and runbooks stay in your own repository. You own all of it.
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
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.
- ✉ marc@ritchiedesignservices.co.uk
- in linkedin.com/in/-marcritchie
- ⌖ Glasgow · working UK-wide & remotely