Search: "data cleaning"

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #sensitivity-analysis #data-table

excel Advanced

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#coding #flaky-test #debugging

coding Advanced

Debug a flaky test without just retry-marking it and moving on

I have a test that fails ~1 in 20 runs. The test does [what]. The failure shows ...

#dashboards #review #leadership

Stress-test a dashboard before showing it to the leadership team

Act as a data lead reviewing my work before I show it up. I built a dashboard fo...

customer-service Beginner

Customer Support Response Templates for SaaS

Create a set of 10 customer support response templates for a SaaS product coveri...

#customer service #support #templates

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

#legal #terms-of-service #saas

legal advanced

Terms of Service Template for SaaS Platform User Agreements

Act as a technology attorney advisor specializing in SaaS agreements. Help me dr...

writing intermediate

Long-Form Blog Post Writer with SEO Structure

Write a comprehensive, SEO-optimized long-form blog post with the following spec...

#writing #blog #seo

#legal #privacy-policy #gdpr

legal intermediate

Privacy Policy Generator for Websites and Apps

Generate a comprehensive privacy policy for my website/app. Details: Business n...

excel Advanced

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#press-release #pr #launch

writing Beginner

Press Release Writer for Product Launch

Act as a PR writer. Write a press release for the launch of [PRODUCT] from [COMP...

design Intermediate

ChatGPT Prompt: Empty State Copy and Design Direction for First-Time Users

You are a product designer with content design experience. Design the empty stat...

#design #ux #empty-state

#net worth #personal finance #financial tracking

finance Beginner

ChatGPT Prompt: Personal Net Worth Statement Builder with Trend Analysis

Help me build a personal net worth statement and track changes over time. Here's...

Build a Pandas Data Quality Report for a Raw CSV Drop

Write a Python script using pandas that takes a CSV path and produces a one-page...

#data #pandas #python

#data #data-quality #monitoring

data Advanced

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

#data #quality #validation

Write a Data Quality Checklist for a New Pipeline

Act as a data reliability engineer. I'm shipping a new pipeline that loads {{sou...

#terms of service #saas #legal

legal Advanced

Terms of Service Outline for SaaS Product

Outline a Terms of Service agreement for a B2B SaaS product. Product: [DESCRIPTI...

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#data #data modeling #star schema

data Advanced

Design a Star Schema for an E-commerce Warehouse

Act as a data architect. Design a star schema for an e-commerce warehouse on [DB...

#data #communication #forecasting

Explain a Forecasting Model to Non-Technical Stakeholders

I built a [MODEL_TYPE] forecasting model with MAPE [MAPE_VALUE]. Write a 1-page ...

Spot-Check a Dataset for Quality Issues Before Modeling

I'm about to train a model on this dataset: [DESCRIBE COLUMNS, ROW COUNT, SOURCE...

#data #data quality #EDA

#excel #power query #survey

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...