isonewStart the Diagnostic

    isonew

    Find the workflow worth automating

    A scored diagnostic of one named workflow — data, owner, refusal path — before you buy.

    Opportunity diagnostic
    AI for Small Business1 min readUpdated

    Written by Founder & GTM Engineer

    Reporting disputes are definition disputes

    Direct answer

    When two departments quote different revenue, the conversation turns into a debate about the data warehouse. In our experience the warehouse is usually fine. The definitions are not. Before anyone builds a dashboard, agree in writing on what counts as a closed month, when a refund reverses a sale, and which currency conversion date applies. Most of the disagreement disappears on that page.

    Two open ledger books side by side on a desk, each with different column structures, a ruler placed precisely between them as a divider.
    Most reporting disputes are not about data accuracy — they are about which definition of the metric was used by each party.

    Why write the definitions down first?

    2 departments present two revenue numbers in the same meeting, and the conversation turns into a debate about the data warehouse. In our experience the warehouse is usually fine. The definitions are not.

    Before anyone builds a dashboard, agree in writing on what counts as a closed month, when a refund reverses a sale, and which currency conversion date applies. Most of the disagreement disappears on that page, before a single query is written. The same rule sits under AI workflow automation: do not automate a reporting ritual until the metric is owned. It is also how we treat measurement in the AI for Small Business playbook.

    What belongs on the definition page?

    • One written definition per metric, owned by a named person
    • The definition ships next to the dashboard, not in a separate document
    • Changing a definition is a dated change, not a silent edit

    Frequently asked questions

    Why do two teams report different revenue from the same systems?

    Usually because they are using different definitions — closed month, refunds, currency date — not because the warehouse is broken.

    What should be written down before a dashboard is built?

    What counts as a closed month, when a refund reverses a sale, and which currency conversion date applies. One owner per metric.

    Where should the definition live?

    Next to the dashboard, not in a separate document. A change to a definition is a dated change, not a silent edit.

    Sources

    1. Kimball Dimensional Modeling Techniques — Kimball Group
    2. Dimensional Modeling — further reading — Wikipedia

    If reporting is the workflow you want to automate first, start with the definitions, then read AI workflow automation for small business and the AI for Small Business hub.

    Continue reading

    Diagnostic