Search: "data combine"

#charts #visualization #chart selection

Pick the right chart when you can't decide between a bar and a line

I want to show how 4 product lines have grown over 12 months. I keep flip-floppi...

#cohort #retention #heatmap

excel Advanced

Build a Cohort Retention Heatmap Workbook in Excel

Act as a senior analytics engineer. I will paste a list of user signup events wi...

Build a SQL Style Guide That Survives a Growing Team

Act as a data platform tech lead. Write me a SQL style guide tailored to a 10-pe...

#sql #style-guide #dbt

#data #dashboards #metrics

Build a one-glance metrics dashboard for a non-technical CEO

Help me design a single-screen weekly metrics dashboard my CEO will actually rea...

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda

data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates

#data #quality #monitoring

data intermediate

Detect a data-quality problem before stakeholders find it for you

Act as an analytics engineer who has had to apologize for wrong dashboards. Help...

#education #parent-conference #classroom-management

education intermediate

Run a parent-teacher conference that produces a behavior change, not a list of grievances

Act as a veteran teacher coaching a colleague before a difficult parent-teacher ...

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

#visualization #charts #communication

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

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

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

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

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

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

Choose the Right Chart for Your Data

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