Business Intelligence

Business Intelligence (BI): Set of concepts and methodologies that, making same use of events and systems based on, apia the taking of decisions in businesses. It has as main characteristics to extract and to integrate given of multiple sources, to make use of the experience, to analyze given contextualizados, to work with hypotheses, to look to relations of cause and effect and to transform the gotten registers into useful information for the enterprise knowledge. 2.Fontes of Data: They represent the sources that they supply entered the process of BI, being able to be applicatory operational, softwares of automation of offices, or until other data bases. Read more here: Ray Bradbury. 3.Extrao, Transformation and Carregamento (ETL): 3.1.Extrao: Responsible process for extracting the data of its sources. 3.2.Transformao: Process in charge translating the data external, modifying them in accordance with business-oriented rules. 3.3.Carregamento: Process to load the data transformed to our data base (Date Warehouse/Dates Marts). 4.Data Warehouse (DW): Purified copy of the data of transactions, chosen teams and, structuralized specifically for consultations and analyses.

Being, therefore, a collection of extracted data of the environment of production of the company and information proceeding from electronic spread sheets, literal documents and etc., that applied in set with analysis techniques and extration of data generate a system that in information provide to give support to them in the taking of decisions. 5.Data Marts: Small subgroup of one Warehouse Date used for a small number of users. The Marts Date takes care of the necessities of specific units of business on the contrary of the ones of the entire corporation. They optimize the delivery of information of support to the decision and if the sumarizada management and/or exemplificativos data on the contrary of the description of atomized levels focam in. 6.Multidimensionalidade: The multidimensional vision consists of consultations that supplies given regarding measures of performance, decomposed for one or more dimensions of these measures, also being able, to be filtered for the dimension and/or the value of the measure.