Verified numbers

Data quality checks after every build, reconciliation against the source before publishing, the data health page and how DataxLand hides a metric when the numbers make no sense.

Checks after every build

Every build runs a set of data checks: unique keys, no empty values, relationships between tables, valid values. Each check has a level of Blocking or Warning:

  • Warning: the dashboard is still published; the failing rows are recorded so you can fix them at the source.
  • Blocking: the build is not published. Dashboards keep showing the previous published version (if there is one).

A failing test does not break the build: results are stored per test, together with the source rows that failed.

The data health page

Many packs include a Data health page in the Data and connections group. The Data quality checks tile shows the total number of checks, how many failed and how many of those are blocking; each check reads Passed, Failed or Couldn't run.

Reconciliation before publishing

Before the Publish step, DataxLand compares a few key totals (order count, gross revenue) between the loaded data and the built warehouse. If they differ, the build stops and nothing wrong gets published; the progress view shows which step failed.

Hidden when the numbers make no sense

When the data produces an impossible number, for example general-ledger debits and credits that do not balance, the affected metric is hidden for now with a reason ("Can't be calculated yet: …") instead of showing a wrong figure. In the Approve and build step, the Metrics not available yet section lists these metrics; they do not affect any other metric.

Build warehouse and published warehouse

A build writes to its own warehouse for that run; dashboards, Si and MCP only read the published warehouse. You never see numbers from a build that is still running.

"Incomplete" tiles

On a dashboard, a tile is labelled Incomplete when the data coverage of its metric is below 100%; hover over the label to see the percentage. That number may be off from reality. The Data as of line shows the latest date with data. A tile shows Filters not applied when a page filter does not fit that metric.

Markdown