Wayne Yaddow

MARCH 14, 2025

How dbt Core aids data teams test, validate, and monitor complex data transformations and conversions Photo by NASA on Unsplash Introduction dbt Core, an open-source framework for developing, testing, and documenting SQL-based data transformations, has become a must-have tool for modern data teams as the complexity of data pipelines grows.

Data Transformation 52

Data Transformation Testing Unstructured Data Data Quality 52

AWS Big Data

JANUARY 15, 2025

In the following section, two use cases demonstrate how the data mesh is established with Amazon DataZone to better facilitate machine learning for an IoT-based digital twin and BI dashboards and reporting using Tableau. In the past, one-to-one connections were established between Tableau and respective applications.

IoT 110

IoT Machine Learning Metadata Data-driven 110

erwin

APRIL 29, 2020

These tools range from enterprise service bus (ESB) products, data integration tools; extract, transform and load (ETL) tools, procedural code, application program interfaces (API)s, file transfer protocol (FTP) processes, and even business intelligence (BI) reports that further aggregate and transform data.

Key Performance Indicator 111

Key Performance Indicator Metadata Data Governance Data Quality 111

Wayne Yaddow

FEBRUARY 26, 2025

AI is transforming how senior data engineers and data scientists validate data transformations and conversions. Artificial intelligence-based verification approaches aid in the detection of anomalies, the enforcement of data integrity, and the optimization of pipelines for improved efficiency.

Data Transformation 52

Data Transformation Testing Data-driven Data Quality 52

Alation

DECEMBER 7, 2021

Alation and Bigeye have partnered to bring data observability and data quality monitoring into the data catalog. Read to learn how our newly combined capabilities put more trustworthy, quality data into the hands of those who are best equipped to leverage it. trillion each year due to poor data quality.

Data Quality 52

Data Quality Data-driven Metrics Dashboards 52

CIO Business Intelligence

JUNE 23, 2022

Yet as companies fight for skilled analyst roles to utilize data to make better decisions , they often fall short in improving the data supply chain and resulting data quality. Without a solid data supply-chain management practices in place, data quality often suffers. First mile/last mile impacts.

Data Quality 98

Data Quality Key Performance Indicator Metrics KPI 98

Wayne Yaddow

MARCH 5, 2025

In this post, well see the fundamental procedures, tools, and techniques that data engineers, data scientists, and QA/testing teams use to ensure high-quality data as soon as its deployed. First, we look at how unit and integration tests uncover transformation errors at an early stage.

Testing 52

Testing Data Transformation Statistics Metadata 52

Wayne Yaddow

FEBRUARY 6, 2025

Common challenges and practical mitigation strategies for reliable data transformations. Photo by Mika Baumeister on Unsplash Introduction Data transformations are important processes in data engineering, enabling organizations to structure, enrich, and integrate data for analytics , reporting, and operational decision-making.

Testing 52

Testing Data Transformation Data-driven Manufacturing 52

CIO Business Intelligence

NOVEMBER 7, 2023

Given the importance of sharing information among diverse disciplines in the era of digital transformation, this concept is arguably as important as ever. The aim is to normalize, aggregate, and eventually make available to analysts across the organization data that originates in various pockets of the enterprise.

Data Warehouse 142

Data Warehouse Digital Transformation Data-driven Reporting 142

AWS Big Data

NOVEMBER 9, 2023

In this post, we delve into a case study for a retail use case, exploring how the Data Build Tool (dbt) was used effectively within an AWS environment to build a high-performing, efficient, and modern data platform. It does this by helping teams handle the T in ETL (extract, transform, and load) processes.

Data Warehouse 126

Data Warehouse Testing Data Quality Reporting 126

erwin

SEPTEMBER 17, 2020

According to erwin’s “2020 State of Data Governance and Automation” report , close to 70 percent of data professional respondents say they spend an average of 10 or more hours per week on data-related activities, and most of that time is spent searching for and preparing data.

Cost-Benefit 143

Cost-Benefit Data Governance Metadata Reporting 143

AWS Big Data

DECEMBER 13, 2023

In addition to using native managed AWS services that BMS didn’t need to worry about upgrading, BMS was looking to offer an ETL service to non-technical business users that could visually compose data transformation workflows and seamlessly run them on the AWS Glue Apache Spark-based serverless data integration engine.

Metadata 110

Metadata Data Lake Visualization Data Transformation 110

AWS Big Data

AUGUST 1, 2024

However, you might face significant challenges when planning for a large-scale data warehouse migration. Trace the flow of data from its origins in the source systems, through the data warehouse, and ultimately to its consumption by reporting, analytics, and other downstream processes.

Data Warehouse 114

Data Warehouse KPI Optimization Cost-Benefit 114

CIO Business Intelligence

JANUARY 24, 2024

“Establishing data governance rules helps organizations comply with these regulations, reducing the risk of legal and financial penalties. Clear governance rules can also help ensure data quality by defining standards for data collection, storage, and formatting, which can improve the accuracy and reliability of your analysis.”

Data Strategy 136

Data Strategy Strategy Unstructured Data Data Governance 136

erwin

MARCH 4, 2021

And when you talk about that question at a high level, he says, you get a very “simple answer,”– which is ‘the only thing we want to have is the right data with the right quality to the right person at the right time at the right cost.’. The Why: Data Governance Drivers. Why should companies care about data governance?

Data Governance 122

Data Governance Digital Transformation Data-driven Cost-Benefit 122

Smart Data Collective

OCTOBER 13, 2021

There are countless examples of big data transforming many different industries. There is no disputing the fact that the collection and analysis of massive amounts of unstructured data has been a huge breakthrough. Data virtualization is ideal in any situation where the is necessary: Information coming from diverse data sources.

Visualization 145

Visualization Cost-Benefit Big Data Prescriptive Analytics 145

Sisense

AUGUST 28, 2020

Uncomfortable truth incoming: Most people in your organization don’t think about the quality of their data from intake to production of insights. However, as a data team member, you know how important data integrity (and a whole host of other aspects of data management) is.

Data Integration 101

Data Integration Testing Data Quality Data-driven 101

Jen Stirrup

SEPTEMBER 30, 2021

Before we dive in, let’s define strands of AI, Machine Learning and Data Science: Business intelligence (BI) leverages software and services to transform data into actionable insights that inform an organization’s strategic and tactical business decisions.

Business Intelligence 135

Business Intelligence Data mining Machine Learning Testing 135

CIO Business Intelligence

DECEMBER 6, 2023

An IDC report estimated the global IT developer shortage will reach four million by 2025, leaving businesses struggling to accelerate digital transformation without the needed workforce.

Digital Transformation 116

Digital Transformation Software Cost-Benefit Manufacturing 116

Jet Global

MAY 28, 2019

The success of any business into the next year and beyond will depend entirely on the volume, accuracy, and reportability of the data they collect—and how well the business can analyze, extract insight from, and take action on that data. Enter the Warehouse.

Data Warehouse 85

Data Warehouse Reporting Business Intelligence Sales 85

Ontotext

NOVEMBER 18, 2021

OntoRefine is a data transformation tool that lets you unite plenty of data formats and get them into your triplestore. That way, we can simplify our lives in the future, so when we seek reports for one building (say Building123), we also get information about the “other” building (BuildingABC), which is at the same address.

Visualization 98

Visualization Reporting Metadata Enterprise 98

IBM Big Data Hub

FEBRUARY 9, 2023

In our last blog , we delved into the seven most prevalent data challenges that can be addressed with effective data governance. Today we will share our approach to developing a data governance program to drive data transformation and fuel a data-driven culture.

Data Governance 76

Data Governance Business Objectives Data Quality Measurement 76

AWS Big Data

JULY 20, 2023

Prior to the creation of the data lake, Orca’s data was distributed among various data silos, each owned by a different team with its own data pipelines and technology stack. Moreover, running advanced analytics and ML on disparate data sources proved challenging.

Data Lake 98

Data Lake Analytics Snapshot Data Quality 98

Octopai

JANUARY 19, 2021

With Octopai’s support and analysis of Azure Data Factory, enterprises can now view complete end-to-end data lineage from Azure Data Factory all the way through to reporting for the first time ever.

Metadata 52

Metadata ROI Machine Learning Data Quality 52

erwin

JANUARY 11, 2019

Organizations have spent a lot of time and money trying to harmonize data across diverse platforms , including cleansing, uploading metadata, converting code, defining business glossaries, tracking data transformations and so on. So questions linger about whether transformed data can be trusted.

Data Governance 40

Data Governance Risk Metadata Management 40

DataKitchen

DECEMBER 9, 2022

Some of the key benefits of DataOps include: Improved speed and reliability: By automating and streamlining data-related tasks and processes, DataOps can help organizations to accelerate the development and deployment of data-driven solutions, and to improve the reliability of their data analytics and machine learning initiatives.

Machine Learning 130

Machine Learning Data-driven Optimization Data Analytics 130

Ontotext

MARCH 20, 2024

Traditional data integration methods struggle to bridge these gaps, hampered by high costs, data quality concerns, and inconsistencies. Studies reveal that businesses lose significant time and opportunities due to missing integrations and poor data quality and accessibility.

Data-driven 52

Data-driven Strategy Sales Data Integration 52

AWS Big Data

APRIL 5, 2023

The company decided to use AWS to unify its business intelligence (BI) and reporting strategy for both internal organization-wide use cases and in-product embedded analytics targeted at its customers. In this post, we share how Showpad used QuickSight to streamline data and insights access across teams and customers.

Dashboards 52

Dashboards Reporting Cost-Benefit Visualization 52

AWS Big Data

MARCH 3, 2023

Although Tricentis has amassed such data over a decade, the data remains untapped for valuable insights. Each of these tools has its own reporting capabilities that make it difficult to combine the data for integrated and actionable business insights. Finally, data integrity is of paramount importance.

Software 52

Software Data Lake Testing Dashboards 52

IBM Big Data Hub

MARCH 14, 2024

Businesses face significant hurdles when preparing data for artificial intelligence (AI) applications. The existence of data silos and duplication, alongside apprehensions regarding data quality, presents a multifaceted environment for organizations to manage. With Netezza support for 1.2

Cost-Benefit 75

Cost-Benefit Metadata Optimization Management 75

Peter James Thomas

OCTOBER 30, 2018

Most of the time, the article does nothing more than to reflect the continuing confusion about whether or not organisations need CDOs and – assuming that they do – what their remit should be and who they should report to [4]. It may well be that one thing that a CDO needs to get going is a data transformation programme.

Marketing 51

Marketing Strategy Data Architecture Data Strategy 51

Alation

OCTOBER 28, 2021

To make good on this potential, healthcare organizations need to understand their data and how they can use it. These systems should collectively maintain data quality, integrity, and security, so the organization can use data effectively and efficiently. Why Is Data Governance in Healthcare Important?

Data Governance 52

Data Governance Measurement Data Quality Metrics 52

Smarten

JANUARY 4, 2018

Extract, Transform and Load (ETL) refers to a process of connecting to data sources, integrating data from various data sources, improving data quality, aggregating it and then storing it in staging data source or data marts or data warehouses for consumption of various business applications including BI, Analytics and Reporting.

Data Warehouse 40

Data Warehouse OLAP Data Governance Optimization 40

Jet Global

MAY 9, 2024

A data pipeline is a series of processes that move raw data from one or more sources to one or more destinations, often transforming and processing the data along the way. This can include tasks such as data ingestion, cleansing, filtering, aggregation, or standardization.

Data Lake 52

Data Lake Data Warehouse Business Intelligence Machine Learning 52

Jet Global

FEBRUARY 23, 2024

The quick and dirty definition of data mapping is the process of connecting different types of data from various data sources. Data mapping is a crucial step in data modeling and can help organizations achieve their business goals by enabling data integration, migration, transformation, and quality.

Data Warehouse 52

Data Warehouse Reporting Data Transformation Visualization 52

Jet Global

MARCH 13, 2024

Between complex data structures, data security questions, and error-prone manual processes, merging data from disparate sources into a single system can quickly turn your routine reporting processes into a stressful and time-consuming ordeal.

Reporting 52

Reporting Finance Data Quality Sales 52

Jet Global

AUGUST 24, 2023

Given your organizations focus on productivity, you know soon your team will working in a divided reporting environment. While the cloud infrastructure promises to bring positive changes, your company’s data will exist in both worlds: on-prem and the cloud.

Finance 52

Finance Reporting Data Integration Data Warehouse 52