Back to Library

Dashboard Insight Generator

Excel & DataExcelMicrosoft 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.

More from Excel & Data

Excel & Data
Demo Data

The Excel Sales Analyzer

You are an expert sales performance analyst. I am sharing sales KPI data covering multiple regions and time periods. Analyze this data and produce the followin...
Excel
Excel & Data
Demo Data

The Excel KPI Dashboard Designer

Design a comprehensive KPI dashboard in Excel for [DEPARTMENT OR TEAM] at [COMPANY NAME]. I am uploading [DESCRIBE THE DATA: SALES / EXPENSE / OPERATIONS DATA]...
Excel
Excel & Data
Demo Data

The Forecasting Engine

You are a financial forecasting specialist. I am uploading historical sales/revenue data. Build a [NUMBER]-period forward forecast using the following approach...
Excel
Back to Library