Equal Opportunity case tracking: making an invisible process measurable
The EO Director asked me to help improve her tracker. That's where it started. The more questions I asked, the clearer it became that the tracker wasn't the problem. Behind it was a process with no workflow, a part-time office, and data complete for only 18% of cases. This was my Air Force Green Belt project at the 113th Wing, 2025 into early 2026.
The problem
Our Equal Opportunity office handled formal and informal complaints for about 1,000 military personnel, almost half of them full time. The office was three people, a Director and two staff, all part time, working one weekend a month. Issues could come up any day.
There was no way to file between drill weekends. On drill weekend, people lined up for intake, filled out a multi-page paper form, and sat for an interview. Staff typed the form into a tracker by hand, whenever time allowed.
There was no end-to-end workflow, either from the national level or within the wing. Cases moved by email and lived in hard-copy files. After a staffing gap, a new EO Director had built a tracker in Excel from what she could pull out of email, and she came to me to make it better.
Baseline
A three-person, part-time office serving about 1,000 personnel, available one weekend a month
No way to file between drill weekends
Paper intake, re-typed by hand
Required tracking data complete for only 18% of cases
The oldest cases had the least data, and they were the ones past their required timelines
What was actually happening
The Director and I used the case worksheets and the regulations to define the milestone dates a case needs to be tracked end to end. Then we checked the tracker against that list. Only 18% of cases had the data needed.
The data wasn't missing because people didn't care. Every step was manual: a paper form, a later re-type, an email handoff. Each one was a chance for a date to fall through, and nothing flagged it when it did.
Where it broke
The biggest issue was that there was no workflow and no way to see one. Everything else followed from that. It broke in three places: intake, where there was no way to file between drills; data entry, where a paper form was re-typed after the fact; and handoffs, where email gave no one a view of how long each stop took.
Before and after
Before: A member with a concern waited for drill weekend, stood in line, filled out a multi-page paper form, and sat for an interview. Staff typed the form into a tracker later, when they had time. Nobody could see where a case was or how long it had been there.
After: Any member, any day, can go to the EO SharePoint site and open the complaint form. They can take their time, read what each option means, and decide whether it's the right path for them. When they submit, they get an instant email explaining next steps, with a Bookings link to schedule their appointment.
EO staff do nothing until drill weekend. When they arrive, the tracker is already populated, appointments are already on their calendar, and each new submission has sent them a notification email. They can review a case and prepare before the interview starts.
Why it mattered
When someone experiences discrimination or something serious, waiting up to a month and then standing in line at an office can be enough to make them decide not to come forward. Hotlines existed, but they weren't well known or easy to find.
A form available any time gives people another path. They can file privately, at their own pace, when they're ready, even if they just need to get it on the record. Walk-in and paper options stayed available, so each person picks the path that fits. The process improvement made the work measurable. The access is what made it matter.
The change
We mapped the process with everyone who touched it: legal, the Inspector General, the EO Director, and EO staff.
Fix the data we had
Built a Power BI page listing every case and exactly which required fields were missing
Gave staff a specific list instead of a vague task: this case, this date, this file
Staff pulled the missing dates from the hard-copy files, and the EO Director owned the fix for her team
Completeness went from 18% to 100% in under a month
Fix how new data comes in
Replaced the Excel tracker with a SharePoint list as the system of record
Built Microsoft Forms versions of the paper forms so people could file any day. The paper forms stayed, because the point was more options, not fewer.
Set up Power Automate to send each submitter a confirmation, the next step, and a Bookings link
Set clear expectations that cases are worked on drill weekends
Make it visible
Built Power BI views so senior leadership could see every stop a case passed through, plus aggregated trends by organization and rank
Wrote a new SOP so the process didn't depend on one person
What the data showed
Once every case was tracked, two bottlenecks showed up that nobody could see before.
Administrative work during drill weekend pulled EO staff away from casework. With only a few days a month, every hour spent on intake lines, paper forms, and re-typing was an hour not spent on cases.
Investigators weren't getting trained in time, so cases waited for a qualified investigator. We built a Power BI page to track investigator training so leadership could act before it delayed a case.
Result
Required tracking-field completeness: 18% to 100% in under a month
Filing available any day of the month, with paper and walk-in options kept
Intake, confirmations, and scheduling moved off drill weekend, returning that time to casework
Every digital submitter gets a confirmation, a next step, and a way to book an appointment
End-to-end case tracking and DoD-required time-at-each-stop measurement made possible
Investigator training delays identified as a bottleneck and now tracked
Completeness here means the required milestone dates and key fields, not overall case quality.
What I learned
The request is rarely the whole problem. The Director asked for a better tracker. What she needed was a workflow, and a tracker would only help once the process and the data behind it were sound. Don't jump straight to a solution. A dashboard built on 18% of the data would have looked finished and found nothing. Both bottlenecks only showed up once the data was complete.
Method
Define what "complete" means using the source requirements, measure against it, make the gaps specific enough to close, then fix the input so they stay closed. In EASIER terms: Ask what happens now, Spot where it breaks, Improve the way, then Review what changed. See all six process guides.
Related free tools
The Process Improvement Toolkit includes SIPOC and value stream mapping templates for tracing how work actually flows. No email required.
