MODELLING A BUSINESS INTELLIGENCE SYSTEM FOR SCHOOL MANAGEMENT ON LOCAL GOVERNMENT LEVEL Miroslav Huđek, Zoran Savić, Dragan RadovićOriginal scientific paper This paper presents one approach to logical modelling of business intelligence system which should help school management at local level. The use of automated tools for decision makers becomes essential due to the exponential increase of data from several and dispersed sources. As the basis for the creation of a model, Balanced Scorecard method is used, whose dimensions are slightly modified to be suitable for the needs of school management. Created is a data warehouse with defined fact tables and dimension tables, and proposed is a technical solution, adequate to the needs and size of local government. For the application of the model, any founder (local or regional administration) should enter master data, realized values and the scope of activities for its school system, and as a result, through the OLAP cubes, it is possible to analyse main indicators in financing, efficiency and excellence. Keywords: balanced scorecard; business intelligence; data warehouse; local government; OLAP cubes; school managementModeliranje sustava poslovne inteligencije za upravljanje školstvom na razini lokalne uprave Izvorni znanstveni članak Ovaj rad predstavlja jedan pristup logičkom modeliranju sustava poslovne inteligencije koji bi trebao pomoći u upravljanju školama na lokalnoj razini. Uporaba automatiziranih alata za donošenje odluka postaje bitno zbog eksponencijalnog porasta podataka iz nekoliko i raspršenih izvora. Kao osnova za izradu modela koristi se Balanced Scorecard metoda, čije dimenzije su neznatno modificirane da budu pogodne za potrebe upravljanja školom. Stvoreno je skladište podataka s definiranim činjeničnim tablicama i tablicama dimenzija te je predloženo tehničko rješenje, odgovarajuće za potrebe i veličinu lokalne samouprave. Za primjenu modela, svaki osnivač (lokalna ili regionalna uprava) treba unijeti matične podatke, ostvarene vrijednosti i opseg aktivnosti za svoj školski sustav, a kao rezultat toga, kroz OLAP kocke, moguće je analizirati glavne indikatore u financiranju, učinkovitosti i izvrsnosti.

This paper aims to investigate the influence of expense item 'Energy' on excellence of school operation. The study was conducted on a sample of 33 primary and 13 secondary schools established by the County of Varaždin, in the area of financing decentralised functions. The following study task was set: 'Determine the Model of influence of expense item "Energy" on excellence of school operation' . Based on research that incorporated the Pareto Principle and descriptive statistics in the area of quartile, correlation and regression analysis, a model for determining the influence of expense item 'Energy' on excellence of school operation in primary and secondary education was provided for the area covered by local government. Based on the results and the generated model, suggestions were made for the improvement of the primary and secondary education system at local government level of operation.