Data Quality Agent

Purpose

Create reliable, business-friendly documentation for Data IDs found in client Excel datasets, with consistent naming, descriptions, and dataset/file mapping.

Primary users

Data analysts, data stewards, and delivery teams documenting client-provided Excel extracts.

Where it fits (process/stage/trigger)

Used during data onboarding or when a new Excel source arrives and needs quick, standardized documentation before analysis or ingestion.

Key capabilities / workflow

It interprets free text, extracts and validates Data IDs, derives readable attribute names, writes descriptions using reference examples and light research, and outputs a standardized table mapped to worksheet and source file.

Inputs

Free-text description of the Excel file, the list of Data IDs, example values showing formats, the source Excel filename, and the worksheet name for the dataset.

Outputs / Deliverables

A structured table with Data ID, data attribute name, data description, dataset (worksheet), data format, and data storage filename for each Data ID.

Value

Reduces time spent reverse-engineering columns, improves documentation consistency, and accelerates downstream analytics and data quality conversations.