Comparação de ferramentas de data warehouse: estudo de caso com dados do IBGE

Abstract

With the need to get information about the Market, like best clients, risks the company is taking, the company and competitors prospects, between another factors that can influence the manager decisions, appears a need of a data base that allow to store and give a quick access to the company history, also that these information would be retrieved in a way that make it easy to do the data analysis, that’s how DW (Data Warehouse) emerged, where the project result is, information available for management, behavior curve view, agility tools for decision support, and a lot more. Data Warehouse is a data base made for decision support of final users. It gives information to managers, but there is the need to know how to filter these, how to get the information from the DW and thats the point of BI (Business Intelligence) tools. They implement BI techniques that intend to avoid surprises; reduce uncertainty on decision take, predict industry changes, among other functionalities. Apart from the sophistication different levels, the BI process is about to transform data in information. BI has the support from several areas, like Information Technology, Science of information and Management.