26% and 92%, respectively, while Redash reached
12% and 76%, respectively.
In the compatibility side of things, Redash offers
a greater number of integrations and compatible
search engines, as it can be seen in the following
table.
Of these documented search engines, integrations
were tested only for with PostgreSQL and
MySQL, with the later being used due to issues
with PostgreSQL mentioned in the Experimental
Setup chapter.
For future work, we intend to test these Business
Intelligence tools using NoSQL search engines, e. g.,
MongoDB, supported by both Metabase and Redash,
in the Internet of Things (IoT) area. Data generated
by IoT devices is generally stored in these type of
Database Management Systems (DBMS), and, as we
mentioned in the State of Art chapter, IoT is one of
Business Intelligence’s most important areas of
actuation currently.
Likewise, we intend to test these BI platforms on
machines with more powerful specifications than the
computers used in this project, in order to verify the
differences in response times between databases with
configured indexes and databases without indexes.
Finally, although we have used some charting
options provided by these BI tools, we believe there
is margin for further exploration of these options in a
future approach.
ACKNOWLEDGEMENTS
This work is financed by national funds through FCT
- Fundação para a Ciência e Tecnologia, I.P., under
the project UID/Multi/04016/2019. Furthermore we
would like to thank the Instituto Politécnico de Viseu
and CI&DETS for their support.
REFERENCES
Gangadharan, G. R., & Swami, S. N. (2004, June). Business
intelligence systems: design and implementation
strategies. In 26th International Conference on
Information Technology Interfaces, 2004. (pp. 139-
144). IEEE.
Raden, N. (2005). Shedding light on shadow IT: Is Excel
running your business. DSSResources. com, 26.
Nandyala, C. S., & Kim, H. K. (2016). From cloud to fog
and IoT-based real-time U-healthcare monitoring for
smart homes and hospitals. International Journal of
Smart Home, 10(2), 187-196.
Wieder, B., & Ossimitz, M. L. (2015). The impact of
Business Intelligence on the quality of decision
making–a mediation model. Procedia Computer
Science, 64, 1163-1171.
Yeoh, W., & Koronios, A. (2010). Critical success factors
for business intelligence systems. Journal of computer
information systems, 50(3), 23-32.
Muntean, M., & Surcel, T. (2013). Agile BI-The Future of
BI. Informatica Economica, 17(3).
Lee, I., & Lee, K. (2015). The Internet of Things (IoT):
Applications, investments, and challenges for
enterprises. Business Horizons, 58(4), 431-440.
Negash, S., & Gray, P. (2008). Business intelligence.
In Handbook on decision support systems 2 (pp. 175-
193). Springer, Berlin, Heidelberg.
Watson, H. J., & Wixom, B. H. (2007). The current state of
business intelligence. Computer, 40(9), 96-99.
Gibson, M., Arnott, D., Jagielska, I., & Melbourne, A.
(2004). Evaluating the intangible benefits of business
intelligence: Review & research agenda.
In Proceedings of the 2004 IFIP International
Conference on Decision Support Systems (DSS2004):
Decision Support in an Uncertain and Complex
World (pp. 295-305). Prato, Italy.
Golfarelli, M., Rizzi, S., & Cella, I. (2004, November).
Beyond data warehousing: what's next in business
intelligence?. In Proceedings of the 7th ACM
internaional workshop on Data warehousing and
OLAP (pp. 1-6). ACM.
Hannula, M., & Pirttimaki, V. (2003). Business intelligence
empirical study on the top 50 Finnish
companies. Journal of American Academy of
Business, 2(2), 593-599.
Babu, K. V. S. N. (2012). Business intelligence: Concepts,
components, techniques and benefits. Components,
Techniques and Benefits (September 22, 2012).
Wixom, B., & Watson, H. (2010). The BI-based
organization. International Journal of Business
Intelligence Research (IJBIR), 1(1), 13-28.
Lapa, J., Bernardino, J., Figueiredo, A. (2014). A
comparative analysis of open source business
intelligence tools.
Lakhani, K. R., & Von Hippel, E. (2004). How open source
software works:“free” user-to-user assistance.
In Produktentwicklung mit virtuellen Communities (pp.
303-339). Gabler Verlag.
Coppola, C., & Neelley, E. (2004). Open source-opens
learning: Why open source makes sense for education.
Fitzgerald, B. (2006). The transformation of open source
software. MIS quarterly, 587-598.
Chengalur-Smith, I., Nevo, S., & Demertzoglou, P. (2010).
An empirical analysis of the business value of open
source infrastructure technologies. Journal of the
Association for Information Systems, 11(11), 708.
Metabase. (2019). Retrieved from https://metabase.com/
Redash helps you make sense of your data. (2019).
Retrieved from https://redash.io/
KDIR 2019 - 11th International Conference on Knowledge Discovery and Information Retrieval
474