BI Data Quality Investigator
Trace, quantify, and fix data quality issues systematically
What You Can Do
You'll systematically diagnose data quality problems by developing structured root cause analysis frameworks, calculating the true business impact, and creating reproducible validation tests. This skill walks you through hypothesis-driven investigation, data lineage analysis, and remediation planning — turning data issues into documented fixes and preventive measures.
Features
Structured methodology to trace issues from symptom to source with competing hypotheses
Calculate downstream effects and business cost of data quality problems
Create SQL/Python tests that verify fixes and prevent regression
Track data flow across pipelines to identify contamination points
Generate metrics-based health reports by source, table, and dimension
Systematically test competing root causes with evidence
Document fix procedures, verification steps, and stakeholder communication
Example Output
Investigation Summary
- Issue: Revenue dashboard shows $500K discrepancy vs. GL records
- Root cause: Timezone conversion error in ETL pipeline (UTC vs. EST)
- Impact: $500K in unreconciled transactions affecting monthly close
- Validation test: SQL query comparing GL dates before/after conversion
Remediation Playbook
- Apply timezone fix to ETL transformation
- Backfill affected 90-day period using validation query
- Deploy updated pipeline with regression test
- Monitor dashboard reconciliation daily for 2 weeks
Quality Scorecard
| Data Source | Completeness | Timeliness | Accuracy |
|---|---|---|---|
| Billing API | 99.8% | 2h lag | 99.2% |
| GL Extract | 100% | 24h lag | 99.9% |
What's Included
- SKILL.md: Core investigation framework with decision trees and templates
- Root cause analysis template: Structured worksheet for tracing issues
- Data quality validation checklist: Questions to verify each hypothesis
- Impact assessment worksheet: Calculate affected records and business cost
- SQL/Python validation script templates: Ready-to-run quality tests
- Investigation report template: Stakeholder-ready documentation
Who It's For
- Data engineers — Investigating pipeline failures and data contamination
- BI analysts — Troubleshooting dashboard inconsistencies and metric discrepancies
- Data quality managers — Conducting audits and compliance validations
- Analytics leads — Assessing data reliability for critical decision-making
- Database administrators — Investigating data corruption or sync issues
Best For
- Diagnosing unexplained metric discrepancies between systems
- Creating proactive data quality testing frameworks
- Quantifying business impact of data issues for stakeholders
- Building data governance standards and quality SLAs
- Training teams on systematic root cause investigation
You might also like
You can search Wikidata using four complementary methods: keyword search via the Action API for label-based lookups, semantic/hybrid search through the Vector Database for fuzzy concept matching, direct entity retrieval via Special:EntityData for instant JSON data, and SPARQL queries through WDQS for complex graph relationships and reporting. Each method is optimized for different use cases—from quick entity lookups to multi-table data analysis across millions of linked facts.
by diegosouzapw
You can design statistically valid experiments with proper power analysis, choose the right statistical tests for your data type, analyze results while controlling for multiple comparisons, and generate publication-ready reports with accurate interpretation of findings. Claude helps you avoid common statistical pitfalls and ensures your experimental claims are well-supported by evidence.
by moonwell-fi
This skill automatically documents your entire analytics infrastructure by analyzing data sources, transformations, and outputs. You'll generate production-ready data dictionaries with field definitions, lineage maps showing data flow across systems, and transformation documentation that explains logic and dependencies. Save weeks of manual documentation work while keeping your analytics stack discoverable as it evolves.
by moonwell-fi
You'll build comprehensive data quality test suites that validate transformations, detect anomalies, and document standards across your dbt and SQL pipelines. This skill generates production-ready test configurations, anomaly detection protocols, and validation rules that catch data issues before they impact analytics.
by moonwell-fi
You can rapidly compile, organize, and format disparate health economic evidence—from clinical trials to cost-effectiveness analyses—into structured, regulatory-compliant dossiers. This skill maps your evidence to specific payer and HTA requirements, automatically generates evidence hierarchies, and produces submission-ready dossier outlines with formatting that meets regulatory standards for NICE, EUnetHTA, and other major bodies.
by moonwell-fi
You can structure comprehensive health technology assessments (HTAs) that organize clinical evidence, economic analyses, and regulatory considerations into evidence-based coverage recommendations. This skill helps you synthesize clinical trial data, health economic models, and real-world evidence into clear, defensible payer coverage determinations. You'll generate professional HTA reports that align with major frameworks like ICER, CADTH, and NICE standards.
by moonwell-fi
This skill detects your project framework (Vite, Next.js, plain Node, or monorepo) and automatically configures agent-tail to pipe dev server and browser console logs into unified log files. You'll get a proposed configuration tailored to your setup, install agent-tail with the correct plugins, and have logs immediately available for AI agents to consume and analyze.
by moonwell-fi
This skill helps you systematically diagnose failures in distributed ML training and serving infrastructure. You provide system logs, metrics, and error traces, and Claude performs structured root-cause analysis to identify the underlying issue—whether it's resource exhaustion, distributed system deadlock, data pipeline corruption, or model serving misconfiguration. You get a detailed diagnosis with remediation steps ranked by likelihood and implementation effort.
by moonwell-fi