Search: "data quality"

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 #statistics #confidence interval

Explain what a confidence interval is actually telling me

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

#excel #data cleaning #deduplicate

excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#data #schema #spreadsheet

data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...

#data #analysis #insights

Interpret a Dataset and Find Insights

You are an expert data analyst. Help me find the story in a set of numbers I'll ...

#data #visualization #charts

data Beginner

Choose the Right Chart for Your Data

You are an expert data visualization specialist. Help me pick the best chart typ...

#excel #dashboard #pivottable

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#excel #formulas #xlookup

excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...

#writing #headlines #copywriting

writing Beginner

Generate Multiple Headline Options with Angles

Act as a headline strategist. For this piece of content: [DESCRIBE TOPIC/ARTICLE...

#data #analysis #insights

Interpret a Dataset and Surface Insights

You are a data analyst. I'll paste a summary table or describe a dataset: [PASTE...

#excel #pivot-table #reporting

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#coding #code-review #security

coding Advanced

Review My Pull Request Like a Senior Engineer

Act as a thorough but kind senior engineer reviewing a pull request. I will past...

#data #visualization #charts

data Beginner

Choose the Right Chart for My Data

You are a data visualization expert. I will describe what I want to show and you...

#data #ab-testing #statistics

data Advanced

Interpret the Results of an A/B Test

You are an experimentation analyst. I will give you the numbers from an A/B test...

#pivot-table #debugging #totals

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#data #analysis #statistics

Decide whether a metric change is real or just noise this week

A metric I track jumped by 15% this week compared to last week. Before I tell an...

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

#SQL #window functions #query optimization

data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

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

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

#debugging #audit #trace-precedents

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

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