Data Analysis AI prompts

Best for

Create a Google Sheets pricing model that factors in variable costs, fixed costs, competitor prices, and minimum margin thresholds to generate optimal pricing recommendations for each SKU.

Best for

Build an Excel-based HR dashboard that gives leadership real-time visibility into workforce metrics, identifies retention risk areas, and tracks diversity goals.

Best for

Create a multi-project tracking system that gives PMO visibility into budget consumption, resource utilization, and delivery risk across the entire project portfolio.

Best for

Build an RFM customer segmentation model in Excel that scores each customer on recency, frequency, and monetary value, then classifies them into segments with specific marketing strategies.

Best for

Write SQL queries that reconstruct user journey funnels from event-level data, calculate step-by-step conversion rates, and identify the highest-impact drop-off points for optimization.

Best for

Create a set of SQL monitoring queries that automatically detect data pipeline problems including missing data, schema changes, volume anomalies, and freshness issues.

Best for

Use geospatial SQL functions to calculate distances between stores, analyze customer catchment areas, detect revenue cannibalization, and recommend optimal new store locations.

Best for

Build SQL-based sessionization logic that groups raw events into meaningful sessions, reconstructs user paths, and calculates engagement metrics typically found in analytics platforms.

Best for

Create a one-page KPI dashboard design that follows information hierarchy principles, uses visual encoding effectively, and enables executives to understand business health in under 30 seconds.

Best for

Create waterfall visualizations that break down the difference between two financial states into contributing factors, enabling stakeholders to understand exactly what drove changes in revenue, margin, or profit.

Best for

Build geographic dashboards that visualize data by region, state, or city, enabling regional managers to compare performance and identify geographic opportunities or problems.

Best for

Create Sankey diagrams that show how customers flow through multiple stages or how revenue distributes across dimensions, revealing patterns that traditional charts miss.

Best for

Create a comprehensive unit economics framework that answers the fundamental question: does each customer generate more value than it costs to acquire and serve them?

Best for

Build a composite health score (0-100) that predicts customer churn risk, identifies expansion opportunities, and prioritizes Customer Success team efforts.

Best for

Guide product teams through a systematic process to identify the single metric that best captures the core value their product delivers to customers, ensuring alignment across engineering, product, and business teams.

Best for

Create an engineering metrics dashboard that measures delivery performance, code quality, and team health without incentivizing harmful behaviors like velocity inflation or quality shortcuts.

Best for

Create a repeatable WBR format that keeps leadership focused on the right metrics, drives accountability through action tracking, and enables rapid course correction.

Best for

Standardize A/B test result reporting to prevent misinterpretation of statistical noise, ensure proper sample sizes, and connect test results to business decisions.

Best for

Create a systematic competitive intelligence framework that updates regularly, tracks competitor movements, and informs product roadmap and go-to-market strategy.

Best for

Design a standardized quarterly board deck that tells a clear story about company performance, builds investor confidence, and facilitates strategic discussion rather than just reporting numbers.

Best for

Professional goal: Streamline the excel sheets strategy for better results

Best for

Professional goal: Optimize existing excel sheets workflow using AI tools

Best for

Professional goal: Create a comprehensive excel sheets approach for scale

Best for

Professional goal: Transform the excel sheets framework for efficiency

Best for

Professional goal: Enhance the excel sheets process with proven methods

Best for

Professional goal: Implement a systematic excel sheets workflow using AI tools

Best for

Professional goal: Create a comprehensive excel sheets workflow using AI tools

Best for

Professional goal: Create a comprehensive excel sheets process with proven methods

Best for

Professional goal: Build a scalable excel sheets framework for efficiency

Best for

Professional goal: Streamline the excel sheets strategy for better results