article thumbnail

Data Profiling: What It Is and How to Perfect It

Alation

For any data user in an enterprise today, data profiling is a key tool for resolving data quality issues and building new data solutions. In this blog, we’ll cover the definition of data profiling, top use cases, and share important techniques and best practices for data profiling today.

article thumbnail

How to Deliver Data Quality with Data Governance: Ryan Doupe, CDO of American Fidelity, 9-Step Process

Alation

This starts by determining the critical data elements for the enterprise. These items become in scope for the data quality program. Step 2: Data Definitions. Here each critical data element is described so there are no inconsistencies between users or data stakeholders. Step 4: Data Sources.

professionals

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Data Hygiene Explained: Best Practices and Key Features

Pickl AI

By maintaining clean and reliable data, businesses can avoid costly mistakes, enhance operational efficiency, and gain a competitive edge in their respective industries. Best Data Hygiene Tools & Software Trifacta Wrangler Pros: User-friendly interface with drag-and-drop functionality. Provides real-time data monitoring and alerts.

article thumbnail

Data Catalog First, Master Data Management Second: Here’s Why

Alation

A data catalog communicates the organization’s data quality policies so people at all levels understand what is required for any data element to be mastered. Documenting rule definitions and corrective actions guide domain owners and stewards in addressing quality issues.

article thumbnail

Data Mesh vs. Data Fabric: A Love Story

Alation

But make no mistake: A data catalog addresses many of the underlying needs of this self-serve data platform, including the need to empower users with self-serve discovery and exploration of data products. In this blog series, we’ll offer deep definitions of data fabric and data mesh, and the motivations for each. (We

article thumbnail

phData Toolkit December 2023 Update

phData

This tool provides functionality in a number of different ways based on its metadata and profiling capabilities. The data source tool can also directly generate the Data Definition Language (DDL) for these tables as well if you decide not to use dbt!

article thumbnail

phData Toolkit August 2023 Update

phData

We’ve had many customers performing migrations between these platforms, and as a result, they have a lot of Data Definition Language (DDL) and Data Markup Language (DML) that needs to be translated between SQL dialects. Let’s take a look at some of the more interesting translations.

SQL 52