Business Intelligence to Improve the Quality of Local Government Services - Case-study in a Local Government Town Hall

Rui Teixeira, Fernando Afonso, Bruno Oliveira, Filipe Portela, Manuel Filipe Santos

2014

Abstract

The use of business intelligence (BI) systems by organizations is increasingly considered as an asset, which goal is to provide access to information in a timely manner in order to support the decision-making process. However, in specific cases such as local government organizations, there are very specific challenges. Some of them like privacy rights and applicable law compliance must be carefully observed, making the necessary adaptations of these BI solutions. The developed solution brings some important contributions and represents some advances in the eGovernment context applied to local governments where the information is normally used/stored are not normalized and pre-defined. Being this a big barrier to development of this type of solutions, the developed architecture is prepared to improve the data quality and avoid this type of mistakes. This paper presents an architecture of a BI platform on a local government organization, geared towards the improvement of citizen offered services quality and efficiency maximization, thus contributing for cost reduction to the taxpayer.

References

  1. Adelakun, Olawale. (2012). "The Role of Business Intelligence in Government: A Case Study of a Swedish Municipality Contact Center."
  2. Bélanger, F. and Carter, L., (2012). Digitizing Government Interactions with Constituents: An Historical Review of E-Government Research in Information Systems. Journal of the Association for Information Systems, 13, pp.363-394.
  3. Berry, Daniel M., and Lawrence Brian, (1998), "Guest Editors' Introduction: Requirements Engineering," IEEE Software, vol. 15, no. 2, pp. 26-29.
  4. Chaudhuri, Surajit, Umeshwar Dayal, and Vivek Narasayya, (2011). "An overview of business intelligence technology." Communications of the ACM 54.8 (2011): 88-98.
  5. Coman, Marius. (2009) "Business Intelligence and Egovernance." Lex ET Scientia International Journal (LESIJ) XVI-1: 484-491.
  6. GESMA. (2008) Simplex Autárquico - Quanto Mais Perto Melhor. [Online] Available from: http://www.gsema. gov.pt/index2.php?option=com_docmanandtask=doc_ viewandgid=34andItemid=32; [Accessed: 18th April 2014]
  7. Hill, T. and Westbrook, R., 1997. SWOT analysis: It's time for a product recall. Long Range Planning, 30, 46-52.
  8. IIBA, A, (2009). "guide to the business analysis body of knowledge (BABOK Guide)."International Institute of Business Analysis (IIBA).
  9. Inmon, W. H. (2005). Building the Data Warehouse (Fourth edition). New York: Wiley
  10. Kajanus, M., Kangas, J. and Kurttila, M., 2004. The use of value focused thinking and the A'WOT hybrid method in tourism management. Tourism Management, 25, pp.499-506.
  11. Kimball, Ralph, and Ross, Margy, (2006). The Data Warehouse Toolkit: the complete guide to Dimensional Modeling. John Wiley and Sons, Inc. NY.
  12. Marques, Maria Manuel Leitão. (2010) Simplex'10, - Quanto mais simples melhor. Lisboa, Maio 2010. [online] Available from: http://www.simplex.pt/ downloads/programasimplex2010.pdf ; [Accessed: 18th April 2014]
  13. MicroStrategy, Inc (2007), MicroStrategy “ Business Intelligence And Government - , viewed 18 July 2014, < http://www.inst-informatica.pt/servicos/informacaoe-documentacao/dossiers-tematicos/>
  14. Negash, Solomon. (2004) "Business Intelligence. "Kennesaw State University, Communications of the Association for Information Systems 13.
  15. Niedrite, Laila, Solodovnikova, Darja ,et al. (2007) "GoalDriven Design of a data warehouse based business process analysis system." Proceedings of the 6th Conference on 6th WSEAS ICAIKEDB.
  16. OECD (Organisation for Economic Co-operation and Development). (2008). Making Life Easy For Citizens And Businesses In Portugal - Administrative Simplification And E-Government. Paris.
  17. Piercy, N. and Giles, W., 1989. Making SWOT Analysis Work. Marketing Intelligence and Planning, 7, pp.5-7.
  18. Portugal (2013). Despacho nº 16970-A/2013. Diário da Republica nº 253, 3º Supl. da Série II de 2013-12-31.
  19. Rainardi, Vincent. (2007). Building a Data Warehouse: With Examples in SQL Server. Apress; USA
  20. Ranjan, Jayanthi. (2009) "Business intelligence: concepts, components, techniques and benefits." Journal of Theoretical and Applied Information Technology 9.1 (2009): 60-70.
  21. Santos, Maribel Yasmina, and Isabel Ramos. (2006). Business Intelligence: Tecnologias da Informação na Gestão de Conhecimento. FCA.
  22. Sharda, Ramesh, Jay E. Aronson, and David N. King. (2008). Business intelligence: A managerial approach. Upper Saddle River: Pearson Prentice Hall.
  23. Smith, A. D. (2008). Business and e-government intelligence for strategically leveraging information retrieval. Electronic Government, an International Journal. doi:10.1504/EG.2008.016126
  24. Sommerville, Ian and Kotonya, Gerald, (1998), Requirements Engineering: Processes and Techniques. John Wiley and Sons, Inc., New York, NY, USA.
  25. Sommerville, Ian, (2006). Software Engineering, 8th Edition, Addison-Wesley, ISBN10: 0321313798.
  26. Souza, R., and Pereira, A. (2009). A Business Intelligence Methodology for E-government Reverse Auctions. 2009 IEEE CCEC. doi:10.1109/CEC.2009.37
  27. Turban, E., Sharda, R., and Delen, D, (2010). Decision support and business intelligence systems (9 ed.). Upper Saddle River, NJ, USA: Prentice Hall Press.
  28. Vercellis, Carlo, (2009). Front Matter. Business Intelligence: Data Mining and Optimization for Decision Making. Politecnico di Milano, Italy: A John Wiley and Sons, Ltd., Publication.
Download


Paper Citation


in Harvard Style

Teixeira R., Afonso F., Oliveira B., Portela F. and Filipe Santos M. (2014). Business Intelligence to Improve the Quality of Local Government Services - Case-study in a Local Government Town Hall . In Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2014) ISBN 978-989-758-050-5, pages 153-160. DOI: 10.5220/0005051601530160


in Bibtex Style

@conference{kmis14,
author={Rui Teixeira and Fernando Afonso and Bruno Oliveira and Filipe Portela and Manuel Filipe Santos},
title={Business Intelligence to Improve the Quality of Local Government Services - Case-study in a Local Government Town Hall},
booktitle={Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2014)},
year={2014},
pages={153-160},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005051601530160},
isbn={978-989-758-050-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2014)
TI - Business Intelligence to Improve the Quality of Local Government Services - Case-study in a Local Government Town Hall
SN - 978-989-758-050-5
AU - Teixeira R.
AU - Afonso F.
AU - Oliveira B.
AU - Portela F.
AU - Filipe Santos M.
PY - 2014
SP - 153
EP - 160
DO - 10.5220/0005051601530160