Abstract
Business intelligence (BI) has undergone constant changes currently, due to the increasing emergence of new technologies, which are introduced to improve the processes inherent in decision-making in organizations. However, not all users are familiar with the tools of a typical BI system, so there is a heavy reliance on the assistance of information technology (IT) technicians in the area of data extraction and exploitation (DEE), for ad hoc analyses. In this article, we intend to analyze some DEE tools on the market and their applicability to resolve and help these user’s issues in their work environment. For this purpose, literature survey of these type of users and their requirements was done; six DEE tools were selected, analyzed, and experimented; a topology was defined to evaluate the DEE tools in order to identify the one that best applies to business data extraction and exploitation from data warehouses and data marts, associated with BI system and responds to the requirements of these users.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
R.L. Ackoff, From data to wisdom. J. Appl. Syst. Anal. 16(1), 3–9 (1989). http://doi.org/citeulike-article-id:6930744
G. Bellinger, D. Castro, A. Mills, Data, Information, Knowledge, and Wisdom (2004), pp. 5–7
T.H. Davenport, L. Prusak, Working knowledge—how organizations manage what they know. 21(8), 395–403 (Harvard Business School Press, Boston Massachusetts, 2000)
J. Dyché, Categorizing Business Intelligence Users, 4 (2007). Retrieved from https://searchbusinessanalytics.techtarget.com/news/2240036691/Categorizing-business-intelligence-users
W.W. Eckerson, Performance Dashboards: Measuring, Monitoring, and Managing Your Business, 2nd edn. (Wiley, Hoboken, 2010). https://doi.org/10.2514/6.2008-3494
W.W. Eckerson, Classifying Business Users (2013). Retrieved February 10, 2018, from http://www.b-eye-network.com/blogs/eckerson/archives/2013/09/classifying_bus.php
J. Lauer, S. Cameron, J. Nelson, V. Rocca, How to choose the right reporting tools for your instrument control system. Microsoft (2012). Retrieved from https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/jj129615(v=msdn.10)
S. Negash, Business intelligence. Commun. Assoc. Inf. Syst. 13, 177–195 (2004). https://doi.org/10.1002/9781118915240.ch7
E. Turban, R. Sharda, D. Delen, D. King, J.E. Aronson, Business Intelligence: A Managerial Approach, 2nd edn. (Prentice Hall, 2010). Retrieved from https://books.google.com/books?id=IvZ0RAAACAAJ&pgis=1
Acknowledgements
This article is a result of the project Deus Ex Machina: NORTE-01-0145-FEDER-000026, supported by Norte Portugal Regional Operational Program (NORTE 2020), under the PORTUGAL 2020 Partnership Agreement, through the European Regional Development Fund (ERDF).
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Cardoso, M., Guimarães, T., Portela, C.F., Santos, M.F. (2020). Data Extraction and Exploration Tools for Business Intelligence. In: Yang, XS., Sherratt, S., Dey, N., Joshi, A. (eds) Fourth International Congress on Information and Communication Technology. Advances in Intelligent Systems and Computing, vol 1041. Springer, Singapore. https://doi.org/10.1007/978-981-15-0637-6_42
Download citation
DOI: https://doi.org/10.1007/978-981-15-0637-6_42
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-15-0636-9
Online ISBN: 978-981-15-0637-6
eBook Packages: EngineeringEngineering (R0)