Case study of data warehouse development for monitoring of energy consumption in public buildingsKovačić, Goran (Avtor) Brumen, Boštjan (Mentor) data warehousedimensional modelstar schemasnowflake schemaETL processThe goal of this case study was to examine which implementation of the data warehouse will yield better results in the observed scenario – monitoring of energy consumption in public buildings. Data warehouse (DW) is a type of database created with the goal of preparing data for analysis and reporting. We implemented two versions of DW, one based on the star and the other on the snowflake schema model. Series of tests were conducted to evaluate implemented solutions. Statistical analysis showed that for the observed scenarios, implementation based on snowflake schema performs better, in both shorter ETL execution time and smaller size of DW.G. Kovačić20162016-06-06 16:01:19Magistrsko delo/naloga60033sl