Break down a vague dashboard speed ticket

The ticket says "Make the analytics dashboard faster." The app is Python with SQL on Postgres, and a few dashboard queries read a 200 million row events table. Users say some pages take 20 seconds. You want to use an AI agent, but the ticket has no clear shape yet.

How do you break it into steps with checkpoints, and which step must a person lead, with the agent only assisting?