Search: "data-viz"

#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

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

#excel #pivot-tables #analysis

excel Intermediate

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

#legal #compliance #privacy

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

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

#data #warehouse #cost-optimization

data Advanced

Reduce data pipeline cost without losing freshness or completeness

You are a data platform engineer. Our [WAREHOUSE] bill is up 60% YoY while data ...

Spot the three clauses in a SaaS contract that quietly transfer risk to you

Act as a commercial contracts attorney. Review this SaaS agreement [PASTE_CONTRA...

#legal #contracts #saas

#contracts #review #vendor

Read a vendor contract for the clauses that bite you 18 months in

You're a commercial counsel reviewing a vendor contract on my behalf — but expla...

#visualization #charts #communication

data Beginner

Decide which chart actually fits the point you are making

Act as a data visualization expert. I will tell you the comparison or trend I wa...

#data-quality #validation #checklist

Sanity-check a dataset before you trust a single number from it

You're a careful data analyst. Before I build anything on this dataset, give me ...

#analysis #metrics #stakeholders

Translate a stakeholder question into something a dataset can answer

Act as an analytics translator. A stakeholder asked me a fuzzy question like "ar...

#contract-review #gaps #protections

Spot the missing protections in an agreement before you sign

Act as a deal-experienced reviewer (not legal advice — say so). I will describe ...

#excel #data cleaning #power query

excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#legal #privacy policy #compliance

legal intermediate

Write a Privacy Policy for a Website

Act as a privacy compliance assistant. Draft a clear privacy policy for a [type ...