Search: "data-modeling"

#data #analysis #insights

data intermediate

Analyze a Dataset and Find Insights

Act as a data analyst. I have a dataset with these columns: [list columns]. Sugg...

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

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