Search: "data analysis"

#business #strategy #memo

Build a One-Page Strategy Memo Using the McKinsey Pyramid Principle

Convert my rough strategic thinking below into a one-page memo using Barbara Min...

data Intermediate

Pandas Cleanup Pipeline for a Messy Real-World CSV

Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...

#data #pandas #csv

#excel #text-functions #parsing

excel Intermediate

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

#legal #privacy policy #GDPR

legal Intermediate

Privacy Policy for Website

Write a privacy policy for [type of website/app]. It should cover: 1) What data ...

#NDA #non-disclosure agreement #confidentiality

legal Beginner

Non-Disclosure Agreement (NDA) Template

Create a Non-Disclosure Agreement (NDA) for my situation. Type: [Mutual (both p...

#conditional formatting #KPI #dashboard

excel Intermediate

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

#market entry #expansion strategy #international business

Market Entry Strategy for New Geographic Region

Develop a market entry strategy for expanding into a new geographic region: - C...

#competitor pricing analysis #positioning strategy #pricing comparison

ChatGPT prompt for competitor pricing analysis and positioning summary

You are a product marketing strategist. I will paste competitor pricing pages, p...

#debug api integration #production bug #troubleshooting prompt

coding Advanced

ChatGPT prompt for debugging a flaky API integration in production

You are a senior backend engineer helping diagnose a flaky API integration in pr...

#customer interview guide #user research prompt #discovery interview

ChatGPT prompt for drafting customer research interview guide

You are a product researcher. Help me create a customer research interview guide...

#excel #cohort analysis #retention

excel Advanced

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: execut...

#sql #churn analysis #customer retention

data Advanced

ChatGPT prompt for building a SQL query to analyze customer churn patterns

Act as a senior data analyst specializing in customer retention. I need SQL que...

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

#coding #regex #validation

coding intermediate

Regex Patterns for Form Data Validation

Provide production-ready regex patterns for validating the following form fields...

#excel #data-validation #dropdown

excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#JavaScript #async await #error handling

coding intermediate

JavaScript Async/Await: Error Handling Patterns and Best Practices

Explain and demonstrate best practices for async/await error handling in JavaScr...

#excel #dashboard #visualization

excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#remote work #hybrid #hr policy

hr Advanced

Remote Work Policy Document Hybrid Distributed Team Guidelines

Act as an HR policy writer. Draft a remote work policy for [COMPANY] supporting ...

#sql #optimization #performance

data Advanced

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

excel Advanced

Executive KPI Dashboard Template Build in Excel

Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...

#excel #dashboard #kpi

#business #pricing #strategy

Pricing Strategy Memo with Value-Based Reasoning and Test Plan

You are a pricing consultant for B2B SaaS. Draft a 2-page pricing strategy memo ...

#excel #cohort #retention

excel Advanced

Build a Cohort Retention Heatmap in Excel

I have customer signup and activity data in Excel. Help me build a monthly cohor...