Structured and Unstructured Data For Strategic Governance In Public Administration - From Evidence To Analytical Dashboards

The digital transformation of Public Administration has increased the need for evidence-based strategic governance supported by heterogeneous data. This pa-per proposes a conceptual and operational framework for integrating structured, semi-structured, and unstructured data to support analytical systems and Artifi-cial Intelligence (AI) applications oriented towards public decision-making. The framework structures the complementary (i) roles of structured data in perfor-mance measurement; (ii) semi-structured data in near real-time operational monitoring; and (iii) unstructured data in capturing perceptions and contextual information. It explicitly links data integration to interoperability standards and to ethical and legal compliance requirements, namely the AI Act and the Gen-eral Data Protection Regulation. The framework is operationalised through a design-oriented data and AI pipeline and illustrated by analytical dashboards and a public-sector chatbot demonstrator, showing how heterogeneous adminis-trative evidence can be transformed into decision-oriented governance insights. The contribution highlights the potential for increased transparency, efficiency, and trust when data integration is accompanied by robust governance practices and ethical-legal safeguards.