Tools of Business Intelligence for managing Istat internal processes

Abstract

In this paper, the analysis of data extracted from the Italian National Institute of Statistics (Istat) administrative database, called Urbi Smart (a structured collection of data and information managed by an organization, accessible only by its employees and used for business purposes, meaning for internal use) is used to showcase the power of the Business Intelligence for increasing the efficiency of the management system. As part of Business Intelligence process, organizations collect data from internal IT systems and external sources, prepare it for analysis, run queries against the data and create data visualizations, Business Intelligence dashboards and reports to make the analytics results available to business users for operational decision-making and strategic planning.

The information on welfare benefits selected from Istat administrative database consists of a series of variables that include employee identification data (registration number, profile, personnel plan), administrative data relating to subsidy applications and accounting data (amount submitted, amount allocated).

The goal of the analysis is to support a rational and equitable distribution of the funds allocated for employee welfare benefits. By examining patterns in subsidy requests and allocations, the BI process enables evidence‑based decisions that improve transparency, optimize resource use, and strengthen the overall management system.