Development of the data warehouse model for public authorities accounts in Croatia

Abstract

An ongoing process of modernization, rationalization and implementation of public administration reform, in order to increase efficiency and economy, would be infeasible without improvement and continuous investments in new information technology. The main task of public administration is to be a service to citizens and legal entities from their domain. With the purpose of improving its functions, public authorities must have complete information in order to increase the quality and speed of information exchange with all stakeholders in the process. This paper describes a model of data storage. It describes the process of building and organization of data warehouse and ETL process of extracting, cleansing and transformation of data in a multidimensional data warehouse model, which is based on the metadata model. Furthermore it describes a concept and basic methods used in the development of business intelligence systems for the construction and use of a data warehouse. In addition it states options for the analysis of the data in the warehouse, which are shown based on dimensional storage concept, and it gives guidelines for future development.