Search: "data summary"

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

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

Convert Messy Text Column Into Clean Structured Fields

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

#data #documentation #metrics

data Intermediate

Write a Data Definition Doc That Stops 'Wait, How Is This Calculated' Questions

Help me write a data definition doc for [METRIC NAME] that ends ambiguity foreve...

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro

#power query #CSV import #data transformation

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#excel #shift schedule #data validation

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#code review checklist #pull request checklist #software quality

coding Intermediate

ChatGPT prompt for code review checklist before merging feature branch

Act as a senior engineer preparing a code review checklist for a feature branch ...

#excel list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

#executive summary proposal #decision maker summary #business proposal writing

writing Advanced

ChatGPT prompt for executive summary of a long proposal for decision makers

Act as an executive communications writer. I need a sharp executive summary for ...

#chatgpt prompt for KPI summary #SaaS metrics #weekly report

data Beginner

ChatGPT Prompt for Building a Weekly SaaS KPI Narrative from Raw Metrics

Act as a data storyteller for a SaaS business. I will paste weekly KPI numbers s...

#chatgpt prompt for contract review #service agreement #legal summary

legal Beginner

ChatGPT Prompt for Reviewing a Service Agreement Before Signing

Act as a practical contract reviewer for a small business. I will paste a servic...

#excel #cash flow #forecast

ChatGPT Prompt for Excel Monthly Cash Flow Forecast with Collections Delay

I need a monthly cash flow forecast in Excel for a business with uneven customer...

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#email #scope creep #client communication

email Intermediate

ChatGPT Prompt for Client Email Explaining Scope Creep and Next Steps

Write an email to a client explaining that their recent requests are outside the...

#productivity #meeting agenda #decision-making

productivity Beginner

ChatGPT Prompt for Meeting Agenda That Ends with Decisions and Owners

Create a meeting agenda for [meeting type] with a clear goal: [goal]. Participan...

#founder update #investor communication #startup writing

writing Intermediate

ChatGPT Prompt for Writing a Founder Update Investors Will Actually Read

Help me write a monthly founder update for investors that is concise, honest, an...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

#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....

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

#python #web scraping #beautifulsoup

coding Intermediate

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#coding #react #typescript

coding Advanced

React Component with TypeScript and Custom Hook

Build a React component in TypeScript for a [component type, e.g., paginated dat...