Design of the Technological Solution for the PSIS Service
Open Administration of Catalonia (AOC)
In order to offer quality services to whom and when they are needed, it is desirable to establish an analysis model that meets the following characteristics:
Fully automatable.
Replicable with a determined periodicity.
Transferable to the municipalities of the region to improve management.
Adapting to the needs of the region's population.
In addition to the public access sources, a process was initiated to reach agreements with the municipal entities that manage part of the data necessary for the construction of the analysis model. Many of these data are those that refer to social variables and agreements are necessary to access the information.
In parallel, the processes of extraction and transformation of the information to be stored in a structured way in a BI tool are developed, which must allow the dynamic analysis of the information and the automatic generation of reports.
Finally, the consulting team receives this information to apply its experience and knowledge in the drafting of recommendations for local entities.
An analysis model combining health and social data is available and used by the main health and social service providers in the territory. Planning and management decisions are made, in part, on the basis of the information provided.
In addition, an extraction-structuring-analysis model is available that can be replicated in other territories and even scaled to a national level.
We work so that things go well