Find out what data you actually have
List every system that holds your data, who owns it, and how data can get out of it, including the spreadsheets your office quietly runs on.
- How long
- 3 to 4 weeks
- Who owns it
- Your analyst, with IT and your software vendor contact
What you get
A clear picture of what you can measure now, what you cannot, and what it would take to change that.
Do this first
Ask each unit one question: what spreadsheet do you actually use to run your week? The answers will surprise you, and every one of them is a finding.
You cannot measure something you cannot get at. This phase tells you what exists, who controls it, and how to get it out on a schedule.
Keep it focused. Covering every system in the agency takes a year. Covering the systems behind your first five measures takes a month.
Why agencies get stuck here
Agencies check the case management system, call it done, and miss both the spreadsheets that really run the office and the contract clause that makes data exports a paid change order.
What to do
- 1
List the systems
Work from a list, not from memory. Courts: case management, e-filing, calendaring, jury, payments, documents, reminders, interpreters. Law enforcement: records management, dispatch, jail, evidence, body cameras, citations, crash reports. Both need payroll for staff counts and finance for budget figures.
- 2
For each one, record how data gets out
This single question decides your timeline more than anything else. Best to worst: a direct connection your software can use automatically, a read of the database, a scheduled file drop, a report the vendor sends, someone exporting by hand, or screen access only.
- Name a person who owns each system, not a department.
- Note what it holds, and what it is the authoritative source for.
- Note how fresh the data can actually be, not how fresh the sales material claims.
- 3
Read your vendor contract now
Many contracts charge separately for data exports, forbid direct database access, or require a change order with its own procurement timeline. Finding this in month four adds months to your schedule. Finding it in week three makes it a budget line. Get the answer in writing.
- 4
Find the spreadsheets
You will find backlog trackers, warrant lists, hearing calendars, and grant workbooks that are the real record for something. Each one is either a gap in your official system or a measure someone already needs badly enough to maintain by hand. Usually both.
- 5
Find where records are created, including other agencies’ forms
For each kind of record, find the moment it is first created and who creates it: the citation written at the roadside, the booking sheet at the jail, the filing at your counter. Some belong to another agency entirely, which is exactly why nobody has looked at them. This decides what data can ever exist later.
- Get the actual form, paper and electronic, for every one outside your agency.
- Check specifically whether contact details are asked for, typed in, and passed through.
- 6
Get a real export before you design anything
Not a description of the data. An actual twelve-month export of your main records. Documents describe what a system was designed to hold. Exports show what it actually holds, which is a different and far more useful thing.
- 7
Count your codes
Pull the list of values actually in use for case type, hearing type, and outcome, and count them. An agency that believes it has thirty case types and finds two hundred has just learned why its reports have never reconciled.
Decide these before you move on
- Where two systems hold the same thing, which one is authoritative?
- Is your software vendor a partner or an obstacle on data access, and who owns that relationship?
What you will have
- System list with owners and how data gets out of each
- The forms where records are first created
- List of code values actually in use
- A real twelve-month export
- Your contract’s export terms, in writing
You are done when
- Every system is listed with a named owner and a specific way to get data out.
- One authoritative source is named for each kind of record.
- You have a real export in hand and have opened it.
- You know in writing whether your contract allows exports, and what they cost.
What goes wrong
Checking the main system and stopping
The spreadsheets hold the measures people actually manage by. Miss them and your first dashboard will contradict what the unit already believes.
Accepting "we can run a report" as an answer
A report someone runs by hand is not a data feed. It gets skipped during a vacancy or a busy month. Write it down honestly as manual and plan to replace it.
Trying to inventory everything
Cover what your first five measures need, then stop. A complete inventory competes with the work instead of enabling it.