The city of Padova is the the third in the region of Veneto and fourteenth nationwide regarding the population.
The city is rich of culture and history and is an important logistics hub, while being an important industrial areas in Europe.
The municipality of Padova has played an important role for many years among the Italian municipalities with regard to the renewal process within the Public Administration, through the implementation of innovative projects that allow to approach and improve the relationship between citizens and the public institutions.
The project encompass design and implementation of a Data Warehouse, a series of procedures for data collection from different sources, and a solution for query analysis.
A portion of the final result of this project is visible on the website of the Municipality of Padova, that are some reports published on the web, queried by the public through which you can download the pdf file of the original act. Reports include:
The municipality of Padova decided to use Pentaho as the tool to create the XML files and saving the required data in the data warehouses of the entity, to take advantage of the AVCP's request to transmit the data related to public contracts of the suppliers.
By Adopting Pentaho and implementation of the analytic tools, the municipality overcame the limits of their static way of data representation and started providing a dynamic data set, while adhering to the legal obligations for accessibility and ease of use of the data. In addition the process of data publication, which was managed with manual intervention, is now automated, resulting in significant cost reduction for the organization. The benefits for the public as well should not be neglected, where they have immediate access to decisions and policies communicated by the administration.
Going beyond the legal obligations, through the creation of the Data Warehouses (Transparency and Tenders), the municipality has a full Business Intelligence tool in place to support their strategic decisions and organizational policies, since a portion of the data is internal and therefore can help them with analysis such as forecasting, budgeting, and so on.