Search: "data-viz"

excel Advanced

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro

#legal #privacy #transparency

legal Intermediate

Write a privacy notice users might actually read

Write a user-facing privacy notice for [PRODUCT]. I'll separately have lawyers w...

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

Fix a column where 30% of values are 'kind of right but not parseable'

I have a column in a dataset that's supposed to be a phone number, date, or addr...

#data #cleaning #etl

#SQL #window functions #query optimization

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

#data #ab-testing #experimentation

Choose between A/B test variants when results are statistically tied

My A/B test ran for 3 weeks. Variant B is +0.4% on the primary metric, not stati...

#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

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

Explain a metric movement to a skeptical stakeholder without overclaiming

[Metric] moved [direction + magnitude] in [period]. The first plausible explanat...

#data #metrics #analysis

#data #metrics #north-star

data advanced

Decide which metric to make the team's North Star without flattening the work

Act as a data leader who has watched teams pick the wrong North Star and live wi...

#data #quality #monitoring

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

#debugging #audit #trace-precedents

excel Intermediate

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

#code-review #pr #reviews

coding Advanced

Review a pull request for the thing the author didn't realize they were doing

You're a senior engineer doing a code review. I'll paste the diff. Don't comment...

#experimentation #ab-testing #significance

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

excel Intermediate

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

#power-query #data-cleaning #pivot

excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#data #analysis #insights

Analyze a Dataset and Find Insights

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

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

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