Business Intelligence Exploitation for investigating territorial Systems, methodological Overviews and empirical Considerations

Civil servants and service managers need accurate and up-to-date information about the population to improve the service provision models and therefore to meet the citizens higher and higher expectations in the current dynamic economic and social context. Public Administrations discovered the potential of using administrative archives to obtain accurate information about the population. Administrative archives contain a valuable information asset which describes accurately and extensively the population. The exploitation of such asset requires Public Administrations to integrate information spread across several departments, to address data quality issues arising when administrative data is used, and to develop analytical and reporting models. Public Administrations started using the Data Warehouse / Business Intelligence approach which has extensively been used in the private sector for accomplishing similar tasks. This paper will investigate how existing methodologies for building Data Warehouses can be applied to the public sector scenario, some public sector specific issues will be explored, and some case studies highlighting possible solutions will be presented.