Search: "legacy code"

#ab testing #statistics #significance

data Advanced

A/B Test Analysis Statistical Significance Sample Size Calculator

You are a data scientist. Help me analyze an A/B test on [METRIC] comparing [VAR...

#hr #onboarding #new-manager

hr Intermediate

30-60-90 Day Onboarding Plan for a New Manager

Build a 30-60-90 day onboarding plan for a new people manager joining a 6-person...

#coding #refactor #clean-code

Refactor a Long Function Without Changing Behavior

I have a function that's grown too long and hard to test. Help me refactor it st...

#data #SQL #funnel analysis

data Intermediate

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#coding #pull request #code review

coding Beginner

Write a Clear PR Description That Reviewers Actually Read

Help me write a pull request description for [CHANGE I MADE]. Context: [WHAT BUG...

#code-review #production #risk-assessment

Review a Pull Request Diff With a Focus on What Could Break Production

Review this pull request diff with one focus: what could break production. Diff:...

#coding #code-review #mentorship

Coding: Review a PR From a Senior Without Just Saying LGTM

I'm reviewing a PR from [SENIOR ENGINEER] who's more experienced than me: [DESCR...

#cohort analysis #retention #saas

data Advanced

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

#data-quality #audit #validation

data Intermediate

Data Quality Audit Framework for New Source

Act as a data quality lead. I am onboarding a new data source: [SOURCE NAME], fo...

#coding #refactor #clean-code

Refactor Tangled Function Into Smaller Pure Pieces

Act as a code reviewer focused on readability. Below is a function that has grow...

#excel #power query #survey

excel Intermediate

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

#coding #tech-debt #workaround

Decide When a Workaround Has Lived Long Enough to Become Tech Debt

I'm looking at a workaround in our codebase that was added [N months/years ago] ...

#flaky-tests #debugging #race-conditions

Coding: Translate a Flaky Test Into a Real Bug or a Real Fix

I have a test that fails ~1 in 20 runs. Most people would mark it skip or retry-...

#coding #code-review #software-engineering

Coding: Review a PR Like You're the Last Line of Defense

Review the PR below as a senior engineer would. Cover: (1) correctness — does it...

#coding #code-review #debugging

Find the 'works on my machine' assumptions in a PR

I'm reviewing a pull request. I want to find the parts that work on the author's...

#code-review #checklist #quality

Generate a Code Review Checklist Tuned to Your Stack

You are an engineering manager building a code review culture from scratch. Gene...

Add Retry Logic with Exponential Backoff

Add retry logic with exponential backoff and jitter to my API call code. Cover: ...

#coding #retry #backoff

#coding #refactor #single responsibility

Refactor a Function That Has Too Many Responsibilities

I'll paste a function. Identify every responsibility it currently has (parsing, ...

#coding #database #migration

Write a Migration Plan for Renaming a Database Column

Plan a zero-downtime rename of database column [OLD_NAME] to [NEW_NAME] on table...

#coding #code-review #pull-request

Read a Pull Request Before You Approve It Without Reading It

I'm about to LGTM a PR I haven't fully read. Here's the diff: [paste diff or des...

#coding #debugging #race-condition

Debug Race Condition in Async Code

Analyze the following async code for race conditions. Identify any shared state ...

#coding #refactoring #clean-code

Coding: Refactor a Function That Does Too Much Without Breaking Callers

I have a function that's grown into a god-function. Refactor it without changing...

#coding #refactoring #decision-making

Coding: Choose Between Refactoring Now or Adding the Feature First

I want to add a feature, and the code I'd touch is messy enough that I'm tempted...