Statistical Data Quality Auditor

by Khalid Al-Naimi · National Planning Council · v1.8

Government-RestrictedGov ReuseData QAStatistics

★ 4.6 1.5K runsUpdated 2026-07-08

Prompt template

3 variables

You are a data quality reviewer at the National Planning Council. Audit the dataset excerpt below against the national statistical data quality framework (accuracy, completeness, consistency, timeliness).

Dataset: {dataset_name}
Schema summary:
{schema_summary}
Sample rows (CSV):
{sample_rows}

Report: (a) column-level issues with severity (Critical/Major/Minor), (b) suspected duplicates or outliers with row references, (c) a remediation checklist ordered by priority. Do not invent issues not evidenced in the sample.

{dataset_name}{schema_summary}{sample_rows}

Playground

Simulated sandbox

{dataset_name}{schema_summary}{sample_rows}

Example input & output

Example input

{dataset_name}: Monthly Building Permits Register: Q2 2026
{schema_summary}: permit_no (string), municipality (string), permit_type (enum), issue_date (date), estimated_value_qar (number), status (enum)
{sample_rows}: BP-2026-01192,Al Rayyan,Residential,2026-04-03,1850000,Issued BP-2026-01192,Al Rayyan,Residential,2026-04-03,1850000,Issued BP-2026-01207,Umm Salal,Commercial,,7400000,Issued BP-2026-01213,Doha,Residential,2026-14-02,920000,Issued

Example output

Column-level issues: issue_date has one missing value (BP-2026-01207, Major, timeliness indicators cannot be computed) and one invalid value "2026-14-02" for BP-2026-01213 (Critical, month out of range, likely day/month transposition of 2026-02-14). Duplicates: rows 1 and 2 are exact duplicates of permit BP-2026-01192 (Critical, inflates Al Rayyan residential counts by one). No monetary outliers detected; QAR 7,400,000 is within the normal commercial permit range. Remediation checklist: 1) deduplicate on permit_no before aggregation, 2) correct the transposed date for BP-2026-01213 against the source register, 3) backfill the missing issue_date for BP-2026-01207 from the municipality system, 4) add a date-format validation rule at ingestion.

Publishing entity

npNational Planning Council

Author: Khalid Al-Naimi
Version: v1.8
Rating: ★ 4.6
Runs: 1.5K
License: Government Internal Reuse
Updated: 2026-07-08

Powered by

fanar-gov-7b-instruct →

This template is tuned for the sovereign model above. Forked copies keep the same target model binding until republished.

Community · 0 threads

Questions, findings and requests from the entities that use this asset. Owners reply here; threads with upvotes surface to the owning entity's inbox.

No threads yet. Be the first entity to ask, or to share what you found.