kwp-data-validate-data

Validate analytical reports and SQL queries for methodological soundness and calculation accuracy.

7|5|Updated May 7, 2026
One-click install
npx skills add https://github.com/14790897/MiQi --skill kwp-data-validate-data
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kwp-data-validate-data
Source: https://github.com/14790897/MiQi/tree/main/miqi/skills/kwp/data/validate-data
Command: npx skills add https://github.com/14790897/MiQi --skill kwp-data-validate-data

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the risk of sharing flawed data analysis by providing a rigorous, systematic framework for verifying methodology, calculations, and logical consistency before stakeholder presentations.

Core Features & Use Cases

  • Pre-Delivery QA Checklist: A comprehensive set of checks covering data quality, calculation logic, and presentation standards.
  • Analytical Pitfall Detection: Identifies common errors like join explosions, survivorship bias, and Simpson's paradox.
  • Confidence Assessment: Provides a structured rating system to determine if an analysis is ready for distribution or requires further revision.

Quick Start

Use the kwp-data-validate-data skill to review the attached quarterly revenue report for potential methodological errors and calculation accuracy.

Frequently Asked Questions about kwp-data-validate-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate SQL queries for calculation accuracy before stakeholder delivery?

To validate SQL queries before delivery, apply a systematic framework checking methodological soundness, join explosions, and logical consistency. This sanity checking process identifies analytical pitfalls and provides a structured confidence rating for your reporting.

What is the best way to check business intelligence reports for methodological errors?

Checking business intelligence reports for methodological errors involves applying a pre-delivery QA checklist covering data quality and calculation logic. This process detects cognitive biases like survivorship bias and Simpson's paradox, ensuring high-confidence output before distribution.

How do I detect analytical pitfalls like Simpson's paradox in my data analysis?

Detecting analytical pitfalls like Simpson's paradox requires a structured pitfall identification process that reviews calculation logic and data groupings. This systematic validation exposes logical inconsistencies and cognitive biases, determining if your analysis requires further revision.

Can I use automated data validation for business intelligence workflows without external dependencies?

Yes, you can use automated data validation for business intelligence workflows without external dependencies. The validation framework operates independently to assess data quality and calculation accuracy, providing standardized documentation and a confidence rating for your analytical findings.

When do I need a confidence assessment for my data science reporting?

You need a confidence assessment for data science reporting when sharing analytical findings with stakeholders. This structured rating system evaluates methodological soundness and calculation accuracy, determining if your output is ready for distribution or requires further revision.

Why does my data validation process miss survivorship bias in analytical findings?

Your data validation process misses survivorship bias because it lacks a rigorous analytical pitfall detection mechanism. Implementing a standardized sanity checking framework systematically identifies cognitive biases and methodological errors, ensuring high-confidence output before presentation.