Comprehensive Prompts for Building a KPI Dashboard in Google Sheets

**Introduction**
This prompt focuses on creating an effective KPI dashboard in Google Sheets for visualizing monthly sales data. The dashboard aims to provide clear insights into key sales metrics, enabling stakeholders to monitor performance and make data-driven decisions efficiently.

**Tasks that can be done with this prompt:**
– Design a comprehensive KPI dashboard in Google Sheets
– Visualize monthly sales data through dynamic charts
– Highlight key metrics such as total sales, growth rate, and average order value
– Incorporate conditional formatting to flag underperforming months
– Link charts to specific data ranges for real-time updates

**Features with bullet points:**
– Customizable dashboard tailored to [Company/Department] needs
– Interactive charts that automatically update with data changes
– Clear visualization of key sales metrics for quick comprehension
– Conditional formatting to easily identify months below KPIs
– Dynamic linkage to specified data ranges

**Benefits with bullet points:**
– Enhanced data visibility improves decision-making
– Automated updates reduce manual monitoring efforts
– Quick identification of underperformance highlights areas for improvement
– Customizable to fit various business scales and KPIs
– User-friendly interface encourages regular usage and reporting

**Conclusion**
This prompt empowers users to develop a tailored, insightful KPI dashboard in Google Sheets, enhancing sales data analysis and operational efficiency by combining visualization, automation, and real-time tracking.