Search: "data-validation"

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#research paper #academic writing #literature review

writing Advanced

Research Paper Outline: Literature Review and Methodology Structure Guide

Help me create a comprehensive outline for an academic research paper. I need: ...

#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

#legal #privacy-policy #gdpr

legal Advanced

Privacy Policy Generator for a Small Web App with Analytics and Email

Generate a clear, GDPR + CCPA compliant privacy policy for a small web app. Inpu...

Build Dynamic Dashboard With Slicers and Pivot Charts

Act as an Excel dashboard designer. I have a dataset of {{describe data: e.g., m...

#excel #dashboard #pivot

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

#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 #formulas #automation

Excel Intermediate

Excel Formula Generator

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

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

Excel XLOOKUP Formula for Multi-Criteria Search

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

#excel #xlookup #formula