Search: "data-science"

excel beginner

Excel Formula Troubleshooter and Optimizer

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

#excel #formula #debug

#exit-interview #offboarding #employee-retention

hr intermediate

Exit Interview Questions Framework & Offboarding Insights Guide

Build a comprehensive exit interview program for my organization. Context: Comp...

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

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

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

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

Convert Messy Text Column Into Clean Structured Fields

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

#excel #power-query #data-cleaning

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

#data #root-cause #analysis

data Advanced

Investigate an Unexpected Drop in a Key Metric

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

Auto-Format New Data VBA

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

#excel #VBA #macro

#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 inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#sales commission tracker #tiered commission excel #clawback formula

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

#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 #cohort analysis #retention

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

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

#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

#writing #executive-summary #business-report

writing intermediate

Write an Executive Summary for a Business Report

Write an executive summary for the following business report: [paste key finding...

#excel #pivot table #sales analysis

excel Beginner

Excel Pivot Table Sales Analysis from Raw Data

Guide me through creating a comprehensive sales analysis using Excel Pivot Table...