Uma proposta para aplicação de data warehouse na superintendência de tecnologia da informação da UFPB

Abstract

Business Intelligence is an important practice for the process of decision making in business. Its technologies, such as Data Warehouse and On-line Analytical Processing facilitating the analysis of information that are performed by managers within organizations. In a university, for example, systems that store a large amount of data in their databases, and queries to these databases can take a long time to load due to the amount of data to be filtered. In this case, have Business Intelligence technologies that make the filtering and generation of knowledge easier and faster in an analytical way with a easy understanding rate. It is a great advantage to managers in their decision making processes. This work is a proposal of application of Data Warehouse Technology in Information Technology Oversight of the Federal University of Paraiba, aiming to assist managers in decision-making processes within the institution. In creating the Data Warehouse Business Intelligence concepts will be applied, and the results will be analyzed based on the concepts of Online Analytical Processing.