dmx gui

What is data integration? (building a single view of the truth)

Data integration defined Data integration is a common industry term referring to the requirement to combine data from multiple separate business systems into a single unified view, often called a single view of the truth. This unified view is typically stored in a central data repository known as a data warehouse. For example, customer data integration involves…

ETL ELT architecture

What is ETL?

ETL defined Extract, Transform and Load  or ETL is a standard information management term used to describe a process for the movement and transformation of data. ETL is commonly used to populate data warehouses and datamarts, and for data migration, data integration and business intelligence initiatives. ETL processes can be built by manually writing custom scripts or code, with…

Find the signal in the noise

Big Data: When data quality doesn’t matter

If BI is about reporting, analytics is about creating insight. [Tweet this] The old adage of garbage in, garbage out applies to both BI and to analytics. Yet, the introduction of Hadoop into the analytics architecture changes how poor quality data impacts us, and may create the illusion that poor data quality is no longer of concern. Moving…