Search: "data analysis"

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

#business #negotiation #batna

business Advanced

Prepare for a Negotiation with a BATNA Worksheet

Act as a negotiation coach trained in principled negotiation. Help me prepare fo...

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

#coding #algorithms #optimization

coding Advanced

Explain and Optimize an Algorithm

You are an expert algorithms tutor. Help me understand my algorithm's complexity...

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query

#excel #dashboard #pivottable

excel Intermediate

Build a Dynamic Excel Dashboard Summary

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

Clean and Deduplicate a Raw Dataset

Act as a data engineer. I have a raw dataset with these issues: [DESCRIBE — dupl...

#data #cleaning #etl

customer-service Intermediate

Write a Clear Help-Center Troubleshooting Article

Act as a technical writer for a customer help center. Turn the problem I describ...

#customer-service #knowledge-base #technical-writing

#data #data-modeling #spreadsheets

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

#data #data-cleaning #quality

Write a Data Cleaning Checklist

You are a data-quality analyst. Based on the dataset I describe, produce a thoro...

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

#pnl #financial-analysis #operations

finance Advanced

Read a P&L Like an Operator, Not an Accountant

Read this P&L like an operator. P&L: [PASTE OR DESCRIBE BY LINE]. Comparison per...

business Advanced

SWOT to OKR Translation Workshop

Given a SWOT analysis (Strengths, Weaknesses, Opportunities, Threats), translate...

#business #swot #okr

#hr #exit-interview #employee-experience

hr Intermediate

Exit Interview Question Set with Theme Coding

Generate a 12-question exit interview set covering: reasons for leaving, manager...

#legal #privacy-policy #gdpr

legal Intermediate

Plain-Language Privacy Policy Generator

Draft a plain-language privacy policy for a small SaaS product. Cover: what data...

#excel #pivot-tables #reporting

excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#coding #debugging #production

coding Intermediate

Coding: Trace a Bug That Only Reproduces in Production

I have a bug that won't reproduce locally but appears in production. Help me hun...

data Advanced

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention

legal Advanced

Legal: Write a Privacy Policy Section for a New Data Collection Practice

We're starting to collect [type of data] for [purpose] and we need to update our...

#legal #privacy #gdpr

#legal #privacy #compliance

legal Intermediate

Figure out which privacy regulations actually apply to a small business

I run a small business. I keep getting told I 'need to be GDPR compliant' and 'C...

#finance #cashflow #forecasting

finance Intermediate

Forecast cashflow for a business with lumpy revenue and predictable costs

I run a business with predictable costs but lumpy revenue — some months are 3x o...

#excel #charts #visualization

excel Beginner

Pick the chart that tells the story instead of the chart that's easy to make

I have a dataset and I'm about to default to a bar chart because that's what Exc...

#data #cleaning #preprocessing

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...