Data & Automation Analyst — Portfolio Build

CityHire Fleet & Stock IntelligenceSYNTHETIC DATA

Nine analytics layers on one 1,612-asset fleet — fleet KPIs, seasonal forecasting, network analysis, funnels and a recommendation engine, all filterable by depot and category. Modelled on City Hire's real product catalogue (24 categories, 220+ real model names from cityhire.co.uk).

Data grounding: category structure and 220+ product/model names were extracted from the public product catalogue at cityhire.co.uk on 2026-07-15. Important: all fleet quantities, costs, dates, utilisation, orders, repairs, approvals and transfers are SYNTHETIC — generated for this demonstration, not City Hire's real operational data.
Companion deliverables: SQL analysis layer, a formula-driven Excel workbook, a Power BI semantic model, local ML models, and a live Azure PostgreSQL database. Built by Anthony Apollis.
Ask about CityHire Intelligence
Hi! Ask me about the fleet, the depots, the ML models, the recommendation engine, or the tech stack.