An analytics platform that measures the impact of Barcelona's youth services network across its ten districts.

We unified the registration application, service planning in Google Docs, a central SharePoint repository and a configuration Excel with the dimensions. Every report works on the same version of the data.

The scripts prepare the data for enquiries, advice, activities and specific programmes: they fix encodings and special characters, normalise categories, correct wrong classifications and apply each programme's own logic.

A second layer in Power BI types the dates, creates shared dimensions (gender, age, area, format, school term) and unpivots the records so they can be cross-referenced. The relationships between facts and dimensions ensure every report filters the same way.

They include a ratings module (average score per activity, service and thematic block, and the evolution of satisfaction). When the scripts run, the data is published to SharePoint and a refresh updates every report from any device, with no manual step.

The extraction, cleaning and preparation that consumed hours at every quarterly close are gone. The report is ready when the team opens it.

All ten districts share a unified view of the network, accessible to every local team from any device.

By service, team, district, school, activity type, gender, age and month. Each programme has its own report, adapted to its recording logic.

New programmes, services or data sources join the same flow without starting over.

The relationship did not end when it went live. We keep working with the team on an ongoing basis, extending the reports according to what each service needs to measure.