Data Analysis AI prompts

Best for

Produce a reconciliation table and validation query plan from the supplied inputs.

Best for

Produce a data-quality report with check formulas or pseudocode from the supplied inputs.

Best for

Produce a plain-English experiment readout and decision options from the supplied inputs.

Best for

Create an interactive financial panel in Excel that consolidates revenue, expenses, and contribution margin data with automatic updates via pivot tables.

Best for

Build an ETL (extract, transform, load) workflow in Excel Power Query to clean, standardize, and consolidate datasets affected by common real-world corporate data problems.

Best for

Develop an Excel or Google Sheets inventory control system that classifies products using the ABC curve, calculates reorder points, and generates automatic visual alerts.

Best for

Create a set of VBA macros that automate data consolidation from multiple sheets, generate standardized charts, and export reports as PDF for executive distribution.

Best for

Build a financial projection model in Google Sheets that allows simulation of 3 different scenarios, with adjustable assumptions and sensitivity analysis for decision-making.

Best for

Create a set of reusable SQL queries that analyze sales by period, product, seller, and region using CTEs (Common Table Expressions) and window functions for rankings and comparisons.

Best for

Create a complete relational model for a recurring subscription system, including tables, indexes, constraints, and ready-to-use queries for calculating MRR, churn, and LTV.

Best for

Learn to identify SQL query performance bottlenecks using EXPLAIN ANALYZE, create efficient indexes, and rewrite queries to reduce response time.

Best for

Develop SQL stored procedures that calculate sales commissions considering tiered quotas, product mix bonuses, cancellation clawbacks, and team splits.

Best for

Build conversion funnel analysis queries in BigQuery (Google Analytics 4 export) to identify drop-off points, optimize conversion rates, and attribute revenue to acquisition channels.

Best for

Create a quick-reference guide to help analysts choose the right chart (among 20+ types) based on analysis objective, number of variables, and target audience.

Best for

Create the functional and technical specification for a Power BI dashboard for the commercial/sales department, including Star Schema data model, advanced DAX measures, and visual interactions.

Best for

Build a digital marketing report in Looker Studio (formerly Data Studio) that combines data from multiple Google sources, with automatic updates and stakeholder sharing.

Best for

Complete “Data Storytelling: Narrative Structure for Impactful Presentations” with an analysis or query/formula plan with definitions, checks, findings, limitations and decision implications that can be checked against the supplied evidence.

Best for

Implement an operational dashboard in Metabase (open source) that monitors KPIs in real time, sends automated alerts when metrics exceed thresholds, and enables self-service exploration for the team.

Best for

Create a hierarchical KPI framework for e-commerce that links business metrics (revenue, margin) to operational metrics (conversion, AOV, CAC), with targets grounded in industry benchmarks.

Best for

Build a complete OKR system (Objectives and Key Results) covering definition, cascading, weekly tracking, and quarterly scoring, with BI integration for automated progress monitoring.

Best for

Create a simplified, actionable Balanced Scorecard for SMBs with specific metrics for each perspective (financial, customers, processes, learning) suited to your tax and operational context.

Best for

Create a complete SaaS metrics hierarchy that differentiates leading indicators (which predict the future) from lagging indicators (which confirm the past), enabling intervention before results worsen.

Best for

Create a logistics metrics system covering the full supply chain (receiving, storage, picking, packing, shipping, transportation, last mile) with measurable SLAs and exception management.

Best for

Create a monthly executive report template that presents results clearly for leadership, with variance analysis, root causes, and recommendations prioritized by impact.

Best for

Build a Python script that automates the entire report generation pipeline: data extraction from a database, processing with Pandas, chart creation, export to PDF/Excel, and automatic email delivery.

Best for

Develop a detailed cohort analysis that reveals behavioral patterns over time, identifies the critical churn window, and quantifies the financial impact of retention.

Best for

Create a variance analysis framework that breaks down differences between budgeted and actual results into their components (price effect, volume effect, mix effect, exchange rate effect) to enable precise corrective action.

Best for

Write the analytical narrative for the annual report, turning tables and charts into a story that connects past results with future strategic direction, in language appropriate for diverse stakeholders.

Best for

Complete “Advanced Financial Analysis DAX Formulas in Power BI” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.

Best for

Complete “Predictive Analysis with Python: Regression and Demand Forecasting” with an evidence table with finding, source, limitation, impact hypothesis, action and validation that can be checked against the supplied evidence.