Section 1 of 5 Data foundation and pipelines
DA-A1 Reporting data is pulled from: Exports that people keep on their own machines Each source system separately, then joined in a spreadsheet A warehouse for some sources, exports for the rest One warehouse or lakehouse that all reporting reads from
DA-A2 Data moves from source systems into reporting: When someone remembers to run it On a manual schedule someone operates Automatically, with failures found the next morning Automatically, with alerting when a load fails
DA-A3 Data quality problems, such as duplicates, gaps or bad values, are found: By whoever is reading the report During month end, when things do not add up By periodic manual checks By automated checks that run with every load
DA-A4 History in your reporting data goes back: As far as the current system, older data was left behind in a migration A year or two, with gaps nobody has mapped Several years, with a known break in the middle Several years, consistent, with any breaks documented
Section 2 of 5 Definitions, ownership and trust
DA-B1 Two teams present the same KPI in the same meeting. The numbers match: We have stopped presenting the same metric twice Often not, and we spend the meeting reconciling Usually Always, there is one agreed definition
DA-B2 Your most quoted metric has a written definition: No, and people calculate it differently It lives in a query somebody wrote Written down, in a document people have to find Written down, with an owner, and shown beside the number
DA-B3 Who is allowed to see which data: Anyone with the link can open most of it Set per report, by whoever built it Managed by role, with some exceptions Managed by role, with sensitive fields restricted and logged
DA-B4 When a published number turns out to be wrong and gets corrected: Nobody is told, the report simply changes People notice and ask A note goes out to the people who saw it Versions are kept, with the reason for the change recorded
Section 4 of 5 Decisions and advanced analytics
DA-D1 The last significant decision made against the numbers rather than opinion was: We cannot think of one Over a year ago In the last quarter This month, and it is normal practice
DA-D2 When a customer or partner is about to leave, you find out: When the revenue stops When they tell us Early, from behavioral signals Before it happens, we model it
DA-D3 Forecasting for the next quarter is produced by: Last year plus a percentage Each team’s own judgment, added together A model, adjusted by the business A model, with accuracy reviewed against outcome each quarter
DA-D4 When you change pricing, a process or a campaign, the effect is: Never isolated, we look at the total afterwards Judged by whether the overall number moved Compared against the same period last year Compared against a control group or a holdout