Search: "data-table"

#debugging #audit #trace-precedents

excel Intermediate

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#code-review #pr #reviews

coding Advanced

Review a pull request for the thing the author didn't realize they were doing

You're a senior engineer doing a code review. I'll paste the diff. Don't comment...

#experimentation #ab-testing #significance

data Advanced

Decide whether an experiment result is real, lucky, or a measurement artifact

You're an experimentation lead. I ran an A/B test, the headline metric moved 4.2...

#formulas #validation #helper-column

excel Intermediate

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

data intermediate

Write SQL Queries from a Question

Act as a SQL expert. My tables are: [describe tables and key columns]. Write a S...

#data #sql #queries

data beginner

Design a Data Collection Survey

Act as a research methodologist. Design a survey to measure [goal, e.g., custome...

#data #survey #research

#data #statistics #interpretation

data intermediate

Interpret Statistical Results in Plain English

Act as a statistics tutor. Explain these results in plain English: [paste number...

#data #charts #visualization

Decide which chart actually fits my data and question

I'll describe my dataset and the question I'm trying to answer. Recommend the ri...

#legal #policy #compliance

legal Intermediate

Turn a fuzzy intention into a clear written policy

I have a rough intention for an internal policy (returns, remote work, data hand...

#excel #dropdown #data validation

excel Advanced

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

#excel #sumifs #debugging

excel Intermediate

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

Choose the right join before I merge two datasets

I have two tables I want to combine and I'll describe the key columns and what e...

#data #joins #sql

#data #data quality #validation

data Beginner

Sanity-check a dataset before I trust it

I'll describe a dataset I just received. Give me a checklist of the first things...

#data #statistics #confidence interval

Explain what a confidence interval is actually telling me

I keep reporting confidence intervals without being sure what they mean. Explain...

#data #charts #visualization

Choose the chart that fits my data and my question

I'll tell you what data I have and the question I'm trying to answer with it. Re...

#contract-review #vendor-contract #redline

legal Advanced

Spot the 5 Riskiest Clauses in a Vendor Contract Before Sending to Counsel

Pre-screen a vendor contract before I send it to legal. Contract: [PASTE OR DESC...

#data #definitions #quality

Spot a Data Definition Disagreement Before It Burns You

Two teams at my company are reporting different numbers for [metric name]. Team ...

#data #ab-testing #experimentation

data Advanced

A/B Test Sample Size and Duration Calculator

Calculate the required sample size and test duration for an A/B test given: base...

#charts #visualization #dataviz

Data: Pick the Right Chart Type for the Thing You Actually Want to Say

I have a dataset and I know what I want the audience to take away — but I keep d...

#legal #compliance #privacy

legal Advanced

Figure out if a new data flow needs a privacy review or just a note in the doc

We're about to start collecting [type of data] from [type of user] for [purpose]...

#expansion #strategy #decision framework

business Advanced

Decide whether to launch in a new city or go deeper in the current one

We are at the fork between expanding to a second city next quarter or doubling d...

#SaaS contract #auto-renewal #redlines

legal Intermediate

Spot the auto-renewal traps in a SaaS contract before signing

Review the SaaS contract section I am about to paste. Specifically flag: (1) aut...

legal Advanced

Draft a Plain-English MSA Summary for a Non-Lawyer Executive

Act as in-house counsel translating contracts for executives. I will paste a Mas...

#msa #contracts #summary