Data architecture consultancy

Building data platforms on Microsoft.

Dimensional models, Azure Data Factory, Microsoft Fabric lakehouses and Power BI. Fifteen years on SQL Server.

Read the case study Get in touch
Power BI report page over a Microsoft Fabric lakehouse: rating progress, results by year and accuracy
Page one of the Chess Data Platform report in Power BI, over a Fabric lakehouse.
15+years on SQL Server, from on-prem estates to Azure and Fabric
6 moaverage initial contract
36+ moaverage engagement once extended
100%renewal rate with top clients

What we do

Platform architecture

Bronze, silver and gold lakehouses on Microsoft Fabric, with a Kimball star schema on top.

Analytics and BI

Power BI semantic models and reports, built as code and deployed by API.

Modernization

SSIS, SSRS and on-prem SQL Server estates moved to Azure with the reports kept live.

Portfolio

Chess Analytics dashboardAny chess.com profile, analyzed in the browser.Open the dashboard
Chicago Sports LeaguesFive league operators, one searchable page, refreshed daily.Browse the leagues
Activate Global League StatsA season of a global league, scraped and modeled.Open the almanac

Tools

  • Microsoft Fabriclakehouses, pipelines, Spark, Direct Lake
  • Azure Data Factoryorchestration, capacity bracketing
  • Azure SQL and SQL Server15+ years, T-SQL, tuning
  • Power BITMDL models, PBIR reports, DAX
  • Dimensional modelingKimball, conformed dimensions
  • PySpark and Delta Lakesilver and gold transforms
  • SSIS, SSRS, SSASthe estates being modernized
  • Pythondeploy scripts, data quality, generators
  • GitHubbranches, pull requests, squash merges
  • Azure and AWScloud foundations
  • Team leadershiparchitecture ownership, mentoring

Contact

Data platform and BI engagements, from a scoped assessment to a full build, on contract or embedded in a client team.

Get in touch Portfolio
Also on this site Side projects: the arcade and the tools.