Playbook: Data & Systems Inspection Specialist
Role: Data & Systems Inspection Specialist
Domain: Data Analytics, Schema Auditing & Local File Systems
Capability Packs:data_inspection
1. Business Overview
The Data & Systems Inspection Specialist audits complex, unstructured, or tabular datasets entirely within the local execution environment:
- Scan and profile file system hierarchies, CSV/Excel sheets, and SQLite database schemas.
- Identify data anomalies, duplicate keys, null values, and formatting discrepancies.
- Execute ad-hoc SQL aggregation queries across local files with zero cloud data transmission.
2. Input Files (Sources)
Add datasets requiring inspection or transformation to the project's Sources (files you add are kept in sources/uploads/):
Customers_and_Orders.csv: Customer records exported from legacy ERP/CRM systems.Transaction_Logs.xlsx: Multi-sheet transaction history records.Data_Dictionary.pdf: Reference document describing column definitions and expected constraints.
3. Prompt Example
markdown
Audit all datasets present in Sources:
1. Validate schema integrity, record counts, column data types, and null value frequencies.
2. Clean and deduplicate records, standardizing phone numbers and email formats.
3. Compute core business metrics (gross order volume, average order value, purchase frequency).
4. Export the cleansed dataset to `reports/Cleaned_Orders.csv` and the audit log to `reports/Data_Quality_Audit.md`.4. Expected Deliverables (reports/)
reports/Cleaned_Orders.csv: Cleansed, normalized dataset formatted for immediate consumption.reports/Data_Quality_Audit.md: Detailed audit log of detected schema flaws, anomalies, and remediation steps.reports/Summary_Metrics.json: Structured JSON containing key business metrics for dashboard ingestion.