Search: "legacy code"

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

#data #visualization #charts

Data Visualization Chart Selection Guide

I have the following dataset: [describe data type, dimensions, and what I want t...

#coding #react #typescript

React Component with TypeScript and Custom Hook

Build a React component in TypeScript for a [component type, e.g., paginated dat...

#power query #M code #data transformation

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#FastAPI #JWT #authentication

coding intermediate

Python FastAPI REST API Authentication JWT

Build a production-ready FastAPI REST API with JWT authentication. Requirements:...

productivity intermediate

Async Communication Playbook Remote Team Efficiency

Create an async-first communication playbook for a remote team of [X people] wor...

#async communication #remote work #productivity

Python Pandas Advanced GroupBy and Aggregation Techniques

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

#pandas #python #groupby

#ab-testing #statistics #analytics

data advanced

A/B Test Analysis Statistical Significance Calculator Guide

Walk through a complete A/B test analysis for [experiment, e.g., testing two ema...

coding advanced

AWS Lambda Serverless Function Deployment Complete Guide

You are an AWS serverless architect. I need to build and deploy a serverless app...

#coding #aws #lambda

#coding #react #architecture

coding advanced

React Component Architecture Patterns for Large Scale Apps

You are a senior React architect. I am building a large-scale React application ...

#data #quality #assessment

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

design intermediate

Figma Design Handoff: Specification Documentation for Developers

Act as a product designer and design systems expert with experience in Figma-to-...

#design #figma #handoff

Data Cleaning Strategy and Python Script Generator

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

#data #cleaning #python

#rust #error handling #result

Rust Error Handling Result Option Patterns Idiomatic Code

You are a Rust mentor. Teach me idiomatic error handling for [PROJECT TYPE — CLI...

#pivot-table #yoy #analysis

excel Intermediate

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

#database migration #schema change #postgres

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

Design a safe database migration plan for [SCHEMA CHANGE]. Details: - Database:...

#design #design system #tokens

design Advanced

Design System Tokens Audit with Component Inventory

Act as a design systems lead. Audit a design system based on a description I wil...

ChatGPT Prompt for Refactor Legacy API Handler Safely

I need help refactoring a legacy API handler without breaking behavior. Here is ...

#coding #refactor #api

#data #data cleaning #pandas

data Intermediate

Data Cleaning Checklist for Messy Datasets

Create a comprehensive data cleaning checklist and guide for a messy dataset abo...

#data pipeline #monitoring #data quality

data advanced

Data Pipeline Monitoring Alerting Strategy Production

Design a monitoring and alerting strategy for a production data pipeline. My pip...

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#excel #array-formulas #sequence

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...