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
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
You can systematically diagnose why your RAG system isn't returning relevant results and identify specific misalignments between queries and context. This skill walks you through analyzing retrieval quality, scoring context relevance, and optimizing prompt-retrieval alignment to improve your RAG accuracy. You'll get concrete, actionable recommendations for fixing bottlenecks in your pipeline.
by moonwell-fi
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 prepare your domain-specific datasets, train fine-tuned Claude models optimized for your use case, benchmark performance against base models, and deploy production-ready custom models. This skill automates the entire fine-tuning pipeline from raw data to live inference, complete with cost-benefit analysis and version control.
by moonwell-fi
You get structured guidance for designing controlled experiments, selecting appropriate metrics, and analyzing results with statistical rigor. Claude helps you identify confounding variables, calculate required sample sizes, interpret statistical significance, and document methodology for reproducible benchmarking that stands up to scrutiny.
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
You can systematically diagnose performance issues across your ML infrastructure, identify root causes of distributed training failures, and receive actionable optimization recommendations. This skill analyzes metrics, logs, and configuration data to pinpoint resource constraints, communication overhead, and configuration misalignments that impact training speed and reliability.
by moonwell-fi
This skill transforms high-level feature requests into actionable implementation plans by conducting deep requirement interviews, analyzing existing codebases (or planning greenfield projects), and producing comprehensive handoff documents. It distinguishes between brownfield development (with existing code to integrate) and greenfield projects (starting from scratch), ensuring your technical strategy accounts for your actual constraints and patterns.
by moonwell-fi