Read-only audit

People Analytics · Human resources · sample

AI

This is a finished audit of a synthetic model.

Run the same static audit on your own PBIP in seconds, without an account.

Audit your model
67/ 100

Not ready for production

507085

This model has critical data modeling and DAX flaws that produce incorrect attrition, age, and seniority metrics. The `Leavers` table is not connected to the calendar, making all attrition rates wrong. Key metrics like age are calculated based on the refresh date, not the historical period being analyzed, which is fundamentally misleading. Furthermore, data sources use hardcoded local paths, blocking deployment to the Power BI Service. The first priority is to fix the data model by creating a relationship between the `Leavers` and `Calendar` tables to correct the broken attrition calculations.

42 findings · 11 critical · 7 verified fixes · 4 hygiene notes, not counted in the score

Tables

7

Measures

15

Relationships

5

Pages

–

no report layer

Critical

11

AI findings

14

7 fixes

Fix these first

Ordered by severity, confidence and how many visuals depend on the object.

By area

Sub-scores out of 100; click to filter.

Verified fixes

Rewrites checked against your model and reviewed for semantic equivalence.

The model

Shape, sources and the report layer.

Shape

Fact tables1
Dimensions4
Helper / parameter2
Relationships1 critical5
Bidirectional1
Date table markedyes

Data sources

SQL Server4
Power Query2
Excel workbook1 local1

Report layer

Upload the PBIP with its .Report folder to get lineage, unused measures and page findings.

363 static checks · 32 firedAI review: 14 findings, 7 rewrites verified · $0.72Engine semantic-pargemini-2.5-pro+gemini-2.5-pro9/22/2026, 2:02:39 PM

Nothing from this audit is stored. How your data is handled