Search: "data-modeling"

#sql #cohort analysis #retention

SQL Query to Find User Cohort Retention by Month

Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...

#data quality #dashboard #monitoring

Build a Data Quality Dashboard Specification

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

data Intermediate

Build a Python Pandas Pipeline for Data Cleaning

Write a reusable Python pandas pipeline that cleans a CSV with columns [COLUMN_L...

#data #python #pandas

#excel #forecasting #revenue

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#template #data-validation #conditional-formatting

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#data #analytics #investigation

Data: Find the Real Cause When a Metric Drops 12% Overnight

[METRIC] dropped 12% on [DATE]. The execs want an answer by EOD. Help me investi...

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

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#data quality #anomaly detection #data monitoring

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#email #data request #stakeholders

email Intermediate

ChatGPT prompt for writing a data request email that gets stakeholders to send the right files

Act as a business analyst who needs clean stakeholder input. I need an email re...

#sql migration prompt #rollback safe deployment #database schema change

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#legal #nda #non-disclosure

legal Advanced

ChatGPT prompt for creating a non-disclosure agreement template for business partnerships

Act as a business attorney experienced in commercial agreements and intellectual...

#excel #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#writing #linkedin #thought-leadership

writing intermediate

LinkedIn Thought Leadership Article

Write a LinkedIn article that establishes me as a thought leader in [my industry...

#grant proposal #nonprofit writing #funding application

writing advanced

Grant Proposal Writing Nonprofit Funding Application

Help me write a grant proposal for [nonprofit organization name] applying for fu...

#vendor-agreement #procurement #legal

legal intermediate

Vendor Agreement Review Checklist for Procurement Teams

Create a vendor agreement review checklist for [company type]. Categories: 1) Pr...

#excel #pivot-table #reporting

excel intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#email #salary #negotiation

email intermediate

Salary Increase Request Email: Performance-Based Framework

Act as a career coach and salary negotiation expert. Help me write a compelling ...

#writing #white-paper #technical

writing advanced

White Paper Structure: Executive Summary to Technical Depth

Act as a technical writer and thought leadership content strategist. Help me pla...

#UX research #user interviews #usability testing

design intermediate

UX Research Plan: User Interview and Usability Testing Template

Help me design a UX research plan for [product/feature: describe what you're tes...

#Facebook Ads #Meta Ads #social media advertising

marketing Intermediate

Facebook Ads Campaign: Structure, Targeting, and Creative Guide

Help me set up an effective Facebook and Instagram ad campaign. I need: 1. CAMP...

#excel #lambda #custom-functions

excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...