Search: "data-processing"

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

excel Intermediate

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

excel Intermediate

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

excel Intermediate

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

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

coding Intermediate

Python Script to Parse and Analyze CSV Data

Write a Python script that reads a CSV file named "data.csv", performs analysis,...

#coding #python #csv

#coding #react #typescript

coding Advanced

React Component with TypeScript and Custom Hook

Build a React component in TypeScript for a [component type, e.g., paginated dat...

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

#board-deck #qbr #business-review

business advanced

Board Deck Preparation Guide for Quarterly Business Review

Create a board deck structure for a Quarterly Business Review. Slides: 1) Execut...

#interview #hiring #behavioral

hr intermediate

Structured Interview Guide for Behavioral Competency Assessment

Build a structured interview guide for assessing [role] across competencies: [e....

#excel #scenario-manager #what-if

excel advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...