Search: "data-cleaning"

#data quality #etl #data engineering

ChatGPT Prompt: Data Quality Audit Framework for ETL Pipelines

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

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

legal Advanced

Plain-Language Summary of a SaaS Master Services Agreement

Below is a SaaS Master Services Agreement (MSA) sent by a vendor. Produce a plai...

#legal #contracts #msa

#data #root-cause #analysis

Investigate an Unexpected Drop in a Key Metric

You are a data detective. A key metric dropped 18% week-over-week with no obviou...

#A/B testing #statistical significance #conversion rate

A/B Test Results Statistical Analysis

Analyze my A/B test results and tell me if the winner is statistically significa...

#A/B testing #sample size #statistical significance

data Intermediate

A/B Test Sample Size Calculator and Analysis

Help me plan and analyze an A/B test: **Planning Phase:** - Current conversion ...

#data #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

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

#data #survey analysis #qualitative research

data Intermediate

ChatGPT Prompt for Survey Open-Text Response Coding Framework

Analyze these open-text survey responses and build a coding framework I can reus...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

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

#legal #nda #non-disclosure

legal Advanced

ChatGPT prompt for creating a non-disclosure agreement template for business partnerships

Act as a business attorney experienced in commercial agreements and intellectual...

#grant proposal #nonprofit writing #funding application

writing advanced

Grant Proposal Writing Nonprofit Funding Application

Help me write a grant proposal for [nonprofit organization name] applying for fu...

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#excel #pivot-table #reporting

excel intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

coding intermediate

Docker Containerization for Python Flask Applications

You are a DevOps engineer specializing in containerization. I need to containeri...

#coding #docker #python

#data #looker-studio #dashboard

data intermediate

Google Looker Studio Dashboard Design for Business Intelligence

You are a BI analyst and data visualization expert. I need to build a profession...

#data #storytelling #presentation

data intermediate

Data Storytelling Report and Narrative Structure Framework

You are a data storytelling expert and communications consultant. I have analyze...

#legal #privacy-policy #gdpr

legal advanced

Privacy Policy Generator for SaaS and Mobile Apps

You are a privacy law specialist and legal tech writer. I need to create a compr...

#marketing #persona #customer-research

marketing intermediate

Customer Persona Development Research Framework

You are a market researcher and growth strategist. I need to develop detailed cu...

#excel #dashboard #slicer

excel intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#writing #white-paper #technical

writing advanced

White Paper Structure: Executive Summary to Technical Depth

Act as a technical writer and thought leadership content strategist. Help me pla...