Abstract
Organizations are constantly changing due to the evolution of technologies, requiring them to restructure their strategies. On this case, local autarchies are not an exception. Due to the big data volume involved within the government ecosystem, Business Intelligence (BI) systems were implemented to deal with several processes where effective and efficient decisions are crucial. These systems have proved to be worth on the global government and this article will show how those systems can also be applied to local autarchies, where Business Intelligence can make a positive difference. The multidimensional model created for the local autarchy will be presented, consisting on one fact table and eleven dimensions. This model was created aiming to optimize the autarchy’s decision-making processes, related with the financial department.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Lenin: Business Intelligence and E-governance. Department of information Technology Ministry of Communication & IT (2006)
Negash, S.: Business Intelligence. The Communications of the Association for Information (2004)
Santos, M.Y., Ramos, I.: Business Intelligence: Tecnologias da informação na gestão de conhecimento. FCA-Editora de Informática (2006)
Thompson, O.: Business Intelligence Success (2009). Retrieved from Technology evaluation: technologyevalution.com
Turban, E., Sharda, R.: eBook - Turban 2010 - Decision Support and Business Intelligence (2010)
Van der Lans, R.: Data Virtualization for Business Intelligence Systems (2012)
Vercellis, C.: Business Intelligence: Data Mining and Optimization for Decision Making (2009)
PGDL. Regime Financeiro das Autarquias Locais e Entidades Intermunicipais (2009). http://www.pgdlisboa.pt/leis/lei_mostra_articulado.php?nid=545&tabela=leis. Accessed
CMG, Guimarães, C.M., Relatório de Contas 2014. (2014)
Hai, J.: Fundamental of Development Administration. Scholar Press, Selangor (2007)
GESMA. Simplex Autárquico - Quanto Mais Perto Melhor (2008). http://www.gsema.gov.pt/index2.php?option=com_docman&task=doc_view&gid=34&Itemid=32. Accessed
Kimball, R.: The data warehouse toolkit: the complete guide to dimensional modeling (2002)
Brandão, A., Pereira, E., Esteves, M., Portela, F., Santos, M.F., Abelha, A., Machado, J.: A benchmarking analysis of open-source business intelligence tools in healthcare environments. Information 7(4) (2016). ISSN: 2078-2489. MDPI
Pereira, A., Portela, F., Santos, M.F., Abelha, A., Machado, J.: Pervasive business intelligence: a new trend in critical healthcare. In: Procedia Computer Science - ICTH 2016 - International Conference on Current and Future Trends of Information and Communication Technologies in Healthcare, vol. 98, pp. 362–367. Elsevier (2016). ISSN: 1877-0509
Carvalhosa, P., Portela, F., Santos, M.F., Abelha, A., Machado, J.: Pervasiveness in digital marketing – a global overview. In: Rocha, Á., Correia, A.M., Adeli, H., Reis, L.P., Costanzo, S. (eds.) Recent Advances in Information Systems and Technologies, Part 3. Advances in Intelligent Systems and Computing, vol. 517, pp. 391–398. Springer, Cham (2017)
Carvalhosa, P., Portela, F., Machado, J., Santos, M.F., Abelha, A.: Good practices in local government - a first overview of Portuguese reality. In: The International Conference on Information Technology and Digital Applications (ICITDA 2016). IOP (2016). Accepted for publication
Teixeira, R., Afonso, F., Oliveira, B., Machado, J., Abelha, A., Santos, M.F., Portela, F.: Decision support in E-government – A pervasive business intelligence approach. In: Rocha, A., Correia, A.M., Costanzo, S., Reis, L.P. (eds.) New Contributions in Information Systems and Technologies. AISC, vol. 354, pp. 155–166. Springer, Cham (2015). doi:10.1007/978-3-319-16528-8_15
Teixeira, R., Afonso, F., Oliveira, B., Portela, F., Santos, M.F.: Business intelligence to improve the quality of local government services - case-study in a local government town hall. In: KMIS 2014 - International Conference on Knowledge Management and Information Sharing, pp. 153–160. SciTePress, Rome (2014). ISBN: 978-989-758-050-5
Teixeira, R.: Apoio à decisão na melhoria dos processos de qualidade, através da utilização de técnicas de Business Intelligence (2014)
Acknowledgments
This work has been supported by Compete: POCI-01-0145-FEDER-007043 and FCT within the Project Scope UID/CEC/00319/2013.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Costa, A., Santos, M.F., Abelha, A. (2017). A Data Warehouse Schema to Support Financial Process in Local eGov. In: Rocha, Á., Correia, A., Adeli, H., Reis, L., Costanzo, S. (eds) Recent Advances in Information Systems and Technologies. WorldCIST 2017. Advances in Intelligent Systems and Computing, vol 569. Springer, Cham. https://doi.org/10.1007/978-3-319-56535-4_36
Download citation
DOI: https://doi.org/10.1007/978-3-319-56535-4_36
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-56534-7
Online ISBN: 978-3-319-56535-4
eBook Packages: EngineeringEngineering (R0)