LUDOSàAW DRELICHOWSKI 6WUHV]F]HQLH
W pracy omówiono zrealizowany w dwu fazach program badawczy dotyczący zastosowaĔ hurtowni danych i narzĊdzi BI we wspomaganiu zarządzania finansami gmin. W pierwszym etapie realizowanym w latach 2012–2014 opracowano hurtowniĊ danych z pozyskaniem informacji zawartych w Banku danych lokalnych i wykorzy-stano je w analizie porównawczej wybieranych do banchmarkingowych analiz porównawczych grup gmin oraz makroregionów. W drugiej fazie badaĔ realizowanej w latach 2014, 2015 opracowano HurtowniĊ Danych II Generacji, którą zaprojekto-wano i oprogramozaprojekto-wano na podstawie zawartoĞci plików sprawozdaĔ finansowych JST, uwzglĊdniających agregowanie informacji finansowych do poziomu dziaáów i pa-ragrafów, co zapewnia moĪliwoĞü ich efektywnego wykorzystania w systemie wspomagania decyzji finansowych.
6áRZDNOXF]RZH DQDOL]DV\VWHPRZDEHQFKPDUNLQJMHGQRVWHNVDPRU]ąGXWHU\WRULDOQHJRQDU]ĊG]LD %XVLQHVV,QWHOOLJHQFH %, ZDGPLQLVWUDFMLSXEOLF]QHMSODQRZDQLHEXGĪHWyZ-67 :SURZDG]HQLH
0HFKDQL]P\SRGHMPRZDQLDGHF\]MLZMHGQRVWNDFKVDPRU]ąGXWHU\WRULDOQHJRPDMąFHFKĊZ\ PXV]DQLD SRV]XNLZDQLH NRQVHQVXVX SRPLĊG]\ DPELWQ\PL RF]HNLZDQLDPL F]áRQNyZ ORNDOQ\FK VSRáHF]QRĞFL D RJUDQLF]HQLDPL Z\QLNDMąF\PL ] GRVWĊSQ\FK ]DVREyZ ± ]ZáDV]F]D ILQDQVRZ\FK %XGRZDQLHEXGĪHWX-67QDNROHMQHODWDSROHJDJáyZQLHQDLGHQW\ILNDFMLW\FKSDUDPHWUyZNWyUHVą VWDELOQHRUD]W\FKNWyUHFKDUDNWHU\]XMąVLĊQHJDW\ZQ\PLNRQVHNZHQFMDPL±GRVWDUF]DMąFQLĪV]\FK ĞURGNyZZVWRVXQNXGRSU]HZLG\ZDQ\FKZEXGĪHFLH0RJąZ\VWąSLüUyZQLHĪGRGDWNRZHREFLąĪH QLD EXGĪHWX ] XZDJL QD Z\ĪV]\ SR]LRP NRV]WyZ HNVSORDWDFML ZSURZDG]RQ\FK GR XĪ\WNRZDQLD ]DVREyZZVWRVXQNXGRRWU]\PDQ\FK]W\WXáXLFKHNVSORDWDFMLGRFKRGyZ>@
3UREOHPDW\ND]DU]ąG]DQLDILQDQVDPL-HGQRVWHN6DPRU]ąGX7HU\WRULDOQHJR -67 SRVLDGDRE V]HUQHUHJXODFMHUR]ZLą]DĔIRUPDOQR±SUDZQ\FKNWyUHSUHF\]\MQLHXVWDODMąRERZLą]XMąFH]DVDG\ X]\VNLZDQLDGRFKRGyZLSRQRV]HQLDZ\GDWNyZQD]DGDQLDZáDVQHL]OHFRQH-671DXFKZDODQLH EXGĪHWyZGRUPLDáDZSá\Z]DVDGD]UyZQRZDĪHQLDEXGĪHWXMHGQRVWHNVDPRU]ąGXWHU\WRULDO QHJR Z F]ĊĞFL ELHĪąFHM RNUHĞORQD Z SU]HSLVDFK XVWDZ\ ] GQLD VLHUSQLD U RILQDQVDFK SXEOLF]Q\FK =DVDGD WD PLDáD ]DVWRVRZDQLHSRUD]SLHUZV]\ ZU: P\ĞO WHM ]DVDG\RUJDQ VWDQRZLąF\MHGQRVWNLVDPRU]ąGXWHU\WRULDOQHJRQLHPRĪHXFKZDOLüEXGĪHWXZNWyU\PSODQRZDQH Z\GDWNLELHĪąFHVąZ\ĪV]HQLĪSODQRZDQHGRFKRG\ELHĪąFHSRZLĊNV]RQHRQDGZ\ĪNĊEXGĪHWRZą ]ODWXELHJá\FKLZROQHĞURGNL
&]\QQLNLHP ]DSHZQLDMąF\P VWDELOL]DFMĊ SROLW\NL EXGĪHWRZHM -67 MHVW VWRVRZDQLH ZLHOROHW QLHJRSODQRZDQLDILQDQVRZHJRZ\NRU]\VW\ZDQHJRMDNRPHWRGDDNW\ZQHJRZSá\ZDQLDQDSU]\V]áH Z\GDU]HQLDSRSU]H]LGHQW\ILNDFMĊSUREOHPyZRFKDUDNWHU]HGáXJRSODQRZ\PLNLHURZDQLHIXQGXV]\
RUD]]DVREyZQDLFKUR]ZLą]\ZDQLHZRNUHVDFKGRODW:LHOROHWQLSODQILQDQVRZ\ :3) REHM PXMH RNUHV URNX EXGĪHWRZHJR RUD] FR QDMPQLHM WU]HFK NROHMQ\FK ODW EXGĪHWRZ\FK FR VWDQRZL RERZLą]XMąF\Z3ROVFHRNUHVZLHOROHWQLHMSURJQR]\EXGĪHWyZ-673RQDGWR:3)REHMPXMHSUR JQR]Ċ NZRW\ GáXJX VWDQRZLąFą F]ĊĞü ZLHOROHWQLHM SURJQR]\ ILQDQVRZHM NWyUą VSRU]ąG]D VLĊ QD RNUHVQDNWyU\SODQXMHVLĊ]DFLąJDü]RERZLą]DQLD>@
%DGDQLD GRW\F]ąFH UyĪQ\FK DVSHNWyZ NV]WDáWRZDQLD SR]LRPX GRFKRGyZ L Z\GDWNyZ JPLQ ZXMĊFLXG\QDPLF]Q\PLZUyĪQ\FKSU]HNURMDFKUHJLRQDOQ\FK]DSUH]HQWRZDQRZF]WHUHFKRSXEOL NRZDQ\FK Z URNX F\WRZDQ\FK SXEOLNDFMDFK >@ ,VWRWQ\ HOHPHQW PHWRG\F]Q\ W\FK EDGDĔVWDQRZLáRRSUDFRZDQLHDXWRUVNLFKUR]ZLą]DĔKXUWRZQLGDQ\FKZ\NRQDQ\FK]Z\NRU]\VWD QLHP %DQNX GDQ\FK ORNDOQ\FK %'/ FR SR]ZROLáR RVLąJQąü ]QDF]QLH Z\ĪV]ą HODVW\F]QRĞü Z]DNUHVLHWZRU]HQLDUyĪQ\FK]HVWDZLHĔLQIRUPDF\MQ\FKZ\NRQ\ZDQ\FKZGRZROQLHNRQILJXUR ZDQ\FKSU]HNURMDFKGDQ\FK'RQLHVWDQGDUGRZ\FK]HVWDZLHĔQDOHĪDá\SU]HNURMH]HVWDZyZJPLQ DJUHJRZDQ\FKZVWUXNWXU\PDNURUHJLRQyZNWyU\FKGDQHĨUyGáRZHSRFKRG]Lá\]SRáąF]HQLDXMĊW\FK ZDQDOL]LHJUXSJPLQ8]\VNDQHGRĞZLDGF]HQLDRSUDFRZDQHZSXEOLNDFMDFKLSUH]HQWRZDQHQDNRQ IHUHQFMDFK QDXNRZ\FK RUD] G\VNXVMDFK Z JURQLH ]DLQWHUHVRZDQ\FK EDGDF]\ SUyERZDQR áąF]\ü ]NRQVXOWDFMDPLSUDFRZQLNyZ-67]DWUXGQLRQ\FKZVáXĪEDFKILQDQVRZ\FKJPLQ:WHMID]LHEDGDĔ PRĪOLZHE\áRGRMU]HZDQLHLZHU\ILNRZDQLHNRQFHSFMLGRW\F]ąFHMFHORZRĞFLRGZUyFHQLDGRPLQXMą FHMZWHFKQRORJLDFK]FHQWUDOL]RZDQ\FKUR]ZLą]DĔKXUWRZQLGDQ\FKQDU]HF]ZSURZDG]DQLDPRGHOX ]GHFHQWUDOL]RZDQHJRG\VNXWRZDQHZSUDFDFK> @ &]\QQLNLRJUDQLF]DQLDU\]\NDZ]DU]ąG]DQLXILQDQVDPL-67 6WRVRZDQHUHJXODFMHSUDZQHZ]DU]ąG]DQLXILQDQVDPLJPLQVWDQRZLąSUHF\]\MQHLQVWUXPHQW\ GHWHUPLQXMąFH RUJDQL]DF\MQH L PHU\WRU\F]QH ]DVDG\ SODQRZDQ\FK EXGĪHWyZ LFK HOHPHQW\ VNáD GRZHWUHĞFLPHU\WRU\F]QHRUD]WHUPLQ\LFKRSUDFRZDQLDL]DWZLHUG]DQLD5HJXODFMHSUDZQHRUD] MDZQRĞü LQIRUPDFML ]DZDUW\FK Z EXGĪHWDFK VWDMą VLĊ JZDUDQFMą VSRáHF]QHM NRQWUROL SU]\FKRGyZ LZ\GDWNyZEXGĪHWRZ\FK]JRGQLH]SUHIHUHQFMDPLORNDOQ\FKVSRáHF]QRĞFL,QQ\PHFKDQL]PRJUD QLF]DMąF\ZSá\Z U\]\ND ]DSHZQLDNRQWUROD]DU]ąGF]D > @ RERZLą]XMąFD -67NWyUHM V\QWHW\F]QLHZ\VSHF\ILNRZDQHVNáDGQLNL]DPLHV]F]RQRQDU\VXQNXRG]ZLHUFLHGODMąFHVHNZHQFMH NROHMQ\FKZ\VWĊSXMąF\FKZNRQWUROL]DU]ąGF]HMSURFHVyZ
Rysunek 1. Procesy kontroli zarządczej obowiązującej JST ħUyGáR RSUDFRZDQLHZáDVQH
:]DNUHVLHILQDQVRZ\PNOXF]RZ\PHOHPHQWHPNRQWUROL]DU]ąGF]HMMHVWPRQLWRULQJZ\NRQDQLD EXGĪHWXNWyU\PDV]F]HJyOQH]QDF]HQLHGODHIHNW\ZQHJR]DU]ąG]DQLDGáXJLHP-670RQLWRULQJELH ĪąF\ Z XSURV]F]HQLX SROHJD QD SRUyZQDQLX ZDUWRĞFL SODQRZDQ\FK L Z\NRQDQ\FK Z ]DNUHVLH NOXF]RZ\FKHOHPHQWyZEXGĪHWXZWUDNFLHWUZDQLDURNXEXGĪHWRZHJR-67]RERZLą]DQHVąGRVSR U]ąG]DQLDVSUDZR]GDĔILQDQVRZ\FKLSU]HND]\ZDQLDLFKGRUHJLRQDOQHML]E\REUDFKXQNRZHM]JRGQLH ]WHUPLQDPLRSUDFRZDQLDL]DWZLHUG]DQLDEXGĪHWyZ3RGVWDZĊSUDZQąWHJRRERZLą]NXVWDQRZL5R] SRU]ąG]HQLH0LQLVWUD)LQDQVyZ]GQLDF]HUZFDUZVSUDZLHVSUDZR]GDZF]RĞFLEXGĪHWRZHM ']8]UQUSR]]H]P :LĊNV]RĞüVSUDZR]GDĔMHVWREHFQLHSU]HND]\ZDQD]D SRPRFąV\VWHPXLQIRUPDW\F]QHJR%H67L#NWyU\REVáXJXMHSURFHV\JURPDG]HQLDLNRQWUROLVSUD ZR]GDĔ )XQNFMĊ QDG]RUX QDG JRVSRGDUNą ILQDQVRZą Z RGQLHVLHQLX GR -67 ZZRMHZyG]WZDFK SHáQLą]UDPLHQLD0LQLVWHUVWZD)LQDQVyZ5HJLRQDOQH,]E\2EUDFKXQNRZH3RGHMPRZDQLHU\]\ND VWDQRZLLPPDQHQWQHDVSHNW\LQLFMDW\ZLQZHVW\F\MQ\FKZUDPDFKNWyU\FKVXNFHVZSRVWDFLZ\JUD QLDZNRQNXUVLHZLĊNV]RĞFL]JáRV]RQ\FKSU]H]JPLQĊSURMHNWyZPRĪHSURZDG]LüGR]ZLĊNV]HQLD U\]\ND]HZ]JOĊGXQDZ\ĪV]HRG]DNáDGDQ\FKSR]LRP\ZNáDGXZáDVQHJR6\WXDFMHWDNLHMDNZ\QLND ]QDV]\FKGRW\FKF]DVRZ\FKDQDOL]Z\VWĊSXMąF]ĊVWRLVWDQRZLüRQHPRJąEH]FHQQHPDWHULDá\GOD EHQFKPDUNLQJRZ\FKDQDOL]ZUDPDFKUyĪQ\FKJUXSJPLQ
=DVWRVRZDQLHKXUWRZQLGDQ\FKLQDU]ĊG]L%,GRDQDOL]\LQIRUPDFMLEXGĪHWRZHM-67 .RQFHSFMD]DVWRVRZDĔKXUWRZQLGDQ\FKRUD]QDU]ĊG]L%,GRDQDOL]\EXGĪHWyZJPLQVWDQRZLáD SRGVWDZĊNRQFHSFMLEDGDZF]HMZUDPDFKNWyUHM]DNáDGDQRXWZRU]HQLHNRPSOHWQHMQLH]DOHĪQHMED]\ LQIRUPDF\MQHMSURFHVXEDGDZF]HJRFRE\áRNRQLHF]QH]HZ]JOĊGXQD]DZRGQRĞüLGáXJLF]DVSR]\ VNLZDQLD LQIRUPDFML ] FHQWUDOQ\FK VHUZHUyZ ED]RGDQRZ\FK 3R RSUDFRZDQLX L RSXEOLNRZDQLX SLHUZV]\FKZ\QLNyZEDGDĔZ\NRQDQ\FKQDSRGVWDZLHKXUWRZQLGDQ\FKRPyZLRQHMV\QWHW\F]QLH ZUR]G]LDOH:UDPDFKNRQVXOWDFML]HVNDUEQLNLHPLSUDFRZQLNDPLVáXĪEILQDQVRZ\FK0LDVWD QDSUDZDFKSRZLDWX%\GJRV]F]NRQLHF]QHE\áR]DSURMHNWRZDQLHLRSURJUDPRZDQLHKXUWRZQLGD Q\FKZ\NRQDQHMQDED]LH]DVREyZLQIRUPDF\MQ\FK0LQLVWHUVWZD)LQDQVyZFKDUDNWHU\]RZDQ\FK ZUR]G]LDOH.OXF]RZH]QDF]HQLHZUHDOL]DFMLWHMNRQFHSFML]DVREyZLQIRUPDF\MQ\FK+XUWRZQL 'DQ\FKE\áRXZ]JOĊGQLHQLHVWUXNWXUGH]DJUHJRZDQLDLQIRUPDFMLGRSR]LRPXG]LDáyZLSDUDJUDIyZ FR ]DSHZQLDáR PRĪOLZRĞü DJUHJRZDQLD LQIRUPDFML Z UDSRUWDFK Z VSRVyE QLH]EĊGQ\ GOD SRWU]HE ZVSRPDJDQLDGHF\]MLILQDQVRZ\FK-67
=DU\VUR]ZLą]DĔSURWRW\SXKXUWRZQLGDQ\FKEXGĪHWyZ-67
&]ĊĞüDQDOLW\F]QDWHJRUR]ZLą]DQLDMHVWRSDUWDQDVWDW\VW\FHSXEOLF]QHMF]\OLQD]ELRUDFKGD Q\FK ZWyUQ\FK SXEOLNRZDQ\FK SU]H] *áyZQ\ 8U]ąG 6WDW\VW\F]Q\ L 0LQLVWHUVWZR ILQDQVyZ 'RNXPHQW\EĊGąFHRSUDFRZDQLHPVWDW\VW\F]Q\P]DOLF]DQHVąGRJUXS\GRNXPHQWyZ]ELHUDQ\FK V\VWHPDW\F]QLHDQLHRNROLF]QRĞFLRZRÄ%DGDQLHGRNXPHQWyZMHVWWHFKQLNąVáXĪąFąGRJURPDG]HQLD ZVWĊSQ\FKGDQ\FKRSLVRZ\FKDWDNĪHLORĞFLRZ\FKLQIRUPDFML$QDOL]DGRNXPHQWyZMHVWPHWRGą OXEWHFKQLNąEDGDZF]ąSROHJDMąFąQDRSLVLHLLQWHUSUHWDFMLNRQNUHWQ\FKGRNRQDĔ´>@:áDĞFLZH SRGHMĞFLHDQDOLW\F]QHRSDUWHQDGRNXPHQWDFKVNXWNXMHSRZVWDQLHPXSRU]ąGNRZDQ\FKL]LQWHUSUHWR ZDQ\FKWUHĞFLNWyUHE\á\FHOHPSUREOHPHPEDGDZF]\PLQDQLFKRSLHUDá\VLĊKLSRWH]\ 3R]\VNDQLHGDQ\FK]%DQNX'DQ\FK/RNDOQ\FKL0LQLVWHUVWZD)LQDQVyZRUD]LFKXSRU]ąGNR ZDQLH Z\PDJDáR ZLHOX ]DELHJyZ LQIRUPDW\F]Q\FK 'DQH ]RVWDá\ Z\JHQHURZDQH L]DSLVDQH ZVWUXNWXU]HKXUWRZQLGDQ\FKGRVWĊSQHUyZQLHĪZIRUPLH]DJUHJRZDQHMZDUNXV]DFK06([FHO =ELRU\GDQ\FK]RVWDá\SRG]LHORQHQDODWD]Z\V]F]HJyOQLHQLHPG]LDáyZUR]G]LDáyZLMHGQRVWHNVD PRU]ąGXWHU\WRULDOQHJRZRMHZyG]WZ2GPLHQQDVWUXNWXUDGDQ\FKLVSRVyENRGRZDQLDLQIRUPDFML SRFKRG]ąF\FK]%DQNX'DQ\FK/RNDOQ\FKL0LQLVWHUVWZD)LQDQVyZZ\PDJDáD]DVWRVRZDQLDSUR FHGXU L VáRZQLNyZ SU]HMĞFLRZ\FK VáXĪąF\FK XMHGQROLFHQLX GDQ\FK ĨUyGáRZ\FK LXWZRU]HQLX ZVSyOQ\FKNOXF]\LGHQW\ILNDF\MQ\FKLZ\V]XNLZDQLD=DJUHJRZDQHGDQHRGXĪ\PSRWHQFMDOHLQIRU PDF\MQ\P PXVLDá\ ]RVWDü RGSRZLHGQLR SRJUXSRZDQH L SRGGDQH ILOWURZDQLX DE\ HIHNW\ZQLH GRNRQDü SRUyZQDQLD QS EXGĪHWyZ MHGQRVWHN GOD RNUHĞOHQLD NRQG\FML HNRQRPLF]QHM MHGQRVWHN ORNDOQ\FKLUHJLRQDOQ\FK 2SUDFRZDQH]HVWDZLHQLDDQDOLW\F]QHXPRĪOLZLá\SR]\VNDQLHZLHG]\QLH]EĊGQHMGRZ\NRQDQLD SXEOLNDFMLQDXNRZ\FK>@LX]\VNDQLDZ\QLNyZVWDQRZLąF\FKSXQNWZ\MĞFLDGODRSUDFRZDQLDVWDQ GDUGyZGRZVSRPDJDQLDGHF\]MLZ]DU]ąG]DQLXILQDQVDPLJPLQ
=DU\VUR]ZLą]DĔGRFHORZHJRVWDQGDUGXKXUWRZQLGDQ\FKEXGĪHWyZ-67
-HGQRVWNL 6DPRU]ąGX 7HU\WRULDOQHJR VWDQRZLą WDN EDUG]R ]UyĪQLFRZDQH SRGPLRW\ VWUXNWXU RUJDQL]DF\MQ\FKNUDMXĪHZV]HONLHSUDFH]PLHU]DMąFHGRZ\NRQDQLDDQDOL]SRUyZQDZF]\FK±QLH ]EĊGQ\FKGR]DPLHU]HĔEHQFKPDUNLQJRZ\FKVą]DJURĪRQHZ\NRQDQLHP]áHMDJUHJDFMLW\FKVWUXNWXU GDQ\FK:\PDJDQLDWHZ\PXVLá\RSUDFRZDQLHGUXJLHMJHQHUDFMLKXUWRZQLGDQ\FKZNWyUHMVWUXNWXUD V]F]HJyáRZRĞFL GDQ\FK ĨUyGáRZ\FK EXGĪHWyZ JPLQ REHMPXMH G]LDá\ L SDUDJUDI\ Z\VWĊSXMąFH ZVSUDZR]GDQLDFK JPLQ SU]HND]\ZDQ\FK 0LQLVWHUVWZX )LQDQVyZ 7DND V]F]HJyáRZRĞü GDQ\FK G]LHVLĊFLRNURWQLH]ZLĊNV]DSRMHPQRĞüKXUWRZQLGDQ\FKEXGRZDQHM]]DVWRVRZDQLHP%DQNX'DQ\FK 5HJLRQDOQ\FK8]\VNDQDSRMHPQRĞüKXUWRZQLGDQ\FKQLHVWDQRZLĪDGQHMSU]HV]NRG\ZUHDOL]DFML NRQFHSFML]ZLą]DQHM]]DVWRVRZDQLHP]GHFHQWUDOL]RZDQ\FKUR]SURV]RQ\FKKXUWRZQLGDQ\FK5R] ZLą]DQLH WR Z\PDJDáR Z\NRU]\VWDQLD LQIRUPDFML SRFKRG]ąF\FK ]H VSUDZR]GDĔ Z\NRQDQLD EXGĪHWyZ-67DUFKLZL]RZDQ\FKLXGRVWĊSQLDQ\FKZUDPDFKED]GDQ\FK0LQLVWHUVWZD)LQDQVyZ =DSURMHNWRZDQDZWHMID]LHUHDOL]DFMLEDGDĔKXUWRZQLDGDQ\FKXZ]JOĊGQLDJURPDG]RQHZSRGREQHM VWUXNWXU]H±LQIRUPDFMH]ODWGRNWyUHZRNUHVLHHNVSORDWDFMLEĊGąX]XSHáQLDQH]ELRUDPL QRZHMJHQHUDFML$NWXDOL]DFMDPRĪHXZ]JOĊGQLDüZSURZDG]DQLHGDQ\FKNZDUWDOQ\FK]Z\NRQDQLD EXGĪHWX -67 NWyUH Vą QLH]EĊGQH ZH ZGUDĪDQLX IXQNFML PRQLWRULQJX RSHUDF\MQHJR >@ ,VWRWQH HIHNW\ZSURZDG]HQLDKXUWRZQLGDQ\FKQRZHMJHQHUDFMLSROHJDMąQDX]\VNDQLHPRĪOLZRĞFLJUXSR ZDQLDLQIRUPDFMLZHGáXJG]LDáXUR]G]LDáXSDUDJUDIXLJUXSSDUDJUDIyZ]XZ]JOĊGQLHQLHPF\IU\ QXPHUXSDUDJUDIXGHF\GXMąFHJRR]DNZDOLILNRZDQLDVSRVREXILQDQVRZDQLDSU]\FKRGyZOXEZ\GDW NyZ
3URFHV\ Z\VWĊSXMąFH Z UyĪQ\FK ID]DFK UR]ZLą]DĔ +XUWRZQL 'DQ\FK ]DSUH]HQWRZDQR QD U\VXQNX
Rysunek 2. Prototypowy i docelowy standard hurtowni danych budĪetów JST
ħUyGáR RSUDFRZDQLHZáDVQH 3U]HGVWDZLRQ\QDU\VVFKHPDWLOXVWUXMąF\ĨUyGáRZH]DVLOHQLDLV\QWHW\F]QHUH]XOWDW\NWyU\FK X]\VNDQLHRVLąJQLĊWRZ]UHDOL]RZDQ\FKMXĪEDGDQLDFKOXE]ZHU\ILNRZDQ\FKZWUDNFLHV]HĞFLXVSR WNDĔNRQVXOWDF\MQ\FK]SU]HGVWDZLFLHODPLVáXĪEILQDQVRZ\FKZ\EUDQ\FKJPLQ
5H]XOWDW\NRQVXOWDFMLGRFHORZ\FKUR]ZLą]DĔ]GHFHQWUDOL]RZDQHMKXUWRZQLGDQ\FK LUDSRUWyZGRZVSRPDJDQLD]DU]ąG]DQLDILQDQVDPLJPLQ 1DWXUDOQ\PUR]ZLą]DQLHPVWRVRZDQ\PZV\VWHPDFK]DU]ąG]DQLHPZLHG]ąLEXGRZąKXUWRZQL GDQ\FKMHVWVWRVRZDQLHPRGHOXVFHQWUDOL]RZDQHJR> @RF]\PGHF\GXMąGRPLQXMąFHVWUDWHJLF]QH IXQNFMHGHF\]\MQHNRUSRUDFMLUHDOL]RZDQH]Z\NOHQDSR]LRPLH]DU]ąGyZ3URZDG]RQHZUDPDFK GRW\FKF]DVRZ\FKSUDFNRQVXOWDFMH]SU]HGVWDZLFLHODPLVáXĪEILQDQVRZ\FKJPLQWUZDá\SRQDGURN V]F]HJyOQLHV\VWHPDW\F]QLH]HVNDUEQLNLHP%\GJRV]F]\3LRWUHP7RPDV]HZVNLPNWyUHJRSURMHNW UDSRUWyZZ\MĞüV\VWHPXVWDáVLĊHOHPHQWHPVáXĪąF\PRFHQLHXĪ\WHF]QRĞFLV\VWHPXZVSRPDJDQLD GHF\]ML,GHDGHFHQWUDOL]DFMLWHFKQRORJLLRUJDQL]DFMLSU]HWZDU]DQLDKXUWRZQLGDQ\FKSRZVWDáDMDNR UR]ZLą]DQLH HOLPLQXMąFH QLH]Z\NOH XFLąĪOLZH ZQDV]\FK ZDUXQNDFK SR]\VNLZDQLH LQIRUPDFML ]H VFHQWUDOL]RZDQ\FKED]GDQ\FKVWDW\VW\F]Q\FK2ND]XMHVLĊĪHSRXVXQLĊFLXUHGXQGDQFMLUHNRUGyZ ZVWUXNWXUDFKRSUDFRZDQHMGRFHORZHMKXUWRZQLGDQ\FKQLH]EĊGQHMGRUHDOL]DFMLV\VWHPXZVSRPD JDQLD GHF\]ML Z ]DU]ąG]DQLX ILQDQVDPL JPLQ Z\PDJDQH ]DVRE\ LQIRUPDF\MQH PLHV]F]ą VLĊ ZJUDQLFDFKF]WHUHFKJLJDEDMWyZ&]DVX]\VNLZDQLDUDSRUWyZSU]\OLF]ELHSRUyZQ\ZDQ\FKJPLQRG GRQLHSU]HNUDF]DáNLONXG]LHVLĊFLXVHNXQGSU]\XĪ\FLXSU]HFLĊWQHMGODDNWXDOQLHRIHURZDQ\FK NRQILJXUDFMLVSU]ĊWXPLNURNRPSXWHURZHJR
.RQVXOWDFMD RSUDFRZDQ\FK UR]ZLą]DĔ SURMHNWRZRSURJUDPRZ\FK 6\VWHPX :VSRPDJDQLD 'HF\]MLZ]DU]ąG]DQLXILQDQVDPLJPLQE\áDSU]HSURZDG]RQDZGQLDFKSRPLĊG]\NZLHWQLDD PDMD URNX :\W\SRZDQH RELHNW\ VWDQRZLá\ JPLQ\ %\GJRV]F] ,QRZURFáDZ .RURQRZR 'REUF]2VLHOVNRRUD]1RZD:LHĞ:LHONDFRREUD]XMHVWRVXQNRZRV]HURNLHVSHNWUXPLFK]UyĪQL FRZDQLD=GDQLHPZ\NRQDZFyZUR]ZLą]DĔSURJUDPRZ\FKXGDáRVLĊRVLąJQąüSHáQH]UR]XPLHQLH GODSU]\MĊW\FKPHWRGSRVWĊSRZDQLDLDNFHSWRZDQ\FKSU]H]]HEUDQ\FKNRQFHSFMLZVSDUFLDGODUHDOL ]RZDQHJR SU]H] VáXĪE\ ILQDQVRZH JPLQ Z ]DNUHVLH SU]\JRWRZDQLD LQIRUPDFML QLH]EĊGQ\FK ZSURFHVLHSRGHMPRZDQLDGHF\]MLSU]H]GHF\GHQWyZ
2UJDQL]DFMDVSRWNDQLDZUDPDFKNRQVXOWDFMLE\áDSRSU]HG]RQDRPyZLHQLHPPHWRG\NLSURZD G]RQ\FK EDGDĔ ] XZ]JOĊGQLHQLHP PHU\WRU\F]Q\FK DVSHNWyZ GHWHUPLQXMąF\FK SRWU]HEĊ GRNRQ\ZDQLDDQDOL]EHQFKPDUNLQJRZ\FKZ]DU]ąG]DQLXILQDQVDPLJPLQ'HPRQVWUDFMDZ\MĞüV\V WHPX E\áD SRSU]HG]RQD SU]\JRWRZDQLHP ]HVWDZX JUXS\ JPLQ X]XSHáQLDQHM QD Ī\F]HQLH XF]HVWQLNyZR±JPLQ\Z\EUDQ\FKMHGQRVWHNNWyUHZáąF]RQRGR]HVWDZXLGUXNRZDQRNROHMQR ]HVWDZLHQLDZ\GDWNyZ]G\QDPLF]Q\PUR]ELFLHPQDSDUDJUDI\RUD]]HVWDZLHĔSU]\FKRGyZRJyáHP LZUR]ELFLXQDMHGQHJRPLHV]NDĔFD3UH]HQWDFMDUDSRUWyZV\VWHPXLG\VNXVMDZ\QLNyZSRZRGRZDáD ]MHGQHMVWURQ\ZHU\ILNDFMĊSRSUDZQRĞFLSUH]HQWRZDQ\FKQDHNUDQLHZ\QLNyZLRFHQ\QDMEDUG]LHM LQWHUHVXMąF\FKHNVWUHPDOQ\FKZDUWRĞFLSDUDPHWUyZZ\EUDQ\FKJPLQNWyUHGDZDá\PHU\WRU\F]Q\ SU]\NáDGGHF\]\MQHMXĪ\WHF]QRĞFLWHJRW\SXLQIRUPDFML&HOHPWDNZQLNOLZLHSURZDG]RQ\FKQDUDG LNRQVXOWDFMLE\áDQLH]Z\NOHZDĪQDGODDXWRUyZLNRQVXOWDQWyZUHDOL]RZDQ\FKSUDFQDXNRZRED GDZF]\FK NZHVWLD SR]LRPX XĪ\WHF]QRĞFL RSUDFRZDQ\FK UR]ZLą]DĔ GOD SUDNW\F]QHJR LFK ]DVWRVRZDQLDZZDUXQNDFKLVWRWQHJR]UyĪQLFRZDQLDRF]HNLZDĔXF]HVWQLNyZ]UHDOL]RZDQ\FKNRQ VXOWDFML 3HZQH ]DVNRF]HQLH VWDQRZLáD áDWZRĞü QDZLą]\ZDQLD NRQWDNWyZ SU]HGPLRFLH ]UyĪQLFRZDQ\FKSUREOHPyZSUH]HQWRZDQ\FKZHZVWĊSLHLZ\VWĊSXMąFHZHZV]\VWNLFKVSRWNDQLDFK RGQLHVLHQLDSUDNW\F]QHGODSUH]HQWRZDQ\FKSU]\NáDGRZ\FKUDSRUWyZLZ\MĞüJUDILF]Q\FK
5HDOL]DFMDSUDF]DSHZQLDMąF\FKNRPSOHWQ\]HVWDZLQIRUPDFMLQLH]EĊGQ\GRREOLF]DQLDZVNDĨ QLNyZ ZDUWRĞFL SDUDPHWUyZ EXGĪHWX QD MHGQHJR PLHV]NDĔFD Z\PDJDáD X]XSHáQLHQLD R OLF]EĊ PLHV]NDĔFyZ]SRV]F]HJyOQ\FKODWZXNáDG]LH-67NWyU\FKSR]\VNDQLH]FHQWUDOQ\FKED]GDQ\FK
RND]DáRVLĊQLHPRĪOLZH.RQLHF]QHE\áRUĊF]QHZSURZDG]DQLHLQIRUPDFMLFRXSHZQLDQDVZVáXV] QRĞFL UHDOL]DFML ]GHFHQWUDOL]RZDQ\FK KXUWRZQL GDQ\FK LQVWDORZDQ\FK QD NRPSXWHUDFK XĪ\WNRZQLNyZGODNDĪGHMJPLQ\:VWĊSQHNRQVXOWDFMHSRWZLHUG]Lá\Z\VWĊSRZDQLH]DSRWU]HERZD QLDQD]DVRE\LQIRUPDF\MQHSUH]HQWRZDQHZIRUPLHWDEOLFLJUDILNLLOXVWUXMąF\FKXZDUXQNRZDQLD LDQDOL]\SRUyZQDZF]HVNDOL]PLDQSDUDPHWUyZILQDQVRZ\FKDQDOL]RZDQ\FKZJUXSDFKJPLQR]EOL ĪRQ\FKXZDUXQNRZDQLDFK:WUDNFLHG\VNXVMLQDZLHOXVSRWNDQLDFKNRQVXOWDF\MQ\FKRND]DáRVLĊĪH ZDNWXDOQLHZ\NRQ\ZDQHMSUDF\PHU\WRU\F]QHMVáXĪEILQDQVRZ\FK]DSRWU]HERZDQLHGHF\GHQWyZ QDLQIRUPDFMHEHQFKPDUNLQJRZHMHVWGXĪHLWUXGQ\GRVWĊSGRZLHOXGDQ\FKĨUyGáRZ\FKXWUXGQLD UHDOL]DFMĊWHMIXQNFML 3RGVXPRZDQLH 3URZDG]RQHZ.DWHGU]H,QIRUPDW\NLZ=DU]ąG]DQLX:\G]LDáX=DU]ąG]DQLDRGURNXSUDFH EDGDZF]HGRW\F]ąFHFHORZRĞFL]DVWRVRZDQLDUR]ZLą]DĔ+XUWRZQL'DQ\FKLQDU]ĊG]L%,Z]DU]ą G]DQLXUHJLRQDOQ\PLDQDOL]\SRUyZQDZF]HMNRV]WyZXVáXJNRPXQDOQ\FK>@]DLQLFMRZDá\SUDFH LQWHQV\ZQLHUR]ZLMDQHZRVWDWQLFKWU]HFKODWDFK,QWHQV\ILNDFMDZVSyáSUDF\]8U]ĊGHP6WDW\VW\F] Q\P )LUPą 62)7($0 VS ] RR GRSURZDG]LáD GR VWZRU]HQLD SLHUZV]HM JHQHUDFML KXUWRZQL GDQ\FKOLNZLGXMąFHMXFLąĪOLZRĞüSR]\VNLZDQLDGDQ\FKĨUyGáRZ\FKLáDWZRĞüWZRU]HQLD]áRĪRQ\FK NU\WHULyZGRERUXJPLQGODFHOyZSRUyZQDZF]\FK3R]\VNDQLHGRZVSyáSUDF\QDGUR]ZRMHPSUR ZDG]RQ\FKEDGDĔVNDUEQLND0LDVWD%\GJRV]F]R]QDF]DáRLFKRULHQWDFMĊQDZVSRPDJDQLHSURFHVyZ GHF\]\MQ\FK NWyUH R]QDF]Dá\ NRQLHF]QRĞü VSHáQLHQLD ZDUXQNX ]DSHZQLHQLD V]F]HJyáRZRĞFL UR] G]LDáXLQIRUPDFMLEXGĪHWRZHMJPLQQDSDUDJUDI\3REOLVNRURF]Q\PRNUHVLHNRQVXOWDFMLZ\VWąSLáD ZVSyáSUDFDZ]DNUHVLHSURMHNWRZDQLDUDSRUWyZNWyU\FKWZRU]HQLHVWDQRZLQLH]EĊGQ\VHUZLVLQIRU PDFMLILQDQVRZ\FKGRSRGHMPRZDQLDGHF\]MLZVSUDZDFKGRW\F]ąF\FKEXGĪHWyZ-67
6WZRU]HQLHGRFHORZHJR]GHFHQWUDOL]RZDQHJRVWDQGDUGXKXUWRZQLGDQ\FK]DSHZQLDMąF\FKUH DOQH PRĪOLZRĞFL ZVSRPDJDQLD SUDF\ VáXĪE ILQDQVRZ\FK Z ]DNUHVLH WZRU]HQLD ]HVWDZLHĔ LQIRUPDF\MQ\FK Z SURFHVDFK SRGHMPRZDQLD GHF\]ML SRVLDGD V]F]HJyOQH ]QDF]HQLH Z ]ZLą]NX ]PRĪOLZRĞFLąSR]\VNLZDQLDĞURGNyZZUDPDFKGUXJLHMSHUVSHNW\Z\EXGĪHWRZHM5R]ZyMEDGDĔ ]]DNUHVXZVSRPDJDQLD]DU]ąG]DQLDILQDQVDPLJPLQ]Z\NRU]\VWDQLHPZ\NRQDQHJRRSURJUDPRZD QLD ]GHFHQWUDOL]RZDQHM KXUWRZQL GDQ\FK L QDU]ĊG]L %, Z\PDJD SRGMĊFLD GHF\]ML ZVSUDZLH QDVWĊSXMąF\FKG]LDáDĔRUJDQL]DF\MQ\FK
3U]\JRWRZDQLHGRNXPHQWDFMLSURMHNWXZFHOXX]\VNDQLDĞURGNyZQDVILQDQVRZDQLHNRV] WyZ ZGURĪHQLD UR]ZLą]DĔ SURJUDPRZ\FK L URF]QHM HNVSORDWDFML KXUWRZQL GDQ\FK DZNROHMQ\FKODWDFK]DSHZQLHQLHDQDORJLF]Q\FKUR]ZLą]DĔKXUWRZQLGDQ\FKGODZLHOROHW QLHMSURJQR]\ILQDQVRZHM
3URZDG]HQLH DQDOL]\ Z\NRU]\VWDQLD ZGUDĪDQ\FK UR]ZLą]DĔ Z SRV]F]HJyOQ\FK JPLQDFK LGRNXPHQWRZDQLHWZRU]RQ\FKPRG\ILNDFMLUDSRUWyZSRV]HU]DMąF\FKIXQNFMRQDOQRĞüV\V WHPXZ\PLHQLRQ\FKZSXQNFLH 3U]\JRWRZDQLHRUJDQL]DFML,,0XOWLNRQIHUHQFMLVáXĪąFHMGRDQDOL]\HIHNWyZZVWĊSQHMHNV SORDWDFMLV\VWHPXZSRV]F]HJyOQ\FKJPLQDFK]HVIRUPXáRZDQLHPZQLRVNyZNRĔFRZ\FK GRW\F]ąF\FK]DVWRVRZDQLD]GHFHQWUDOL]RZDQHMKXUWRZQLGDQ\FKLQDU]ĊG]L%XVLQHVV,QWHO OLJHQFH
%LEOLRJUDILD >@ 0%LWQHU.&LFKRFNL-6LHUDN6WDQGDUG\]DU]ąG]DQLDGáXJLHPQDV]F]HEOXORNDOQ\PLUH JLRQDOQ\PRUD]LFKZSá\ZILQDQVRZDQLHLQIUDVWUXNWXU\,%63$1%DGDQLD6\VWHPRZHW :DUV]DZD >@ .6&LFKRFNLD=DU]ąG]DQLHILQDQVDPLLGáXJLHPVDPRU]ąGXWHU\WRULDOQHJRZSHUVSHN W\ZLHZLHOROHWQLHM6HULD%DGDQLD6\VWHPRZHQU,%63$1:DUV]DZD PRQRJUDILD JUDQW01L6]:KWWS ZZZLEVSDQZDZSONVFLFKRFNLLQGH[SKS:DUV]DZD >@ /'UHOLFKRZVNL&*UDXO%3WDV]\ĔVND:=ZDUD*2V]XĞFLN $PRGHORIG\ QDPLFDQDO\VLVRIWKHLQIOXHQFHRIWKHGHYHORSPHQWRI3RODQG¶VLQIUDVWUXFWXUHRQWKHOHYHORI FKDQJHVDULVLQJIURPWKHILQDQFLQJFRVWVRILWVFRQVWUXFWLRQDQGPDLQWHQDQFHXVLQJ%XVLQHVV ,QWHOOLJHQFHWRROV5RF]QLNL&ROOHJLXP$QDOL](NRQRPLF]Q\FK6*+2ILF\QD:\GDZQLF]D :DUV]DZDWV± >@ /'UHOLFKRZVNL&*UDXO*2V]XĞFLN0RQRJUDILDÄ1DWXUDLXZDUXQNRZDQLDU\]\ND´5R] G]LDáSWÄ=DVWRVRZDQLHKXUWRZQLGDQ\FKLQDU]ĊG]LEXVLQHVVLQWHOOLJHQFHZ]DU]ąG]DQLX EXGĪHWDPLJPLQPHWRGąRJUDQLF]HQLDU\]\NDGHILF\WXEXGĪHWRZHJR´3ROLWHFKQLNDàyG]ND 1USWÄUHGQDXN,ZRQD6WDQLHFV ± >@ /'UHOLFKRZVNL&*UDXO=DVWRVRZDQLHKXUWRZQLGDQ\FKRUD]QDU]ĊG]L%XVLQHVV,QWHOOL JHQFHGRSODQRZDQLDLDQDOL]\EXGĪHWyZVDPRU]ąGXWHU\WRULDOQHJR6FLHQWLILFMRXUQDO+HUDOG RI.KPHOQLFN\M8QLYHUVLW\(FRQRPLFVFLHQFHV,VVXH3DUW6± >@ /'UHOLFKRZVNL)URQF]DN(*UDXO&2V]XĞFLN* 8VLQJGDWDZDUHKRXVLQJDQGWKH 2/$3WRROVWRDQDO\]HFRPPXQDOEXGJHWVLQWKHNXMDZ\SRPRU]HSURYLQFHLQWKHOLJKWRI DEVRUELQJ IXQGV IURP WKH (XURSHDQ 8QLRQ 6WXGLD L 0DWHULDá\ 3ROVNLHJR 6WRZDU]\V]HQLD =DU]ąG]DQLD:LHG]ąWV±
>@ /'UHOLFKRZVNL06WDZLFND%&LOVNL %XGRZD0LĊG]\UHJLRQDOQ\FK+XUWRZQL'DQ\FK LUR]ZLą]DĔ DXWRPDW\F]Q\FKDQDOL] FHQQLNyZ LNRV]WyZ G]LDáDOQRĞFL ILUP XVáXJ NRPXQDO Q\FKGOD SRWU]HE ZáDG] VDPRU]ąGRZ\FK 6WXGLD L 0DWHULDá\ QU 3ROVNLH 6WRZDU]\V]HQLH =DU]ąG]DQLD:LHG]ą%\GJRV]F]V±
>@ 7 *yUVNL 3ODWIRUP\ LQWHJUDF\MQH =DJDGQLHQLD Z\EUDQH :\GDZQLFWZR 1DXNRZH 3:1
> @ -.LVLHOQLFNL=DU]ąG]DQLHLLQIRUPDW\ND3ODFHW:DUV]DZD
>@ ( .RZDOF]\N .RQWUROD ]DU]ąGF]D Z MHGQRVWFH VHNWRUD ILQDQVyZ SXEOLF]Q\FK :]RU\ LQVWUXNFMLLSURFHGXU3UHVVRP:URFáDZ
>@ 0D]XUHN..QHGOHU.RQWUROD]DU]ąGF]DXMĊFLHSUDNW\F]QH+DQGLNDS:DUV]DZD >@ .3XFKDF]1RZHVWDQGDUG\NRQWUROL]DU]ąGF]HMZMHGQRVWNDFKVHNWRUDILQDQVyZSXEOLF]
Q\FK2''.:DUV]DZD
>@ 06ROD.RQWUROD]DU]ąGF]DZDGPLQLVWUDFMLVDPRU]ąGRZHM0XQLFLSLXP:DUV]DZD >@ ( 6áDZLĔVND7RPWDáD .RQWUROD ]DU]ąGF]D Z VHNWRU]H SXEOLF]Q\P &+ %HFN :DUV]DZD
>@ 0:DOF]DN.RZDOF]\N5DFKXQNRZRĞüLEXGĪHWRZDQLHZ]DU]ąG]DQLXILQDQVDPLJPLQ\ 'LILQ:DUV]DZD
'(&,6,2168332576<67(06,17+(),1$1&,$/0$1$*(0(172)/2&$/ *29(510(1781,7686,1*$'(&(175$/,=('',675,%87(' '$7$:$5(+286( 6XPPDU\
The paper discusses carried out in two phases research program on applications of data warehousing and BI tools in helping financial management of municipalities. In the first stage, carried out in 2012–2014 developed a data warehouse with the ac-quisition of the information contained in the Bank's local data and used in benchmarking elected to benchmarking groups, municipalities and macro-regions. In the second phase of research undertaken in the years 2014, 2015 developed Data Warehouse Generation II, which was designed and software based on file content of financial statements JST, taking into account the aggregation of financial information to the level of divisions and paragraphs, which provides the ability to make effective use of financial decision support system.
.H\ZRUGV V\VWHP DQDO\VLV EHQFKPDUNLQJ ORFDO JRYHUQPHQW XQLWV %XVLQHVV ,QWHOOLJHQFH %, LQSXEOLFDGPLQLVWUDWLRQSODQQLQJWKHEXGJHWVRIORFDOJRYHUQPHQWV /XGRVáDZ'UHOLFKRZVNL :\ĪV]D6]NRáD*RVSRGDUNLZ%\GJRV]F]\ 8O*DUEDU\ %\GJRV]F]
