Smart Data Curation

With DQLabs you can Identify your optimal data pre-processing strategies and automate your data curation process of assembling, managing and presenting your data to assure control of your data quality thresholds.

Overview

With the explosion of data from, an endless variety of data integrations and sources, more and more companies are struggling with data curation aka data wrangling which is the process of transforming and mapping data from one form to another.

Let DQLabs reduce your operational costs and create trustworthy outcomes using smart curated datasets assisted by our innovations in AI/ML based algorithms and models.

Data Curation Features

DQLabs AI/ML based smart curation modules identify the optimal data preprocessing strategies by automating data curation while providing controls on your data quality thresholds. The data curation process is further enhanced with reinforcement learning which predicts the type of repair needed to resolve an inconsistency and applies that repair to improve quality.

Generate more accurate data

Using an optimal mix of unsupervised and supervised machine learning (ML) including advanced algorithms, all unknown patterns in your data are identified so you can cleanse and provide more highly accurate data.

Multiple levels of data cleansing

Benefit from DQLabs ability to deduplicate, clean and enrich your data using three select levels of curation – basic, reference and advanced algorithms. All of these are automatically configured based on DQLab’s patented DataSense™ module.

Built-In Continuous Learning

As market environments shift, so do business strategies including the underlying data in your business operations. As the data evolves and changes into new forms and different lifecycles, DQLabs learning platform continuously evolves to automatically remove and create new rules to improve the process of data cleansing.

Visual Learning with Detailed Curation Reports

DQLabs visual learning environment provides the capability for business and technical users to uncover the root cause of quality issues via detailed and automated reporting of results. Advanced leading-edge algorithms automatically discover within minutes patterns, insights, fraud, missing values and correlations across all data silos.

Human Guided Curation for Reinforcement Learning

As business analysts, data stewards and data analyst interact with DQLabs, the platforms integrated automated intelligence (AI) learns the user behavior from those interactions to guide and reinforce automated smart actions as well as determine actions that need further refinement. This process of scaling the human element with ML algorithms helps you cleanse vast amounts of data more effectively and smarter.

Transform by Configuration

Rather than authoring or creating heavy extraction, transform and load (ETL) workflows for cleansing the data, DQLabs provides an easy and intuitive way of configuring transform tasks to improve the consistency, validity, and reliability of the data.

Standardize in multiple ways

DQLabs automatically standardizes your data using various different algorithm sets utilizing distance / similarity / phonetic based clustering along with pattern detection, functions, and reference libraries.

Data Curation

DQLabs curation module utilizing leading edge ML identifies the optimal data preprocessing strategies and automates data curation with controls on data quality thresholds. This is further enhanced with the help of reinforcement learning which predicts the types of updates needed to resolve inconsistencies. Use DQLabs data curation module to

  • Generate more accurate data
  • Initiate multiple levels of data cleansing
  • Apply built-in continuous learning
  • Employ visual learning with detailed curation reports
  • Benefit from human guided curation for reinforcement learning
  • Transform by configuration
  • Standardize in multiple ways

Best Practices

Data Observability is Irrelevant without Context

BLOGS

Data Observability is Irrelevant without Context

With today’s rapid growth in data, a focus towards data quality is more critical than ever before. Since the first bit of digital data existed Data Quality has existed alongside it as a practice, and yet after decades gaps in the marketplace still exist as the focus towards business impact is often forgotten. We quite often get lost in the mix of what to measure or how to measure instead of focusing in on the real purpose of what Data Quality was meant to be.

Data Observability is Irrelevant without Context

In fact…

Data Quality is never about the “Data” but all about “Business”.

As we navigate through this space, it is also very important to identify noise from true value. For folks who have not read the six guiding factors to navigate around noise in data quality, take a moment to read Part 1 — The Noise in Modern Data Quality of this series. For the remaining folks, let’s continue to explore the new kid in the block — Data Observability.

First of all is Observability new? Not really!

It has its origination from control theory to industrial processes to software and centers around the idea of understanding/observing /inferring an internal state of a systems using its external output. But to understand and be successful in Observability, you must have the ability to observe the behavior of a system and derive its health state from it. Also it’s important to understand the difference between observability and monitoring. Monitoring is best suited for known failure modes while Observability is for debugging using the insights inferred. You can also use this comparison from Splunk on Monitoring vs. Observability as well to understand further but the main goal is the ability to notice (observe) something you have from system behavior.

Data Observability and Data Monitoring

OK, so why is observability relevant?

During the last few years, we have seen many transformations happening in the “modern data stack” space. “Modern data stack” meaning a set of tools and technologies that enable analytics, particularly for transactional data. It started with the enormous scalability and elasticity of cloud data warehouses and extends to modern data pipelines allowing us to carry large amounts of data from multiple sources and transform the data directly inside the warehouses (ELT) at ease. This trend has also now morphed to ETLT (extract-transform-load-transform i.e., best of both worlds of ELT and ETL), ELTG (with governance layer), and merging of data lakes and warehouses into a Lakehouse or Unified Analytics Warehouse. With such complexities in mind, yes — it is relevant to have a system to observe and funnel up things to debug so as to eliminate and prevent any downtime or provide insights on the health of data sources.

However, when you extend Observability to Data Quality or, as I like to call it “Business Quality”, now you are no longer talking just “data” but “business” aka “data with context”. Data in its raw form without any application of use case (i.e., how an organization uses and governs, how it collects and handles, or its functional value) doesn’t have “context”. Let’s take a very simple example of measuring the total records (“volume” — one of the pillars of observability). If a million rows suddenly drop from your data, yes — you should be aware of it in the context of understanding the health of your data sources. Yet, the problem comes when you extend observability to a broader umbrella of data quality as it can pose some unique challenges. In this example, let’s say that the drop in records when debugged could be related to a strategic leadership move to close a couple of retail stores which weren’t profitable. Let’s think about another example — an email column that is used for marketing is treated very differently than an email column used for risk and authentication purposes. Same email, same format but different use case, therefore the broader application of data quality measurements and the underlying purpose are very different. This poses a big challenge.

Now if you take that and apply it across all your petabytes of data sources, various monitors, as well as pipelines, the amount of time needed to debug each of these “alerts” can be time-consuming and daunting. When extended into benchmarking to discover anomalies, it is bound to create even more false positives or negatives as well. To me, just throwing anomaly detection at your data doesn’t create value. Why? In the world of outlier detection even with all of today’s advanced algorithms, model accuracy isn’t complete without some sort of understanding or ground truth to compare with the model’s predictions. In other words, the expectation is important even before the measurement is done as without expectation there is no base to draw conclusions from. This poses a big challenge when you draw observability beyond its limit to the wonderful world of Data Quality. With Data Quality it is not only health checks but there are further levels of checks around all aspects of objective and subjective dimensions of Data Quality. This requires understanding the context.

If you speak to any expert or customer who has had their hands dirty in Data Quality, the first thing you will hear is —

“Measurement was never the challenge but making measurements purposeful is the one and only challenge”.

So, for anyone who sets out to build an “actionable” data quality assessment, starting without an ultimate purpose will result in more data chaos. This means for a true Modern Data Quality platform, you have to go beyond observability into the world of inferring metadata, use of artificial intelligence/machine learning (AI/ML) to understand the context or semantics, expand the universe into knowledge graphs and bring new practices through automation to simplify data quality processes. This is an exciting time to be in the space of Modern Data Quality as we are just scratching the surface of what we can bring innovation to.

To conclude, if you are talking about data observability and applying it across the most basic health checks of your data sources and pipelines, then it is still relevant. But, if you are going to stretch observability across all your subjective and objective dimensions of Data Quality / Business Quality without context, then it’s irrelevant and it’s time to think differently about your data culture.

 

Author

Raj Joseph,

President & CEO DQLabs, Inc.

View More Arrow image