← Friction Map

Pattern identified

Manual Data & Reporting

247 people are describing variations of the same underlying friction.

247
Related signals
11
Departments
1,900
Est. hours / month
7
Systems involved
HIGH
Cross-department relevance

What people are experiencing

Every month we export information from two systems and manually combine it.
Program Operations
We receive a spreadsheet from another department and somebody has to clean it before we can use it.
Finance
County partners send information in different formats, so we manually standardize it.
Data Services
Leadership asks for the same metrics every month, but we rebuild the report each time.
Administration
The system contains the data, but getting it into a useful format takes hours.
Local Government Partner

24 submissions in this prototype dataset describe this pattern.

What connects these?

AI has identified recurring characteristics across these submissions. People decide which of them matter.

Repeated extraction
Information is repeatedly exported from existing systems.
Manual reconciliation
Employees compare, clean, or combine information by hand.
Recurring outputs
Much of the work produces reports that are recreated repeatedly.
System boundaries
The underlying systems cannot easily be replaced or integrated.
Cross-department dependency
Information frequently crosses organizational boundaries.

Accept the constraint. Find the possibility.

Can't change — right now

  • Existing statewide platforms
  • Current vendor contracts
  • Reporting obligations
  • Security requirements
  • Current staffing levels

Can change

  • How information moves between systems
  • How repetitive work is performed
  • How reports are generated
  • How exceptions are surfaced
  • How teams share information
Find opportunities

Illustrative demonstration data