Data Analysis
User Feedback Categorizer
Act as a Product Analyst. I have a collection of raw, unstructured user feedback. Your task is to perform a thematic analysis. Read the feedback below...
'Kill, Keep, or Improve' Feature Analyst
Act as a data-driven Product Manager. I need to decide what to do with an underperforming feature in my product. - **Feature:** [Feature Name and bri...
North Star Metric Brainstormer
Act as a Growth Product Manager. I need to define a North Star Metric (NSM) for my product. - **Product:** [e.g., A B2B project management tool, a me...
A/B Test Hypothesis Generator
Act as a Conversion Rate Optimization (CRO) Specialist. I want to improve a key metric for my product. - **Page/Screen:** [e.g., The signup page, the...
HR Metrics Analysis Questions
Act as a senior HR data analyst. I am reviewing our latest HR dashboard and have the following data point: [Provide a specific data point, e.g., 'Our...
Output Format & Structure Specifier
For the following task, structure your entire response exclusively in the [Specify format, e.g., JSON, Markdown, HTML, XML] format. The output must co...
Summarize Trends from a Series of Notes
Analyze the following key points/action items from a series of [Number] meetings about '[Project/Topic Name]' held between [Start Date] and [End Date]...
Explain Complex Data Analysis Concepts
Explain the following data analysis / statistics / machine learning concept in simple terms, suitable for someone without a deep technical background:...
Calculate Descriptive Statistics
Provide the code ([Language/Tool, e.g., Python/Pandas, R, SQL]) or Excel function(s) to calculate the following descriptive statistics for the variabl...
Define Clear Analysis Goals
Help me define specific, measurable analytical goals based on this business problem/objective: '[Describe the general problem or objective, e.g., We w...
Suggest Data Cleaning Techniques
Suggest data cleaning techniques or generate code ([Specify Language/Tool, e.g., Python/Pandas, R, SQL]) for handling the following issue in my datase...
Generate Exploratory Data Analysis (EDA) Steps/Code
Generate starter code in [Language/Library, e.g., 'Python using Pandas, Matplotlib, and Seaborn', 'R using dplyr and ggplot2'] for performing basic Ex...
Identify Appropriate Statistical Tests
Suggest appropriate statistical test(s) to use for the following hypothesis/research question: '[State your hypothesis clearly, e.g., 'Is there a stat...
Interpret Statistical Results
Explain the meaning of these statistical results in the context of my research question: '[State your research question/hypothesis briefly]'. Test Per...
Suggest Data Visualization Types
Recommend the most effective type(s) of data visualization (e.g., bar chart, line chart, scatter plot, histogram, box plot, heatmap) to show the follo...
Generate Code for Data Visualizations
Generate starter code in [Language/Library, e.g., 'Python using Matplotlib/Seaborn', 'R using ggplot2'] to create a '[Specific Chart Type, e.g., 'grou...
Identify Patterns, Trends, or Outliers (Conceptual)
Suggest analytical techniques or specific functions/methods (mention tool if relevant, e.g., Excel, Python/Pandas, R) to identify potential [patterns...
Draft Analysis Summaries or Reports
Draft a concise summary paragraph or bullet points for a data analysis report section. Target Audience: [e.g., Non-technical executives, Marketing te...
Generate Python/R Code for Specific Analyses
Generate starter code in [Language/Library, e.g., 'Python using Scikit-learn', 'R using lm function', 'Python using Statsmodels'] to perform the follo...
Identify Key Recruitment Metrics (KPIs)
Identify and briefly define 5-7 key performance indicators (KPIs) that are essential for measuring the effectiveness and efficiency of a recruitment p...
Set Up Data Validation Rules
Explain how to set up an Excel data validation rule for the range [Specify cell range, e.g., C2:C100] to ensure that users can only [Describe the rest...
Generate Sample Data Sets
Generate a table of realistic sample data with [Number] rows for testing or demonstration purposes. Include the following columns: [List column header...
Outline Data Cleaning Steps
Suggest a sequence of steps using Excel features and/or formulas to clean the following data issues in my spreadsheet: - Issue 1: [e.g., Remove leadin...
Create Pivot Table Layouts
Suggest an effective Pivot Table layout in Excel to answer the question: '[State your analytical question, e.g., What are the total sales per Category...