Search: "data"

#dates #iso #data cleaning

excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#difficult conversation #performance #management

hr Advanced

Difficult Conversation Script for Performance Improvement

Help me prepare a difficult conversation with a direct report whose performance ...

data Advanced

Write a SQL Query for Cohort Retention Analysis

Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...

#data #sql #cohort

Forecast Sales with Excel FORECAST.ETS

I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...

#excel #forecast #ets

#data #SQL #funnel analysis

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#excel #scenarios #data tables

excel Intermediate

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

#data-questions #stakeholder #requirements

Translate a Vague Stakeholder Question Into an Answerable Data Question

Translate a vague stakeholder request into a precise, answerable data question. ...

#data-viz #chart-selection #storytelling

data Beginner

Pick the Right Chart for the Story You're Trying to Tell

Help me pick the right chart for the story I'm trying to tell. Data shape: [ROWS...

#sensitivity #what-if #modeling

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#requirements #sql #stakeholders

Data: Translate a Stakeholder's Vague Question Into a Real Query

A stakeholder asked me 'how is our growth doing?' Help me turn that into a real,...

#business #operations #customer-management

business Intermediate

Business: Fire a Customer Who's Costing More Than They Pay

We have a customer [DESCRIBE: revenue, support load, custom requests, behavior]....

#coding #debugging #production

coding Advanced

Coding: Debug a Heisenbug That Only Shows Up in Production

I have a bug that reproduces in prod but not in any other environment: [SYMPTOM,...

#anomaly detection #metrics #WAU

Decide if a weekly metric drop is signal or noise

Our weekly active users dropped 8% week-over-week. Before I escalate, help me de...

#power-query #m-language #etl

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#excel #sensitivity-analysis #data-table

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#coding #flaky-test #debugging

coding Advanced

Debug a flaky test without just retry-marking it and moving on

I have a test that fails ~1 in 20 runs. The test does [what]. The failure shows ...

#dashboards #review #leadership

Stress-test a dashboard before showing it to the leadership team

Act as a data lead reviewing my work before I show it up. I built a dashboard fo...

Excel Macro to Automate Monthly Report

Write a VBA macro for Excel that automates my monthly reporting process. The mac...

#excel #vba #macro

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

#marketing #google-ads #ppc

marketing intermediate

Google Ads Search Campaign Setup Optimization Complete Playbook

Build a comprehensive Google Ads search campaign from setup to optimization. Cov...

writing intermediate

Long-Form Blog Post Writer with SEO Structure

Write a comprehensive, SEO-optimized long-form blog post with the following spec...

#writing #blog #seo

#legal #privacy-policy #gdpr

legal intermediate

Privacy Policy Generator for Websites and Apps

Generate a comprehensive privacy policy for my website/app. Details: Business n...

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation