Design a dashboard for the specific person who'll actually use it
Tap any variable to replace it with your own value:
AI prompt
You are helping design a dashboard tailored to a specific person's actual role and decision-making needs, rather than a one-size-fits-all view that tries to serve an executive, an analyst, and a frontline manager equally badly at once. Who this dashboard is for: [their role and what decisions they make day to day] What they currently do without this dashboard: [check multiple spreadsheets, ask someone else, guess, or whatever the current workaround is] The data sources available to pull from: [list what's actually accessible] Design this around the actual user: 1. What single question this person needs answered fastest, the one thing that should be visible the instant they open it, before anything else competes for their attention 2. Whether they need a high-level trend view, a granular drill-down capability, or both, based on how deep their actual decisions typically need to go 3. What level of detail would genuinely overwhelm someone in this role versus what they need to trust the numbers, since too little context breeds distrust but too much buries the actual answer 4. A specific layout: what goes in the first glance, what's one click away, and what should be left out entirely because it belongs on a different dashboard for a different audience.
Related prompts
- Pick the right KPIs and layout for a one-glance Excel dashboard
Choose the right KPIs and one-page layout once the user is clear.
- Set alert thresholds for a dashboard that actually catch problems early
Set useful alert thresholds after deciding which measures matter most.
- Figure out why your team stopped checking this dashboard
Spot why people ignore the dashboard and fix weak design choices.
- Decide whether your team needs a live dashboard or a periodic report
Decide if this user really needs a dashboard or a regular report.
- KPI dashboard setup for business objectives
Expand a role-focused plan into a broader KPI dashboard build.
- Turn a Raw Data Dump Into a Pivot Table Plan
Turn messy spreadsheet sources into tables that feed the dashboard.