Search: "data extraction"

#Python #pandas #data cleaning

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

#interview questions #behavioral interview #hiring

hr intermediate

Interview Question Bank: Behavioral and Structured Interview Guide

Create a comprehensive interview question bank for hiring a [role title, e.g., S...

#opinion article #thought leadership #persuasive writing

writing Intermediate

Opinion Article Writing: Persuasive Argument Framework and Structure

Help me write a persuasive opinion article or thought leadership piece. I need: ...

#ETL #data warehouse #data pipeline

data Advanced

ETL Pipeline Design: Best Practices for Data Warehouse Architecture

Help me design a production-grade ETL (Extract, Transform, Load) pipeline for a ...

#remote work policy #employee handbook #HR policy

hr Intermediate

Remote Work Policy: Employee Handbook Section Design Guide

Help me write a comprehensive remote work policy for our employee handbook. I ne...

#graphql #api #schema-design

coding advanced

GraphQL Schema Design API Query Optimization Best Practices

Build a production-ready GraphQL API with optimal schema design and performance....

#data #etl #data-pipeline

data advanced

Data Pipeline Architecture Design ETL vs ELT Decision Framework

Design a modern data pipeline architecture with guidance on ETL vs ELT approach ...

excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug

data intermediate

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#dynamic arrays #filter #sort

excel Intermediate

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...

#cohort analysis #retention #sql

data Advanced

ChatGPT Prompt: Cohort Retention Analysis SQL with Visualization Plan

Write SQL for a cohort retention analysis and explain how to visualize it. Cont...

Auto-Send Email Report VBA

Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...

#excel #VBA #macro

#excel #shift schedule #data validation

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#excel inventory tracker #reorder point #stock management

excel Intermediate

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#sales commission tracker #tiered commission excel #clawback formula

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

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

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

#conversion rate drop analysis #marketing analytics prompt #funnel diagnosis

data Advanced

ChatGPT prompt for diagnosing a sudden drop in conversion rate from mixed-source metrics

Act as a data analyst investigating a sudden conversion-rate drop. I need a stru...

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

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#excel #cohort analysis #retention

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

#coding #debugging #background jobs

coding Advanced

ChatGPT Prompt for Debugging Intermittent Background Job Failures

Help me debug intermittent background job failures. Context: application stack [...

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