Key facts
| Organisation | BIM-UK Limited, now CappKind, an RICS regulated construction consultancy (commercial management, quantity surveying, project controls, programme management). |
|---|---|
| Role | Power BI and Business Intelligence Consultant |
| Dates | September 2020 to December 2021 (1 year 4 months) |
| Type | Contract; 2 renewals (Matthew's recollection) |
| Location | Leeds, England |
| Funding | Exclusively funded by BIM-UK's client Yorkshire Water, who had engaged Matthew directly in 2019. |
| Status | To confirm — old CV title is Data and Analytics Consultant with no end date; LinkedIn title and dates used. |
| Knowledge base | Personal\CV\kb\employment\2020-09-bim-uk.yaml |
Summary
Yorkshire Water — capital programme reporting
BIM-UK, now CappKind, is an RICS regulated construction consultancy managing large capital programmes. The engagement was exclusively funded by one of its clients, Yorkshire Water, returning a year after the 2019 direct engagement. BIM-UK controlled Yorkshire Water's large capital projects through stage gates, and the reporting tracked progress and cost on every project at each gate over time.
- Yorkshire Water supplied the data as Excel extracts. There was no direct access to the source systems.
- Azure Data Factory loads the extracts into an Azure SQL Database and stages them, and the warehouse builds the facts and dimensions.
- Type 2 slowly changing dimensions track each project's movement through the gates over time, the most complex part of the model.
- First output. Automated the existing Excel reporting over a live connection to the Power BI dataset. PivotTables and CUBE formulas rebuilt the worksheets so the whole pack updates from a single date selection.
- Second output. Replaced the existing spreadsheets with a suite of Power BI reports over the same model. Excel and Power BI share a single version of the truth.
Achievements
- Funded exclusively by Yorkshire Water for the full sixteen months, the client returning a year after the 2019 engagement. Renewed twice and asked to stay. Left only on being recruited back by Inciper.
- Modelled Yorkshire Water's capital programme stage gates as Type 2 slowly changing dimensions, tracking every project's progress and cost at each gate over time.
- Built the warehouse with Azure Data Factory loading Yorkshire Water's Excel extracts into Azure SQL, staged and modelled into facts and dimensions, with no direct access to the source systems.
- Automated the existing Excel reporting packs over a live connection to the semantic model, using PivotTables and CUBE formulas so the whole pack updates from a single date selection.
- Replaced the legacy spreadsheets with a suite of Power BI reports over the same model, giving Excel and Power BI a single version of the truth.
Technologies
Power BI (dataset, reports), Azure Data Factory, Azure SQL Database, Excel cube formulas (CUBEVALUE, CUBEMEMBER), DAX.
Open questions
- Title and end date discrepancy with the old CV (Data and Analytics Consultant, no end date) stays flagged on the master table.
Sources
Matthew's walkthrough (8 October 2026), the LinkedIn experience capture of 5 October 2026, and cappkind.com for the company description.