Weighted Data Health Score
Computes a 0-100 score from completeness, freshness, uniqueness, and validity using intent-driven Power BI field buckets.
A clear signal for the health of the data behind the report.
A Power BI custom visual that evaluates whether data can be trusted by showing a weighted 0-100 health score, four quality KPI tiles, and a plain-English diagnostic issue list.
Features
Computes a 0-100 score from completeness, freshness, uniqueness, and validity using intent-driven Power BI field buckets.
Measures the average percent of non-blank values across fields selected for completeness.
Compares the latest selected date against fresh and stale hour thresholds.
Calculates distinct-value rates and flags duplicate identifier values, with row limits for distinct-count performance.
Checks category fields for blanks, low-frequency categories, and high fragmentation.
Ranks diagnostic messages by severity and links issues to the related quality dimension.
Included Capabilities
Field buckets
Score formula: 0.4 * Completeness + 0.25 * Freshness + 0.2 * Uniqueness + 0.15 * Validity
Purpose-built inputs for quality checks.
Fields where blanks or nulls reduce the completeness score.
Identifier fields where repeated values reduce the uniqueness score.
A date field used to evaluate how old the dataset is.
Category fields checked for blanks, low-frequency values, and fragmentation.
Use cases
Get the visual