Back to Library

Dashboard Insight Generator

Excel & DataExcel●●IntermediateMicrosoft CopilotMicrosoft 365ProductivityOfficeWork Users

Prompt

Create an executive dashboard from this data including: 1) Top 5 KPIs with current value, trend (↑↓), and vs. target, 2) Alert indicators for metrics off-track (red/yellow/green), 3) Summary of performance by category/region/product, 4) Key drivers of performance (what's working/not working), 5) Recommended focus areas for next period, 6) Visual layout optimized for at-a-glance understanding. Use conditional formatting and charts for easy interpretation.
Generate sample demo data

Generic sample context ready for adaptation.

Related Prompts

Excel & Data

Forecasting Model Builder

Build a forecasting model for [METRIC] based on this historical data. Include: 1) Trend analysis and seasonality detection, 2) Forecast for next [3/6/12] months...
Excel●●IntermediateWorkflow-ready
Excel & Data

Data Quality Auditor

Audit this dataset for quality issues: 1) Missing values (count and % by column), 2) Duplicates or inconsistencies, 3) Outliers that may be errors vs. legitimat...
Excel●BeginnerSkill-ready
Excel & Data

Data Storyteller

Analyze this dataset and tell the data story: 1) Key trends over time, 2) Notable outliers or anomalies with potential explanations, 3) Correlations or relation...
Excel●●IntermediateWorkflow-ready
Productivity & Automation

Escalation Radar Detector

Scan the last 45 days of emails and detect: 1) Rising tensions or conflict indicators, 2) Missed deadlines and their follow-ups, 3) Requests repeated multiple t...
Outlook●●IntermediateWorkflow-ready
Back to Library