Data Integration: ETL or ELT?

Data integration: ETL vs ELTModern enterprises gather data from many disparate sources, including social media, websites, customer databases (CRM systems, sales records etc), customer support systems, and HR software.

Merely collecting lots of data isn't useful in itself—it's the insights you get from such data that can drive more informed business decisions. This post aims to teach you about the bedrock processes required for obtaining insights from your data—ETL and ELT.

We'll begin by discussing data integration, before moving on to two vital forms of data integration—ETL and ELT. When you're finished reading, you'll fully understand what ETL and ELT are, and which process is better suited to your business in terms of getting actionable insights from different data sources..  

La mejor plataforma de Business Intelligence

Antes de realizar la implantación de un sistema de Business Intelligence, o para plantearnos cambios en las herramientas que estamos utilizando en uno ya existente, es altamente recomendable echar un vistazo al Cuadrante mágico para Plataformas de Business Intelligence de Gartner.
En este cuadrante la prestigiosa consultora posiciona las plataformas más conocidas del mercado en función de la 'Habilidad en la ejecución' y de la 'Amplitud de visión'.