An Evaluation of How Big-Data and Data Warehouses Improve Business Intelligence Decision Making Anthony Martins 1 , Pedro Martins 1 , Filipe Caldeira 1 , and Filipe Sá 1,2(B ) 1 Department of Computer Sciences, Polytechnic Institute of Viseu, Viseu, Portugal martinsanthony_arm@outlook.com, {pedromom,caldeira, filipe.sa}@estgv.ipv.pt 2 Artificial Intelligence and Computer Science Laboratory, University of Porto, Porto, Portugal Abstract. Analyze and understand how to combine data warehouse with busi- ness intelligence tools, and other useful information or tools to visualize KPIs are critical factors in achieving the goal of raising competencies and business results of an organization. This article reviews data warehouse concepts and their appropriate use in business intelligence projects with a focus on large amounts of information. Nowadays, data volume is more significant and critical, and proper data analysis is essential for a successful project. From importing data to display- ing results, there are crucial tasks such as extracting information, transforming it analyzing, and storing data for later querying. This work contributes with the proposition of a Big Data Business Intelligence architecture for an efficiently BI platform and the explanation of each step in creating a Data Warehouse and how data transformation is designed to provide useful and valuable information. To make valuable information useful, Business Intelligence tools are presented and evaluates, contributing to the continuous improvement of business results. Keywords: Data Warehouse · Big Data · Data Mart · Business Intelligence · OLAP · ETL · Power BI · Analytical methods 1 Introduction Information Systems (IS) present themselves as the engine that drives companies to success by using vast amounts of information collected and stored in databases (DB). On the IS field, several authors try to create a definition for IS. In [1] authors define Information System as any system that has information as input to generate output information. In [2] an Information System is a combination of procedures, data, people and IT to achieve the organisation’s goals. For the current economic ecosystem, exploring and learning from raw data has become a necessary core competence. It is clear that by focusing on organisational learning and competitive advantage, many organisations are achieving successful results and becoming more independent in today’s business market. As organisations learn how © The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Switzerland AG 2020 Á. Rocha et al. (Eds.): WorldCIST 2020, AISC 1159, pp. 609–619, 2020. https://doi.org/10.1007/978-3-030-45688-7_61