Construção de um data warehouse, aliado a uma ferramenta open source ireport na geração de informações para tomada de decisão

Abstract

In most business organizations, it is a fact the problem of lack of the correct interpretation of information and difficulties of group ing them , for getting a new knowledge. To this solution presents the literature data warehouse technology. This technology is a solution that looks for a flexible and efficient options to treat a huge volume of data and obtain information that help in the decision-making process. Thus, this work presents process of constructing an application that discovery the Data Warehouse technology. The data has been collected in a the pharmacy located in the Ponta Grossa region, and standardized to facilitate the consult and extraction of knowledge. For implementing the case study, it was used the Pentaho tool, that supports the entire process of Data Warehouse and proved adequate in the case study. It was showed the iReport tool , responsible for generating reports and the end of the study had full integration with Pentaho, generating reports, according to requested. In addition, also the difficulty and benefic discovered are listed with the development of the work.