The city's reports, in dashboards

A city’s reports are counted by status and by service, and that count is read on a dashboard. When the dashboard and the platform do not give the same number for the same status, the conversation is spent working out which of the two is right, and the dashboard stops being opened.

The platform is Mejora tu Ciudad, by Radmas Technologies, S.L., and we work on its development side by side with their team, here on the analytics of the reports: the dashboards, the data that feeds them and the training to maintain them.

The dashboards went down to the detail being asked for. We built them and extended them with the breakdowns and the levels of detail each team needed to see.

The data matches the platform. We adjusted the tables that feed the analytics to the real reading of the operation, with the dates built in, and we checked the figures against the platform until they matched, status by status and service by service.

The daily load ended up fast and steady. We strengthened it, and on top of it we left a proposed organisation of the history that would allow the volume of reports to keep growing without queries losing their speed.

The training goes with the work. We left a path with material on the tool and on the data process, so that more people on the team build and maintain their own dashboards.

The dashboard and the platform give the same figure. The load comes in every day, fast and steady. And whoever needs the next dashboard has the path to build it in front of them.