Juve® Business Intelligence & more

Se trata de una intuitiva y práctica guía que recorre la que es una de las soluciones de cuadro de mando más populares del mercado: Crystal Xcelsius, del fabricante Business Objects. Descargar aqui / Download Here -->

Business Intelligence es disponer en mi empresa de un repositorio de datos (Datawarehouse) en donde poder hacer consultas complejas para obtener valor añadido.   Business Intelligence es poner la tecnología a disposición de la empresa para la toma de decisiones. Business Intelligence es CRM, Datawarehouse, ERP, DataMart, Cuadros de Mando, etc. Business Intelligence es un conjunto de herramientas y tecnologías basadas en la información de la empresa, para obtener sobre ellas valor añadido.   Business Intelligence es disponer la información de la empresa orientada a conseguir su estrategia. OK

¿ETL o E-LT? How can we explain this? Now working on the article ...

Friends. Here the Book of Lord Ralph Kimball ETL. I hope it's for your help. Send me your comments. Download/Descargar.   Book Description The extract, transform, and load (ETL) phase of the data warehouse development life cycle is far and away the most difficult, time-consuming, and labor-intensive phase of building a data warehouse. Done right, companies can maximize their use of data storage; if not, they can end up wasting millions of dollars storing obsolete and rarely used data. Bestselling author Ralph Kimball, along with Joe Caserta, shows you how a properly designed ETL system extracts the data from the source systems, enforces data quality and consistency standards, conforms the data so that separate sources can be used together, and finally delivers the data in a presentation-ready format.

In response to the question I made a new colleague in BI. What is ETL? To obtain the data warehouse sequentially develop the data extraction, processing, and finally loading into the reservoir. The extraction process involves obtaining information from different sources (databases and operational files), both internally and externally, through data management tools. We must transform the data into those required for deposit. The process consists of filtering, cleaning, cleansing, standardization and integration of information. This should be done, since the operational databases are designed to support multiple production applications often differ in format, then, may be the same data elements, but names and inconsistent formats and encodings. All these inconsistencies should be resolved before taking the last step of this process that corresponds to the loading of data into the data warehouse. Reference Book: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, ...