Search: "data combine"

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

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

#UX design #design brief #product redesign

design Intermediate

UI/UX Design Brief Template for Product Redesign Projects

Create a comprehensive UI/UX design brief for redesigning [product/feature, e.g....

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#ab testing #statistics #significance

A/B Test Analysis Statistical Significance Sample Size Calculator

You are a data scientist. Help me analyze an A/B test on [METRIC] comparing [VAR...

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#data #data-quality #monitoring

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

#terms of service #saas #legal

legal Advanced

Terms of Service Outline for SaaS Product

Outline a Terms of Service agreement for a B2B SaaS product. Product: [DESCRIPTI...

#buyer persona #customer research #marketing

marketing Intermediate

Build a Buyer Persona from Customer Interview Data

Synthesize a buyer persona from these [N] customer interview notes: [PASTE NOTE...

legal Advanced

GDPR Data Subject Access Request Response

Draft a response template to a GDPR Data Subject Access Request from a customer....

#legal #gdpr #privacy

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

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

#data #visualization #honesty

Visualize a comparison without inventing a story that isn't there

I want to visualize a comparison between [GROUP A] and [GROUP B] on [METRIC]. Th...

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

Validate a survey result that contradicts your hypothesis

My survey of 400 users says they want [feature X], but everything else I know (s...

#data #research #survey

#legal #terms-of-service #saas

legal advanced

Terms of Service Template for SaaS Platform User Agreements

Act as a technology attorney advisor specializing in SaaS agreements. Help me dr...

#cohort analysis #retention #saas

Cohort Retention Analysis Framework SaaS Product Health

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

customer-service Intermediate

Refund Decision Matrix for Support Agents

Act as a head of customer support. Build a decision matrix for refund requests a...

#refund #policy #support

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

#data #quality #validation

Write a Data Quality Checklist for a New Pipeline

Act as a data reliability engineer. I'm shipping a new pipeline that loads {{sou...

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

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

#data cleaning #addresses #standardization

Clean and Standardize Messy Customer Address Data

I have a messy customer address dataset (~500K rows, CSV). Issues observed: inco...