Search: "data analysis"

#finance #forecasting #revenue

finance Advanced

Forecast revenue when sales cycles are long and the data is thin

I'm forecasting revenue for the next 6 months. Our sales cycle is 4-8 months. We...

#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

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

#formulas #validation #helper-column

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

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

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

#business #swot #analysis

business beginner

Conduct a SWOT Analysis

Act as a business strategist. Perform a detailed SWOT analysis for [company or p...

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

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

#excel #sumifs #debugging

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

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

#business #strategy #swot

business Intermediate

Run a Quick SWOT Analysis

You are an expert business strategy consultant. Help me produce a focused SWOT a...

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

#finance #ratios #analysis

finance Intermediate

Explain Key Financial Ratios for a Business

You are an expert financial analyst. Help me understand and compute the financia...

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

#business #strategy #swot-analysis

business Advanced

Run a SWOT and Action Plan for My Idea

You are a pragmatic business strategist. I will describe a business, product, or...

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

#business #pre-mortem #risk

business Advanced

Run a Pre-Mortem on a Project Plan

You are a risk facilitator running a pre-mortem. I will describe a project I'm a...

#contract-review #vendor-contract #redline

legal Advanced

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

#duplicates #dedupe #power-query

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#data #sql #query-optimization

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...