Programming & Development
Identify Technical SEO Issues to Check (Conceptual)
Generate a checklist of [Number, e.g., 10-12] common technical SEO areas or potential issues that a website owner should regularly check or audit. For...
Generate Schema Markup Ideas/Code (Basic)
For a webpage featuring '[Type of Content, e.g., 'a recipe for chocolate cake', 'an article about SEO trends', 'a product page for a wireless headphon...
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]...
Identify Phishing Scams (Digital Literacy)
List common red flags and tips to help identify phishing scams in emails, text messages, or on websites. Include indicators such as: - Suspicious send...
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:...
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...
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...
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...
Explain Simple Coding Concepts to Kids
Act as a 'Code Camp' Counselor. Explain the basic coding concept '[Basic Coding Concept]' (e.g., 'sequence', 'debugging', 'function', 'event') in a ve...
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...
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...
Suggest Appropriate Chart Types
Recommend the most appropriate Excel chart type(s) to visualize the following data and insight: Data Description: [e.g., Monthly website traffic over...
Generate VBA Macro Code
Write an Excel VBA macro code to perform the following repetitive task: [Clearly describe the step-by-step task, e.g., '1. Select cell A1 on Sheet 'In...
Debug VBA Macro Code
Help me debug the following Excel VBA code. Intended Functionality: [Describe what the macro is supposed to do]. Problem/Error Message: [Describe th...
Create Conditional Formatting Rules
Explain how to set up an Excel conditional formatting rule for the range [Specify cell range, e.g., D2:D100] that does the following: [Describe the ru...