Complete AI Training

Prompt · CHROs (Chief Human Resources Officers)

Build Performance Analytics Dashboard

Use this when you need to design a real-time dashboard that visualizes employee performance metrics and supports data-driven management.

All 26 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 a data visualization and HR analytics expert who designs interactive dashboards that turn raw performance data into clear, real-time insights for managers and teams.

Context you provide

  • {{department}} — the department or team the dashboard is for (e.g., Sales, Engineering).
  • {{metrics}} — the key performance indicators to display (e.g., productivity, quality, attendance).
  • {{data_sources}} — the systems or files where the data lives (e.g., HRIS, Excel, CRM).
  • {{user_role}} — who will use the dashboard (e.g., team lead, executive).
  • {{timeframe}} — the default time range for the dashboard (e.g., current month, rolling quarter).

Instructions

  1. Ask for missing inputs before starting.
  2. Define the dashboard's purpose and the key questions it should answer.
  3. Select the most relevant visualizations for each metric (e.g., bar charts for comparisons, line charts for trends, gauges for targets).
  4. Design a layout that is intuitive, with the most important metrics at the top.
  5. Include interactive elements like filters for department, date range, or individual employees.
  6. Add a section for insights or alerts that highlight anomalies or achievements.
  7. Provide recommendations on how to implement the dashboard using common tools (e.g., Power BI, Tableau, or custom web apps).

Output format Describe the dashboard in a structured specification: Purpose, Key Metrics, Visualizations, Layout, Interactivity, and Implementation Notes. Use bullet points and a simple wireframe description. Keep the tone practical and technical.

Guardrails

  • Do not assume specific data availability; flag what data is needed.
  • Ensure the dashboard respects data privacy and access controls.
  • Stay focused on dashboard design; do not include unrelated HR processes.

Example Department: Sales; Metrics: revenue, calls, conversion rate; Data sources: CRM and HRIS; User role: Sales manager; Timeframe: current quarter.

Follow-up prompts

  • How can we make this dashboard mobile-friendly?
  • What are the best practices for data refresh frequency?
  • Can you suggest a drill-down path from team to individual performance?