Search: "analytics SQL"

#slo #data-quality #pipelines

Design a Data Quality SLO Framework for a Critical Pipeline

Act as a data reliability engineer. Help me design a data quality SLO framework ...

👁 11 views

education intermediate

Microlearning Module Design: Mobile-First Bite-Sized Content Strategy

Design a microlearning program for my training topic. Context: Topic: [WHAT SKI...

#microlearning #instructional-design #mobile-learning

#exit-interview #attrition #retention

hr Intermediate

Exit Interview Guide and Theme Synthesizer

Act as a head of people analytics. Build an exit interview guide and a quarterly...

#migration #sql #zero-downtime

coding Advanced

Write a Defensive Migration Script for a NOT NULL Column Addition

Act as a database migration specialist. I need to add a NOT NULL column [column_...

#data #experimentation #ab-testing

Diagnose an A/B test that shows a 4% lift on a metric that should be flat

You are an experimentation lead. We ran an A/B test on [CHANGE] and saw a +4% li...

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

legal Advanced

Generate a GDPR-Aware Privacy Policy Checklist

You are a data privacy consultant who helps small companies get their privacy ba...

#legal #gdpr #privacy

#defaults #ux #progressive-disclosure

design Intermediate

Pick Defaults That Cover 80 Percent of Users Without Hiding the 20

Help me pick smart defaults for [FEATURE] that cover 80% of users without making...

Write a Cohort Retention Query That Doesn't Secretly Double-Count Users

I need a SQL cohort retention query that groups users by their signup week and s...

#data #sql #cohort

#marketing #channels #roi

marketing Advanced

Decide whether a marketing channel is working or just spending

We've been spending on [channel] for [period]. Spend: [$]. Leads/signups attribu...

#analysis #metrics #stakeholders

Translate a stakeholder question into something a dataset can answer

Act as an analytics translator. A stakeholder asked me a fuzzy question like "ar...

#data #cohort analysis #retention

Design a Cohort Retention Analysis from Raw Event Data

Help me design a cohort retention analysis. My raw data: an events table with us...

Build a Funnel Analysis That Answers Which Step to Fix First

Help me run a funnel analysis on [PRODUCT FLOW — e.g., signup → activate → retai...

#data #funnel #analytics

#data-quality #dashboard #sanity-check

Sanity Check a Dashboard Number That Looks Too Good to Be True

A number on my dashboard looks too good to be true. Metric: [METRIC NAME]. Repor...

#marketing #cac #attribution

marketing Advanced

Spot Which Channel Is Quietly Eating Your CAC and Lying About It

My overall CAC has crept up over the last [period]. Here's the channel mix: [lis...

coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query

#analytics #debugging #metrics

Diagnose Why a Dashboard Metric Suddenly Changed

You are a senior data analyst. Walk me through a structured investigation for: [...

#data #documentation #metrics

data intermediate

Write a metric definitions document that survives one analyst quitting

Act as a head of data preparing for an analyst's last day. I want the metric def...

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query

#cohort analysis #retention #saas

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

👁 7 views

#data-quality #audit #validation

Data Quality Audit Framework for New Source

Act as a data quality lead. I am onboarding a new data source: [SOURCE NAME], fo...

👁 7 views