Search: "data tables"

#legal #terms-of-service #contracts

legal intermediate

Terms of Service Essential Clauses Writing Guide for Online Businesses

Create a comprehensive guide for drafting Terms of Service (ToS) for online busi...

#finance #investing #portfolio

finance intermediate

Investment Portfolio Rebalancing Strategy Template Guide

Create a comprehensive guide for individual investors on portfolio rebalancing s...

excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug

#privacy policy #GDPR #CCPA

legal Advanced

Privacy Policy Template for Websites and Mobile Apps

Draft a privacy policy template for [type of website/app, e.g., a B2B SaaS platf...

#data quality #etl #data engineering

data Advanced

ChatGPT Prompt: Data Quality Audit Framework for ETL Pipelines

Build a data quality audit framework for [PIPELINE/TABLE]. Context: - Source sy...

#coding #tech spec #architecture

coding Advanced

Tech Spec Template for a Greenfield Backend Service

Act as a staff engineer writing a tech spec for a new service. I will give you t...

#data #sql #cohort-analysis

data Advanced

Cohort Retention Analysis SQL Query With Visualization Stub

Write a SQL query that produces a monthly cohort retention table for [SaaS PRODU...

#hr #compensation #benchmarking

hr Advanced

Compensation Benchmark Memo for a Specific Role and Geography

Write a compensation benchmark memo for [ROLE] in [GEOGRAPHY]. Include: 25th/50t...

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

excel Intermediate

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

#excel list reconciliation #duplicate matching #near match cleanup

excel Intermediate

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

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

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

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

Excel XLOOKUP Formula for Multi-Criteria Search

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

#excel #xlookup #formula