Key facts
| Organisation | Metro Rod, drainage services through a national franchisee network |
|---|---|
| Role | Data and Analytics Consultant |
| Dates | April 2019 to September 2019 (6 months) |
| Type | Contract; 1 renewal |
| Location | Macclesfield, Cheshire |
| Relationship | Formerly part of Spice PLC and the Enserve Group, so an existing relationship from Matthew's Spice and Enserve years. |
| Status | Confirmed — sources agree |
| Knowledge base | Personal\CV\kb\employment\2019-04-metro-rod.yaml |
Summary
BI strategy and an Azure analytics platform for Metro Rod, with row level security carrying targeted reporting out to the franchisee base.
Achievements
- Renewed once during a six month engagement, returning to a business known from the Spice and Enserve years.
- Developed a business intelligence strategy meeting the needs of the organisation.
- Designed a BI architecture using Azure SQL Data Warehouse, Azure Analysis Services and Power BI.
- Implemented row level security supporting targeted reporting to the Metro Rod franchisee base.
- Designed and delivered an Azure Analysis Services Tabular model.
- Developed DAX calculated columns and measures.
- Implemented Analysis Services partitioning using M functions to minimise model processing time.
- Implemented scheduled near real time Tabular model processing using Logic Apps and Azure Data Factory.
- Designed a Power BI taxonomy supporting the reporting requirements of the enterprise.
- Designed a Power BI security model supporting the reporting requirements of the enterprise.
- Designed and delivered a Power BI application with live connection to Azure Analysis Services for internal users.
- Published Power BI applications with live connection and row level security for the Metro Rod franchisee base.
- Provided spatial analysis using the Power BI Mapbox custom visual.
- Provided Power BI drill through reports.
Technologies
Azure SQL Data Warehouse, Azure Analysis Services, DAX, Power BI, Logic Apps, Azure Data Factory.
Sources
The old CV (CV-MD-02.docx) and the LinkedIn experience capture of 5 October 2026. Relationship and relevance ratings agreed with Matthew, 8 October 2026.