Search: "data tables"

#data #sql #window-functions

data Advanced

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

#excel #power-query #data-cleaning

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

#data quality #dashboard #monitoring

data Advanced

Build a Data Quality Dashboard Specification

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

#email marketing #win-back #customer retention

marketing Intermediate

Customer Win-Back Email Sequence

Design a 4-email win-back sequence for churned customers. Context: - Product: [P...

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#excel #invoice tracking #XLOOKUP

Automated Invoice Tracker with XLOOKUP and Running Balance

Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...

#hr #skills gap #training plan

hr Advanced

Employee Skills Gap Analysis and Training Plan

Act as an L&D (Learning & Development) specialist. Create a comprehensive skills...

#budget variance report #excel finance analysis #accounting export cleanup

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#vendor comparison matrix #software selection prompt #buying software evaluation

business Intermediate

ChatGPT prompt for software vendor comparison matrix before purchase

Act as a procurement and operations advisor. I need a software vendor comparison...

#playwright test generation #manual qa to automation #e2e test prompt

coding Intermediate

ChatGPT prompt for converting manual QA steps into Playwright test cases

Act as a test automation engineer. I have manual QA steps and I want them conver...

#churn reason taxonomy #open text analysis #customer exit survey prompt

data Intermediate

ChatGPT prompt for churn reason taxonomy from open-text survey responses

Act as a customer insights analyst. I need to turn messy open-text churn or exit...

#chatgpt prompt for KPI summary #SaaS metrics #weekly report

data Beginner

ChatGPT Prompt for Building a Weekly SaaS KPI Narrative from Raw Metrics

Act as a data storyteller for a SaaS business. I will paste weekly KPI numbers s...

#data #survey analysis #qualitative research

data Intermediate

ChatGPT Prompt for Survey Open-Text Response Coding Framework

Analyze these open-text survey responses and build a coding framework I can reus...

excel Advanced

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...

#pandas #python #groupby

#data #machine-learning #model-evaluation

data advanced

Machine Learning Model Evaluation and Selection Framework

You are a machine learning engineer and data scientist. I need to evaluate and s...

#excel #dashboard #slicer

excel intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

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

#pivot table #grouping #calculated fields

excel intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#Python #web scraping #BeautifulSoup

coding intermediate

Python Web Scraping: BeautifulSoup & Requests Data Extraction

Help me write a Python web scraper to extract [type of data] from [website descr...

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...