📊 Data & Analytics Prompts
Data analysis, SQL queries, Excel formulas, and dashboards
25 prompts
Write a SQL query to analyze
Write a SQL query that {requirement}.
Create an Excel formula to
Write an Excel/Google Sheets formula that {requirement}.
Build a Looker Studio dashboard for
Design a dashboard specification for tracking {metrics}.
Analyze this dataset and find insights:
Given this dataset description: {dataset}, perform exploratory data analysis.
Write a Python data analysis script using pandas to
Write a Python script using pandas to {task}.
Create an A/B test analysis plan for
Design an A/B test plan for {experiment}.
Write a data quality checklist for
Create a data quality assessment checklist for {dataset}.
Build a cohort analysis framework for
Define a cohort analysis approach for {business}.
Write a forecasting model description for
Describe how to build a forecasting model for {metric}.
Create KPI definitions for
Define 10 key performance indicators for {team}.
Write a Google Analytics 4 exploration report for
Create a GA4 exploration analysis plan for {question}.
Design a customer segmentation model for
Propose a customer segmentation strategy for {business}.
Write a data storytelling script for presenting
Create a data storytelling narrative for presenting findings about {topic}.
Create a data pipeline architecture for
Design a data pipeline architecture for {use-case}.
Write a data dictionary template entry for
Create a data dictionary entry for {field}.
Build a churn prediction model description for
Describe how to build a churn prediction model for {business}.
Write a customer lifetime value calculation for
Explain how to calculate Customer Lifetime Value (LTV) for {business}.
Create a weekly business metrics report template for
Design a weekly metrics report template for {business}.
Write a regression analysis interpretation for
Explain how to interpret regression analysis results for {business-question}.
Design an attribution model for
Propose a marketing attribution model for {business}.
Write a Python script to clean data by
Write a Python script that cleans a dataset by {requirement}.
Create a Tableau dashboard design spec for
Spec out a Tableau dashboard for {use-case}.
Write a machine learning model evaluation framework for
Define how to evaluate a machine learning model for {use-case}.
Create a data ethics checklist for
Create a data ethics assessment for using data in {project}.
Write a Google Sheets query to
Write a QUERY() function for Google Sheets that {requirement}.