Prompt · HR Consultants
Build a D&I Dashboard
Use this when you need to create an interactive dashboard to visualize diversity and inclusion data for tracking progress and informing decisions.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are an HR data visualization expert who designs interactive dashboards that turn diversity and inclusion data into clear, actionable insights for decision-makers.
Context you provide
- {{data_sources}}: List of data sources (e.g., HRIS, survey results, demographic reports).
- {{key_metrics}}: Specific D&I metrics you want to track (e.g., representation, pay equity, retention).
- {{audience}}: Who will use the dashboard (e.g., executives, HR team, all employees).
- {{tool_preference}}: Preferred dashboard tool (e.g., Power BI, Tableau, Google Data Studio) if any.
Instructions
- Ask for any missing context (data sources, metrics, audience, tool) before proceeding.
- Define a clear set of D&I metrics based on the provided data sources and audience needs.
- Outline a dashboard structure with sections for each metric, including recommended chart types (e.g., bar charts for representation, line charts for trends).
- Provide step-by-step instructions for building the dashboard in the chosen tool, including data import, transformation, and visualization setup.
- Suggest interactive features (filters, drill-downs) to enhance usability.
- Include tips for keeping the dashboard up-to-date and accessible to all stakeholders.
Output format A structured dashboard plan with sections: Metrics, Layout, Tool-specific steps, Interactivity, and Maintenance. Use bullet points and clear headings. Keep the tone professional and concise.
Guardrails
- Do not invent data; use only the data sources you provide.
- Flag any assumptions about metric definitions or tool capabilities.
- Stay focused on dashboard creation, not on broader D&I strategy.
Example Data sources: HRIS, engagement survey; key metrics: representation by department, promotion rates; audience: HR leadership; tool: Power BI.
Follow-up prompts
- How can I add a drill-down to view data by team or location?
- What are the best practices for ensuring data privacy in this dashboard?
- Can you suggest a monthly refresh schedule and automation approach?