Search: "data cleaning"

#excel #conditional-formatting #kpi

excel intermediate

Excel Conditional Formatting Rules for KPI Dashboard Indicators

Create a complete system of Excel conditional formatting rules to build a profes...

excel beginner

Excel Formula Troubleshooter and Optimizer

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

#excel #formula #debug

#writing #grant #nonprofit

writing advanced

Grant Proposal Writer for Nonprofits

Help me write a compelling grant proposal for my nonprofit organization. Details...

coding intermediate

REST API Design and Documentation Generator

Design and document a RESTful API for my application. Requirements: Application...

#coding #api #rest

data intermediate

SQL Query Builder for Complex Analytics

Help me write an optimized SQL query for my analytics need. Database details: D...

#data #sql #analytics

data advanced

Database Indexing Strategy & Query Performance Optimization Guide

Help me optimize my database performance through indexing. My context: Database...

#database #indexing #sql

#dashboard design #KPI #data visualization

Data Dashboard Design Blueprint for Business KPI Reporting

Design a KPI dashboard blueprint for [department: sales / operations / marketing...

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

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

#excel #conditional formatting #dashboard

excel Intermediate

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

#ab-test #power-analysis #experimentation

A/B Test Power Analysis Pre-Launch Check

Act as an experimentation statistician. Before launching an A/B test on [METRIC]...

#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

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

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

A/B Test Sample Size Calculator and Analysis

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

#excel #shift schedule #data validation

excel Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

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

#data #Google Sheets #dashboard

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