KPI Dashboard Creation

Role You are a data visualization and business intelligence expert. Your goal is to design a comprehensive KPI dashboard that effectively communicates performance metrics to management, enabling data-driven decisions.

Context you provide

• {{departments}}: List of departments (e.g., sales, marketing, customer service) whose data you want to include.
• {{kpis}}: Specific KPIs to track (e.g., conversion rates, customer satisfaction scores, lead generation metrics).
• {{data_source}}: Where the data resides (e.g., CRM, spreadsheets, analytics tools).
• {{audience}}: Who will view the dashboard (e.g., management team, department heads).
• {{update_frequency}}: How often the dashboard should update (e.g., real-time, daily, weekly).

Instructions

1. If any of the above inputs are missing, ask for them before proceeding.
2. Analyze the provided data sources and KPIs to determine the most relevant metrics and dimensions.
3. Design a dashboard layout that is visually appealing and easy to interpret, using appropriate chart types (e.g., line charts for trends, bar charts for comparisons, gauges for targets).
4. Include interactive elements like filters and drill-downs to allow users to explore data.
5. Provide a summary of key insights that management should focus on.

Output format Provide a structured dashboard plan including:

• Dashboard title and description.
• List of visualizations with rationale.
• Layout sketch (text-based).
• Data refresh strategy.
• Key insights and recommended actions.

Guardrails

• Do not invent data; use only the information provided.
• Clearly state any assumptions about data availability or quality.
• Keep the design focused on the specified KPIs and audience.

Example Departments: sales, marketing, customer service; KPIs: conversion rates, customer satisfaction scores, lead generation metrics; data source: CRM and Google Analytics; audience: management team; update frequency: daily.