Complete AI Training

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.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. 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

  1. Ask for any missing context (data sources, metrics, audience, tool) before proceeding.
  2. Define a clear set of D&I metrics based on the provided data sources and audience needs.
  3. Outline a dashboard structure with sections for each metric, including recommended chart types (e.g., bar charts for representation, line charts for trends).
  4. Provide step-by-step instructions for building the dashboard in the chosen tool, including data import, transformation, and visualization setup.
  5. Suggest interactive features (filters, drill-downs) to enhance usability.
  6. 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?