metric-reconciliation

Compare cross-source metrics and generate a reconciliation report.

351|70|Updated Jan 11, 2026
One-click install
npx skills add https://github.com/nimrodfisher/data-analytics-skills --skill metric-reconciliation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: metric-reconciliation
Source: https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/metric-reconciliation
Command: npx skills add https://github.com/nimrodfisher/data-analytics-skills --skill metric-reconciliation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Reconcile metrics across multiple data sources to expose discrepancies, align calculations, and provide actionable root-cause insights.

Core Features & Use Cases

  • Data loading and normalization across sources to a common schema.
  • Aggregation, comparison, and variance reporting at chosen time windows.
  • Root-cause analysis and auto-generated reconciliation reports for audits.

Quick Start

Define the two data sources, their metric definitions, and run the reconciliation workflow to generate a discrepancy report.

Frequently Asked Questions about metric-reconciliation

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

FAQPage Schema
How do I reconcile metrics across multiple data sources with different calculation methods?

Cross-source metric reconciliation normalizes data from multiple sources into a common schema, applies your metric definitions, and compares aggregated values across chosen time windows to identify calculation discrepancies and variances.

Why do my cross-source metric reports show discrepancies and how can I identify the root cause?

Cross-source metric discrepancies often stem from differing metric calculations, time windows, or data lag. Reconciliation workflows surface these variances and classify them as matches, minor, or significant based on your acceptable variance threshold.

What is metric reconciliation and when do I need it for data quality reporting?

Metric reconciliation is the validation of metrics across multiple data sources to expose discrepancies. It is needed for audits and data quality reporting when you require aligned calculations and actionable root-cause insights across systems.

Can I automate cross-source data reconciliation if my sources have different time windows and data lag?

Yes, automation handles data loading and normalization across sources with differing time windows and data lag. You define the metric calculations and acceptable variance threshold, and the workflow automatically generates a discrepancy report.

What do I need to define before running a cross-source metric reconciliation workflow?

You need to define two data sources, their specific metric calculations, and an acceptable variance threshold. You also need data access via connections or exports to classify matches, minor, or significant discrepancies.