Sam Pearce

Mishcon de Reya, one of the UK’s leading law firms, built an in-house, end-to-end legal intelligence and capacity management platform that transforms workforce planning from retrospective reporting to forward-looking, proactive capacity forecasting. It replaces the firm’s legacy system, integrating operational, financial, and personnel data into one trusted source of insight. Automated data pipelines and a unified semantic model feed interactive Power BI dashboards, giving leaders timely visibility into capacity versus utilisation across the firm. Handling thousands of daily time entries from lawyers, this scalable and fully automated platform now prompts fee earners to submit upcoming availability, turning timesheet data into accurate capacity forecasts. As a result, partners and managers can anticipate workload peaks, allocate resources more effectively, and optimise utilisation by mitigating bottlenecks ahead of time. The session will show how a holistic data strategy – from ETL and analytics engineering to intuitive BI – delivered real-world adoption and efficiency gains in a large professional services environment, highlighting the shift from after-the-fact reporting to a culture of continuous, insight-driven capacity planning at Mishcon de Reya.