AI readiness assessment
An AI readiness assessment tells you whether your data can answer your team's questions through AI before anything is built. You get five checks, each ending in a pass or a named fix, and ten of your team's own questions tested by hand, so you know what an AI could answer today.
Readiness assessment, example
3 of 5 checks passed, and 4 of 10 questions could be answered today
The five checks
-
Metric definitions
Fix, priority 1
14 metrics appear in last quarter's reports. 6 are written down with a formula and an owner.
-
Data model
Pass
Orders, customers, products and sessions modelled at one row each, with tests on every key.
-
Access and permissions
Fix, priority 2
Warehouse roles grant whole schemas. Ad spend and margin sit in the finance schema beside payroll.
-
Freshness
Pass
Load log for 20 working days: all 12 reporting tables landed by 07:00 every day.
-
The questions people ask
Pass
62 questions from last quarter's ticket queue and analytics inbox, sorted into 18 kinds.
The two fixes, in order
1. Write the 8 missing definitions, starting with net revenue, new customer and repeat purchase rate. Unblocks 3 test questions.
2. Give the AI's account read-only views of ad spend and margin, outside the payroll schema. Unblocks 1 test question.
Ten test questions, run by hand
-
1
How many orders did we take last week?
Answered. Orders table, definition written
-
2
What was net revenue by channel last month?
Not answered. Net revenue has two versions in reports, neither written down
-
3
Which products had the most returns in October?
Answered. Returns joined to products, definition written
-
4
How many new customers came from paid social last month?
Not answered. "New customer" not defined
-
5
How many sessions came from email last week?
Answered. Sessions table, definition written
-
6
What was gross margin by category in October?
Not answered. Margin sits in the finance schema, no read-only grant possible today
-
7
Which customers haven't ordered in 90 days?
Answered. Customers table, last order date tested
-
8
What is our repeat purchase rate?
Not answered. No agreed time window, so no definition
-
9
Why do customers send items back?
Not answered. Return reason isn't captured anywhere
-
10
What does a new customer cost us, by channel?
Not answered. Ad spend sits in the finance schema
Answered 4. Not answered 6: no definition 3, access 2, not collected 1.
Answered means worked out by hand from one modelled table and a written definition.What this fixes
What you get from an AI readiness assessment
How the assessment runs, before any AI implementation
- 1
Collect
Last quarter's questions from the ticket queue and analytics inbox are sorted by kind, and the ten chosen cover the commonest kinds.
- 2
Check
The checks test definitions against your reports, the model against the warehouse, access against role grants, freshness against load logs, and the fifth, a real question, against the question list.
- 3
Test by hand
Each of the ten gets an answer in SQL against the modelled tables, using only written definitions, or the reason it couldn't.
- 4
Handover
The checks, the question log, the draft access map and the fix list go into your drive. If you go ahead, the AI-led analytics build starts from the fix list.
How an AI strategy fails before the build
The assessment installs nothing and no AI touches your data, because the ten test questions are answered by hand.
Readiness by industry, and a worked example
To see a question once all five checks pass, try the AI-led analytics demo. It runs three scripted questions on invented data and shows the query behind each answer.
Questions about the assessment
Do we need an AI strategy consultant before this?
Only if nobody can yet name the questions the AI should answer. The assessment starts from the questions your team already asks, and if there aren't any yet, collecting them comes before the five checks.
What does the assessment need from us?
It needs read access to the warehouse, its load logs and your current reports, plus last quarter's analytics questions and one person who can say what each metric is meant to mean.
What happens if every check fails?
You get five named fixes in order, each tied to the test questions it would unblock. In the example the first, writing down the 8 missing definitions, needs no new software and unblocks 3 of the 10 test questions on its own.
Can an AI implementation consultant skip the assessment?
They can, but then the checks happen during the build, after a wrong figure has reached someone. An AI build needs all five: a written definition, a modelled table, a read-only grant, a fresh load and a real question.
Is our data too messy for AI reporting?
The test questions answer that for your data. A question passes when one modelled table and one written definition give the answer by hand. If four of ten pass, those four can go live first, and the fix list says what the other six need.
Has someone promised the board an AI pilot?
We take ten of last quarter's questions on the call and say which checks could sink them and how long the assessment needs.