Search: "clean 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...

productivity Intermediate

ChatGPT Prompt: Weekly Review System Based on GTD and Bullet Journal Hybrid

Design a weekly review process tailored to my workflow. Context: - Role: [DESCR...

#weekly review #gtd #productivity system

excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#coding #refactoring #clean-code

Refactor a God Function Into Composable Units

Act as a senior engineer. I'll paste a function that does too much — parses inpu...

design Intermediate

User Flow Diagram for E-commerce Checkout

Map a complete e-commerce checkout user flow including all branching paths. Cont...

#user flow #ux #checkout

#coding #testing #property-based

Generate Property-Based Tests from Spec

Given the function signature and natural-language specification below, generate ...

#code-review #self-review #pr

Coding: Review Your Own PR Before You Send It

Walk through my diff like a reviewer who doesn't know the context. For each file...

#coding #code-review #mentoring

Review a Pull Request From a Junior Developer Without Crushing Their Confidence

I'm reviewing a PR from a junior developer who's been on the team for two months...

#fp&a #financial-modeling #drivers

finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#react #performance #virtualization

coding advanced

React Performance Optimization Techniques for Large Lists

Optimize a React application that renders a large list of [data type, e.g., 10,0...

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

#data cleaning #addresses #standardization

data Intermediate

Clean and Standardize Messy Customer Address Data

I have a messy customer address dataset (~500K rows, CSV). Issues observed: inco...

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