# clarrent/customer-dqa-sq architecture

> Architecture diagram of the GitHub repository clarrent/customer-dqa-sq, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-25). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/clarrent/customer-dqa-sq
- Repository: https://github.com/clarrent/customer-dqa-sq
- Video tour (about a minute): https://gitdiagram.com/clarrent/customer-dqa-sq/video

## Overview

This repository documents a manual customer-data quality workflow: import the raw CSV into MySQL, profile and audit the table, apply verified fixes, and track issues in a spreadsheet. The README supports these relationships, but no source excerpts are available to establish finer-grained query execution or automated links between artifacts; the audit, fixes, and issue log should be treated as separate hand-operated steps.

Main entry points: [`01_dqa_audit.sql`](https://github.com/clarrent/customer-dqa-sq/blob/main/01_dqa_audit.sql) (Audit queries), [`02_cleaning_fixes.sql`](https://github.com/clarrent/customer-dqa-sq/blob/main/02_cleaning_fixes.sql) (Verified fixes), [`dirty_customers_fixes.xlsx`](https://github.com/clarrent/customer-dqa-sq/blob/main/dirty_customers_fixes.xlsx) (Issue log), [`dirty_customers.csv`](https://github.com/clarrent/customer-dqa-sq/blob/main/dirty_customers.csv) (Raw customer data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_input["Data input"]
  node_workbench["MySQL Workbench"]
  node_raw_csv["Raw customer data"]
  node_customer_table[("dirty_customers table")]
end

subgraph group_audit["Data assessment"]
  node_audit_sql["Audit queries<br/>[01_dqa_audit.sql]"]
  node_audit_results["Audit findings"]
end

subgraph group_remediation["Fixes and handoff"]
  node_fixes_sql["Verified fixes"]
  node_issue_log["Issue log"]
  node_excel["Microsoft Excel"]
end

node_analyst(("Analyst"))

node_analyst -->|"imports and runs"| node_workbench
node_raw_csv -->|"imported as"| node_customer_table
node_workbench -->|"loads data"| node_customer_table
node_analyst -->|"runs checks"| node_audit_sql
node_audit_sql -->|"profiles and reads"| node_customer_table
node_audit_sql -->|"produces findings"| node_audit_results
node_analyst -->|"runs fixes"| node_fixes_sql
node_fixes_sql -->|"verifies and updates"| node_customer_table
node_analyst -->|"documents issues"| node_issue_log
node_excel -->|"opens and tracks"| node_issue_log

click node_raw_csv "https://github.com/clarrent/customer-dqa-sq/blob/main/dirty_customers.csv"
click node_audit_sql "https://github.com/clarrent/customer-dqa-sq/blob/main/01_dqa_audit.sql"
click node_fixes_sql "https://github.com/clarrent/customer-dqa-sq/blob/main/02_cleaning_fixes.sql"
click node_issue_log "https://github.com/clarrent/customer-dqa-sq/blob/main/dirty_customers_fixes.xlsx"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_workbench,node_raw_csv,node_customer_table toneBlue
class node_audit_sql,node_audit_results toneAmber
class node_fixes_sql,node_issue_log,node_excel toneMint
class node_analyst toneIndigo
```

## Components

### Data input

- **MySQL Workbench**
- [Raw customer data](https://github.com/clarrent/customer-dqa-sq/blob/main/dirty_customers.csv): `dirty_customers.csv`
- **dirty_customers table**

### Data assessment

- [Audit queries](https://github.com/clarrent/customer-dqa-sq/blob/main/01_dqa_audit.sql): `01_dqa_audit.sql`
- **Audit findings**

### Fixes and handoff

- [Verified fixes](https://github.com/clarrent/customer-dqa-sq/blob/main/02_cleaning_fixes.sql): `02_cleaning_fixes.sql`
- [Issue log](https://github.com/clarrent/customer-dqa-sq/blob/main/dirty_customers_fixes.xlsx): `dirty_customers_fixes.xlsx`
- **Microsoft Excel**

### Other components

- **Analyst**

## Connections

- Analyst → MySQL Workbench: imports and runs
- Raw customer data → dirty_customers table: imported as
- MySQL Workbench → dirty_customers table: loads data
- Analyst → Audit queries: runs checks
- Audit queries → dirty_customers table: profiles and reads
- Audit queries → Audit findings: produces findings
- Analyst → Verified fixes: runs fixes
- Verified fixes → dirty_customers table: verifies and updates
- Analyst → Issue log: documents issues
- Microsoft Excel → Issue log: opens and tracks