Search: "cap table"

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

👁 12 views

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#coding #sql #query optimization

coding Advanced

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

#compensation #benchmarking #hr

hr advanced

Compensation Benchmarking Analysis Template for HR Teams

Create a compensation benchmarking analysis framework for [role or department] a...

#equity #vesting #cap table

legal advanced

Startup Equity: Founder Vesting Schedule and Option Pool Guide

Explain and help me structure equity for our [stage: pre-seed / seed / Series A]...

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

#data quality #audit #pipeline

Data Quality Audit Checklist Pipeline Reliability Framework

You are a data engineer. Audit data quality for [PIPELINE / TABLE]. Run through:...

#spaced-repetition #study #exam-prep

education Beginner

Spaced Repetition Study Plan Generator

Act as a learning scientist. Build a spaced-repetition study plan for [TOPIC], e...

#meeting-notes #action-items #summary

productivity Beginner

Meeting Notes Action-Extraction Prompt

Act as an executive assistant. I will paste raw meeting notes or a transcript. P...

#email #project-management #kickoff

email Beginner

ChatGPT Prompt: Project Kickoff Email to Cross-Functional Stakeholders

You are a project manager writing a kickoff email. Draft a clear, motivating ema...

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

#data #ab testing #statistics

A/B Test Power Analysis and Sample Size Calculator Walkthrough

Act as a statistics tutor for product analysts. Walk me through a complete power...

#legal #contracts #vendor

legal Advanced

Vendor Contract Redline Checklist with Risk Tiers

You are an in-house contracts attorney. I will paste a vendor contract. Run it t...

#excel #formulas #commission

Build a Dynamic Commission Calculator With Tiered Rates in Excel

I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql

#excel #dashboard #index-match

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

#finance #cap-table #startup

finance Advanced

Build a Cap Table You Can Actually Read

Act as a startup CFO. Help me build a clean cap table that survives 3 funding ro...

#finance #career #job-offer

finance Intermediate

Compare Two Job Offers Beyond Just the Salary

Help me compare two job offers honestly. Beyond base salary, include: equity (re...

#duplicates #data cleaning #excel

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#data quality #dashboard #monitoring

Build a Data Quality Dashboard Specification

Specify a data quality monitoring dashboard for a data warehouse with [N] tables...

#education #study plan #spaced repetition

education Beginner

Generate a Spaced Repetition Study Plan

Create a 21-day spaced repetition study plan to master [SUBJECT] before an exam ...