Create a comprehensive executive dashboard specification that translates business KPIs into actionable visual layouts with clear data hierarchies and drill-down paths.
## CONTEXT According to Gartner research, over 70% of executive dashboards fail to drive decision-making because they prioritize aesthetics over analytical utility, burying critical metrics under decorative charts and excessive detail. A McKinsey study found that executives spend an average of just 2.5 minutes reviewing a dashboard before deciding whether it is useful, meaning that information architecture and visual hierarchy are more important than the volume of data displayed. The most effective executive dashboards surface 5 to 8 key performance indicators with contextual benchmarks and enable one-click drill-downs into the underlying drivers. ## ROLE You are a senior business intelligence architect with 15 years of experience designing executive dashboards for Fortune 500 companies across finance, healthcare, retail, and technology sectors. You have led dashboard redesign projects that increased executive engagement with data by 300% and reduced the time from data insight to strategic action by 60%. Your approach combines information design principles from Edward Tufte with practical stakeholder management techniques that ensure dashboards are adopted, not abandoned. ## RESPONSE GUIDELINES - Design a dashboard specification that a development team can implement without ambiguity - Prioritize the information hierarchy so the most critical metrics are visible within the first 3 seconds of viewing - Include specific chart type recommendations with justifications for each metric - Define the interaction model including filters, drill-downs, and cross-filtering behaviors - Do NOT recommend more than 8 primary KPIs on a single dashboard view, as cognitive overload destroys executive adoption - Do NOT suggest pie charts for comparing more than 4 categories or for showing trends over time ## TASK CRITERIA 1. **Stakeholder Requirements Analysis** — Identify the key decision-makers for [INSERT BUSINESS UNIT OR DEPARTMENT], their primary questions, the decisions they make weekly and monthly, and the KPIs that directly map to those decisions. Create a requirements matrix linking each stakeholder role to their top 3 data needs. 2. **KPI Definition and Hierarchy** — Define each KPI with its exact calculation formula, data source, refresh frequency, target value, acceptable variance threshold, and the conditional formatting rules for red, amber, and green status indicators. Organize KPIs into a primary view and secondary drill-down levels. 3. **Layout and Visual Architecture** — Specify the dashboard layout using a grid system with exact positioning for each visual element. Define the header zone for filters and date range selectors, the hero zone for the top 3 KPIs with sparklines, the detail zone for supporting charts, and the action zone for alerts and annotations. 4. **Chart Type Selection** — For each metric recommend the optimal chart type from options including bullet charts for KPI-to-target comparison, sparklines for trend context, bar charts for categorical comparison, line charts for time series, and heat maps for matrix data. Justify each selection based on the data type and the analytical question being answered. 5. **Interactivity and Drill-Down Design** — Define the complete interaction model including global filters for date range and business segment, cross-filtering relationships between charts, drill-down paths from summary to detail, tooltip content specifications, and bookmark or saved view functionality for common analysis patterns. 6. **Data Refresh and Alert Configuration** — Specify the data refresh schedule for each data source, the alerting rules that trigger email or push notifications when KPIs breach thresholds, the data quality checks that must pass before the dashboard updates, and the audit trail requirements for data lineage transparency. ## INFORMATION ABOUT ME - My business unit or department: [INSERT BUSINESS UNIT — e.g., sales operations, product management, C-suite overview] - My current data sources: [INSERT DATA SOURCES — e.g., Salesforce, SAP, Google Analytics, internal data warehouse] - My dashboard platform: [INSERT PLATFORM — e.g., Tableau, Power BI, Looker, custom web application] - My audience and their technical comfort: [INSERT AUDIENCE — e.g., CEO and VP-level, comfortable with filters but not building queries] - My key business questions: [INSERT TOP 3-5 QUESTIONS — e.g., Are we hitting quarterly revenue targets? Which regions are underperforming?] ## RESPONSE FORMAT - Begin with a one-page executive brief summarizing the dashboard purpose and expected business impact - Include a wireframe description using a grid layout with named zones and pixel or percentage dimensions - Present each KPI in a specification card format with name, formula, source, chart type, and threshold rules - Provide the interaction flow as a decision tree showing drill-down paths - End with an implementation checklist organized by sprint priority - Include a stakeholder sign-off template for requirement validation
Or press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
[INSERT BUSINESS UNIT OR DEPARTMENT]