Nav Toor Profile picture
Feb 26 14 tweets 11 min read Read on X
BREAKING: AI can now write Python scripts like a $250K/year senior developer at Google (for free).

Here are 12 insane Claude prompts that automate any task in minutes (Save for later) Image
1. The Google Staff Engineer Script Builder

"You are a staff software engineer at Google who writes clean, production-grade Python scripts that automate complex workflows for teams processing millions of data points daily.

I need a complete Python script that automates a specific task I currently do manually.

Build:

- The full working script ready to copy, paste, and run immediately
- Clear comments explaining every block of code in plain English
- Error handling: try-except blocks that catch failures gracefully instead of crashing
- Input validation: check that the data or files fed in are correct before processing
- Progress indicators: print statements showing what the script is doing at each step
- Logging: save a record of what happened each time the script runs
- Configuration section at the top: all settings I might want to change in one easy place
- Requirements list: every library needed with exact pip install commands
- How to run it: step-by-step instructions for someone who has never run Python before
- How to schedule it: make this script run automatically every day, week, or month

Format as a complete, tested Python script with a README explaining setup and usage in under 5 minutes.

My task to automate: [DESCRIBE THE MANUAL TASK YOU DO REPEATEDLY, WHAT DATA IS INVOLVED, AND WHAT THE OUTPUT SHOULD LOOK LIKE]"
2. The Amazon File Processing Automator

"You are a senior automation engineer at Amazon who builds Python scripts that process thousands of files per hour across AWS infrastructure, transforming raw data into organized, analysis-ready formats.

I need a Python script that automatically processes, renames, moves, or transforms my files.

Build:

- File discovery: scan folders and subfolders to find all files matching my criteria
- Filtering logic: process only specific file types, date ranges, or name patterns
- Batch renaming: rename hundreds of files using consistent naming conventions automatically
- Format conversion: convert between CSV, JSON, Excel, PDF, or text formats
- Data extraction: pull specific information from inside files (dates, numbers, names, tables)
- File organization: sort files into folders by date, type, project, or any custom rule
- Duplicate detection: find and flag identical or near-identical files wasting storage
- Compression: zip processed files and archive originals for backup
- Summary report: generate a log showing every file processed, skipped, or failed
- Undo capability: a reverse script that restores original file names and locations if needed

Format as a complete Python script with a configuration section for customizing file paths, patterns, and rules without editing code.

My file problem: [DESCRIBE YOUR FILE TYPES, FOLDER STRUCTURE, WHAT PROCESSING YOU NEED, AND WHERE OUTPUT FILES SHOULD GO]"
3. The Netflix Web Scraping Engineer

"You are a senior data engineer at Netflix who builds Python web scrapers that collect competitive intelligence from thousands of web pages, transforming unstructured websites into clean structured datasets.

I need a Python web scraper that automatically collects data from websites.

Build:

- URL handling: scrape a single page, multiple pages, or automatically follow pagination links
- HTML parsing: extract exactly the data I need using BeautifulSoup or Selenium selectors
- Data cleaning: strip HTML tags, remove whitespace, and normalize extracted text
- Rate limiting: add delays between requests so I don't get blocked or overwhelm the server
- User-agent rotation: mimic a real browser to avoid basic bot detection
- Retry logic: automatically retry failed requests instead of crashing on one error
- Data storage: save results to CSV, JSON, or Excel with proper column headers
- Incremental scraping: skip pages already scraped so I can resume without starting over
- Proxy support: option to route requests through proxies for large-scale collection
- Scheduling setup: instructions to run this scraper automatically on a recurring schedule

Format as a complete Python scraping script with requests/BeautifulSoup and a Selenium fallback for JavaScript-heavy sites.

My scraping target: [DESCRIBE THE WEBSITE, WHAT DATA YOU WANT TO EXTRACT, HOW MANY PAGES, AND HOW OFTEN YOU NEED UPDATED DATA]"
4. The Stripe API Integration Specialist

"You are a senior backend engineer at Stripe who builds Python scripts that connect APIs together, creating automated workflows between business tools that would otherwise require expensive middleware or manual data transfer.

I need a Python script that connects to APIs and automates data flow between my tools.

Build:

- API authentication: handle API keys, OAuth tokens, and bearer tokens securely
- GET requests: pull data from any API and parse the JSON response into usable Python objects
- POST requests: send data to APIs to create records, trigger actions, or update information
- Pagination handling: automatically loop through all pages of API results, not just the first page
- Rate limit compliance: respect API rate limits with smart throttling and backoff logic
- Data transformation: reshape data from one API's format to match another API's expected input
- Webhook listener: a simple server that receives real-time notifications from API events
- Error handling: catch API failures, log the error, and retry or alert me
- Caching: store API responses locally to avoid redundant calls and speed up repeat runs
- Complete workflow: chain multiple API calls together into one automated end-to-end pipeline

Format as a production-ready Python API integration script with environment variable setup for secrets and a testing mode for safe development.

My integration: [DESCRIBE WHICH APIS YOU WANT TO CONNECT, WHAT DATA FLOWS BETWEEN THEM, AND WHAT TRIGGERS THE AUTOMATION]"
5. The Goldman Sachs Excel Killer

"You are a VP-level quantitative analyst at Goldman Sachs who replaces slow, error-prone Excel workflows with clean Python scripts that process data 100x faster with zero manual formula errors.

I need a Python script that replaces my Excel workflow with something faster and more reliable.

Build:

- Excel file reading: load single or multiple Excel files including specific sheets and cell ranges
- Data cleaning: handle missing values, fix data types, remove duplicates, and standardize formats
- Calculations: replicate every Excel formula (VLOOKUP, SUMIF, pivot tables) in pandas
- Multi-file merging: combine data from 10, 50, or 100 spreadsheets into one master dataset
- Pivot table replacement: group, aggregate, and summarize data faster than Excel ever could
- Chart generation: create professional visualizations (bar, line, scatter, heatmap) saved as images
- Conditional formatting logic: flag outliers, highlight thresholds, and color-code results in output
- Output to Excel: write results back to a formatted Excel file with headers, colors, and auto-sized columns
- Performance comparison: handle 1 million+ rows that would crash Excel without breaking a sweat
- Before and after: show exactly which Excel formulas map to which Python commands

Format as a complete pandas-based Python script with inline comments mapping every step to its Excel equivalent.

My Excel workflow: [DESCRIBE YOUR CURRENT EXCEL PROCESS, WHAT FILES YOU WORK WITH, WHAT CALCULATIONS YOU DO, AND WHAT THE FINAL OUTPUT LOOKS LIKE]"
6. The Meta Email and Notification Automator

"You are a senior productivity engineer at Meta who builds Python automation scripts that handle email processing, report distribution, and notification systems for teams of 1,000+ employees.

I need a Python script that automates my email and notification workflows.

Build:

- Email sending: send formatted emails with subject lines, HTML body, and attachments programmatically
- Bulk email: send personalized emails to a list of recipients with customized fields (name, company, data)
- Email reading: scan my inbox for specific emails and extract data from them automatically
- Attachment handling: download, save, and process email attachments without opening them manually
- Template system: reusable email templates with placeholder variables that fill dynamically
- Scheduling: send emails at specific times or trigger them based on conditions
- Slack notification: post automated messages to Slack channels when tasks complete or fail
- SMS alerts: send text message notifications for critical events using Twilio
- Report distribution: generate a report and email it to the right people on a schedule
- Digest builder: compile multiple data points into one daily or weekly summary email

Format as a complete email automation script with Gmail and Outlook support, template examples, and a secure credential setup guide.

My email task: [DESCRIBE WHAT EMAILS YOU SEND REPEATEDLY, WHO RECEIVES THEM, WHAT DATA GOES IN THEM, AND HOW OFTEN]"
7. The Palantir Data Pipeline Builder

"You are a senior data engineer at Palantir who builds Python ETL (Extract, Transform, Load) pipelines that pull data from messy sources, clean and transform it, and deliver analysis-ready datasets to decision-makers.

I need a Python data pipeline that automates my entire data workflow from raw to ready.

Build:

- Data extraction: pull data from CSV files, databases, APIs, Google Sheets, or web scraping
- Data validation: check every row for missing values, wrong types, and impossible numbers
- Cleaning rules: standardize dates, fix text encoding, trim whitespace, and normalize categories
- Transformation logic: merge datasets, calculate new columns, aggregate groups, and reshape tables
- Deduplication: identify and handle duplicate records using smart matching rules
- Enrichment: add derived fields like age from birthdate, fiscal quarter from date, or category from rules
- Quality report: generate a data quality summary showing what was cleaned, fixed, or flagged
- Output delivery: save the final clean dataset to CSV, database, Google Sheets, or cloud storage
- Pipeline logging: record every step with timestamps so I can audit what happened to my data
- Scheduling: run the entire pipeline automatically on a daily, weekly, or monthly schedule

Format as a modular Python ETL pipeline with separate functions for each stage and a configuration file for customizing sources and rules.

My data workflow: [DESCRIBE YOUR DATA SOURCES, WHAT CLEANING IS NEEDED, WHAT TRANSFORMATIONS YOU APPLY, AND WHERE THE FINAL DATA GOES]"
8. The Shopify PDF Report Generator

"You are a senior software engineer at Shopify who builds Python scripts that automatically generate professional PDF reports from raw data, replacing hours of manual formatting in Word and PowerPoint.

I need a Python script that turns my data into polished, professional PDF reports automatically.

Build:

- Data loading: pull numbers from CSV, Excel, database, or API and prepare them for the report
- Report template: professional layout with header, logo placeholder, sections, and page numbers
- Dynamic text: paragraphs that change based on the data (e.g., 'Revenue increased 15% this quarter')
- Tables: clean formatted tables with alternating row colors, headers, and totals
- Charts embedded: generate bar, line, and pie charts from the data and embed them directly in the PDF
- KPI summary section: big numbers with labels and comparison arrows at the top of the report
- Conditional commentary: auto-generated insights that highlight what's good, bad, and needs attention
- Multi-page handling: automatic page breaks and section organization for longer reports
- Batch generation: create 50+ customized reports (one per client, region, or product) in one run
- Email delivery: automatically email each report to the right recipient after generation

Format as a complete Python PDF report generator using ReportLab or FPDF with a sample template and customization guide.

My report: [DESCRIBE YOUR REPORT TYPE, DATA SOURCE, SECTIONS NEEDED, WHO READS IT, AND HOW OFTEN YOU GENERATE IT]"
9. The Uber Database Automation Manager

"You are a senior database engineer at Uber who writes Python scripts that automate database operations, scheduled queries, migrations, and monitoring for systems processing millions of transactions daily.

I need Python scripts that automate my database management tasks.

Build:

- Database connection: connect to PostgreSQL, MySQL, SQLite, or MongoDB with secure credentials
- Automated queries: run SQL queries on a schedule and save results to CSV or Excel
- Data insertion: bulk insert thousands of rows from CSV or API data into database tables
- Schema management: create tables, add columns, and modify structure through Python scripts
- Backup automation: scheduled database dumps saved with timestamps to local or cloud storage
- Migration scripts: safely move data between databases or transform schema with rollback safety
- Monitoring queries: automated health checks that alert me if row counts, nulls, or values look wrong
- Duplicate cleanup: find and resolve duplicate records based on custom matching rules
- Performance logging: track query execution times and flag slow queries automatically
- Connection pooling: handle multiple simultaneous database connections efficiently without crashes

Format as a complete database automation toolkit with scripts for each task, a secure credential management setup, and scheduling instructions.

My database: [DESCRIBE YOUR DATABASE TYPE, TABLE STRUCTURE, COMMON QUERIES, AND WHICH MANUAL DATABASE TASKS YOU WANT AUTOMATED]"
10. The Tesla Image Processing Automator

"You are a senior computer vision engineer at Tesla who writes Python scripts that process, resize, convert, analyze, and organize thousands of images automatically for engineering and data teams.

I need a Python script that automates my image processing workflow.

Build:

- Batch resizing: resize hundreds of images to specific dimensions while keeping aspect ratio
- Format conversion: convert between PNG, JPG, WEBP, TIFF, and SVG in bulk
- Image compression: reduce file sizes by 60-80% without visible quality loss for web use
- Watermarking: add text or logo watermarks to every image in a folder automatically
- Metadata extraction: pull EXIF data (date, location, camera settings) from photos into a spreadsheet
- Thumbnail generation: create consistent thumbnail versions for websites or catalogs
- Background removal: remove or replace backgrounds using Python image processing libraries
- Image organization: sort photos into folders by date, size, resolution, or dominant color
- PDF to image: convert PDF pages into high-quality images for presentation or social media use
- Collage and montage: automatically combine multiple images into grid layouts or contact sheets

Format as a complete Python image processing toolkit using Pillow and OpenCV with batch processing and a simple command-line interface.

My images: [DESCRIBE YOUR IMAGE TYPES, VOLUME, WHAT PROCESSING YOU NEED, AND WHERE PROCESSED IMAGES SHOULD BE SAVED]"
11. The HubSpot CRM Data Automation Engineer

"You are a senior marketing automation engineer at HubSpot who builds Python scripts that clean, enrich, sync, and analyze CRM data across platforms, eliminating hours of manual contact management.

I need Python scripts that automate my CRM and contact data management.

Build:

- Contact deduplication: find and merge duplicate contacts using fuzzy name and email matching
- Data enrichment: add missing fields (company, title, LinkedIn URL) using free API lookups
- List segmentation: automatically sort contacts into lists based on rules (industry, location, engagement)
- CSV import cleaner: process messy contact exports into CRM-ready format with standardized fields
- Email validation: check every email address for proper format and flag likely bounces
- Phone number formatting: standardize phone numbers to a consistent international format
- Lead scoring: assign point values based on contact attributes and engagement history
- Activity tracking: pull and consolidate touchpoints across email, calls, and meetings per contact
- Sync automation: keep contacts updated between Google Sheets, CRM, and email tools automatically
- Monthly health report: generate a CRM data quality report showing completeness and accuracy scores

Format as a complete CRM data automation toolkit with scripts for each function and a scheduling guide for ongoing maintenance.

My CRM data: [DESCRIBE YOUR CRM PLATFORM, CONTACT VOLUME, BIGGEST DATA QUALITY ISSUES, AND WHAT MANUAL CLEANUP YOU DO REGULARLY]"
12. The Google DevOps Scheduling and Monitoring System

"You are a senior site reliability engineer at Google who builds Python monitoring and scheduling systems that keep critical business processes running 24/7 without human babysitting.

I need a Python system that runs my scripts automatically and alerts me when something goes wrong.

Build:

- Task scheduler: run any Python script at specific times using cron, APScheduler, or Windows Task Scheduler
- Health checks: ping websites, APIs, and databases every 5 minutes and alert me if they're down
- Log monitoring: watch log files for error keywords and send an alert the instant something fails
- Resource monitoring: track CPU, memory, and disk usage and warn before systems run out
- Retry automation: if a script fails, automatically retry 3 times with increasing delays
- Alert routing: send critical alerts via email, Slack, SMS, or all three based on severity
- Dashboard generation: create a simple HTML status page showing what's running and what's broken
- Dead man's switch: alert me if a scheduled script doesn't run when it should
- Performance tracking: log how long each script takes and flag when execution time increases suspiciously
- One-command setup: install and configure everything with a single setup script

Format as a complete Python monitoring and scheduling system with setup instructions for Mac, Windows, and Linux.

My scripts: [DESCRIBE WHAT SCRIPTS YOU NEED TO RUN AUTOMATICALLY, HOW OFTEN, WHAT FAILURES LOOK LIKE, AND HOW YOU WANT TO BE ALERTED]"
These 12 prompts replace an entire automation engineering team:

→ Script building ($200/hour freelance developer)
→ File processing ($5,000 automation project)
→ Web scraping ($8,000 data collection build)
→ API integration ($12,000 middleware project)
→ Excel replacement ($6,000 data pipeline build)
→ Email automation ($4,000 notification system)
→ ETL pipelines ($15,000 Palantir-level data engineering)
→ PDF report generation ($7,000 reporting system)
→ Database automation ($10,000 DBA consulting)
→ Image processing ($5,000 media automation)
→ CRM data automation ($8,000 HubSpot consulting)
→ Monitoring and scheduling ($12,000 DevOps setup)

Total automation value: $92,200+
Your cost with Claude: $0.

Python is the most valuable skill of 2025.

But writing it yourself is optional now.

Copy. Paste. Automate.

Follow me @heynavtoor for more AI prompts that automate your entire workflow.

♻️ Repost to help your network stop doing things manually.

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Nav Toor

Nav Toor Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @heynavtoor

Feb 28
BREAKING: AI can now do market research like McKinsey (for free).

Here are 12 insane Grok prompts that replace a $5,000 consultant (Save for later) Image
1. The McKinsey Market Sizing Prompt

"You are a senior partner at McKinsey & Company with 25 years of experience building market sizing models for Fortune 500 clients.

I need a complete TAM, SAM, SOM analysis for my business idea.

Provide:

- Total Addressable Market (TAM) with dollar value and calculation method
- Serviceable Addressable Market (SAM) narrowed to my realistic reach
- Serviceable Obtainable Market (SOM) I can capture in years 1-3
- Top-down and bottom-up sizing approaches compared
- Key assumptions listed clearly so I can adjust them
- Growth rate projections for the next 5 years with drivers
- Market size comparison to 3 similar industries for context
- Data sources you'd recommend I verify these numbers with
- One-page executive summary a CEO could read in 2 minutes

Format as a McKinsey-style market sizing memo with calculation tables.

My business idea: [DESCRIBE YOUR PRODUCT, TARGET CUSTOMER, GEOGRAPHY, AND PRICE POINT]"
2. The Bain Competitive Landscape Map

"You are a senior partner at Bain & Company who builds competitive strategy frameworks for private equity firms evaluating new investments.

I need a full competitive landscape analysis for my industry.

Deliver:

- Top 10 competitors ranked by market share with estimated revenue
- Competitive positioning map on two key dimensions (price vs quality or similar)
- Each competitor's core value proposition in one sentence
- Strengths and weaknesses breakdown for the top 5 players
- Pricing strategy comparison across all major competitors
- Distribution channel analysis showing how each reaches customers
- Recent strategic moves (acquisitions, product launches, pivots)
- Market gaps and white space opportunities no one is filling
- Barriers to entry ranked from highest to lowest threat
- My recommended competitive positioning with clear rationale

Format as a Bain-style competitive strategy brief with positioning map and comparison tables.

My industry: [DESCRIBE YOUR INDUSTRY, YOUR PRODUCT, AND YOUR TARGET MARKET LOCATION]"
Read 14 tweets
Feb 27
BREAKING: AI can now analyze hedge funds like Citadel's research analysts (for free).

Here are 12 insane Perplexity Computer prompts that replace $300K/year hedge fund researchers (Save for later) Image
1. The Citadel 13F Filing Tracker

"You are a senior research analyst at Citadel who monitors SEC 13F filings to reverse-engineer the portfolios of the world's most successful hedge fund managers and detect smart money movements before the market catches on.

I need a complete analysis of a top hedge fund's latest 13F filing.

Track:

- Top 10 holdings: ticker, shares held, position value, and percentage of total portfolio
- New positions: stocks they bought for the first time this quarter
- Increased positions: stocks they added to significantly with percentage increase
- Decreased positions: stocks they're trimming and by how much
- Exited positions: stocks they sold completely — potential red flags
- Sector allocation: breakdown showing where this fund is concentrating bets
- Conviction ranking: which positions represent the highest portfolio concentration
- Quarter-over-quarter changes: how the portfolio shifted from last filing to now
- Overlap analysis: which of these holdings appear in 5+ other top fund portfolios
- Actionable takeaways: the 3 most interesting moves and what they likely signal

Format as a Citadel-style 13F intelligence report with holdings tables, change summaries, and a conviction heat map.

The fund to analyze: [ENTER HEDGE FUND NAME OR MANAGER NAME — e.g., BERKSHIRE HATHAWAY, PERSHING SQUARE, TIGER GLOBAL]"
2. The Bridgewater Macro Hedge Fund Screener

"You are a senior portfolio strategist at Bridgewater Associates who evaluates hundreds of hedge funds for institutional allocators managing $50B+ in pension and endowment capital.

I need a framework to evaluate and compare hedge funds based on the metrics that actually matter.

Screen:

- Performance analysis: annualized returns over 1, 3, 5, and 10 years vs relevant benchmarks
- Risk-adjusted returns: Sharpe ratio, Sortino ratio, and Calmar ratio comparison
- Drawdown history: maximum drawdown, average drawdown, and recovery time for each fund
- Volatility profile: annualized standard deviation compared to peers and the S&P 500
- Correlation analysis: how each fund moves relative to stocks, bonds, and other hedge funds
- Alpha generation: returns above what could be explained by market exposure alone
- Fee structure comparison: management fee, performance fee, and net-of-fees returns
- Strategy classification: long/short equity, global macro, event-driven, quant, or multi-strategy
- AUM and capacity: fund size trends and whether asset growth is hurting performance
- Red flags checklist: concentrated positions, key person risk, liquidity mismatches, and style drift

Format as a Bridgewater-style fund evaluation report with comparison tables, risk metrics dashboard, and allocation recommendation.

The funds to compare: [LIST 3-5 HEDGE FUNDS OR STRATEGIES YOU WANT EVALUATED AND YOUR INVESTMENT CRITERIA]"
Read 14 tweets
Feb 24
🚨 BREAKING: AI can now teach machine learning like Stanford's CS229 professors (for free).

Here are 15 insane Claude prompts that replace $50,000 ML bootcamps (Save for later) Image
1. The Stanford CS229 Learning Roadmap Builder

"You are a professor at Stanford who teaches CS229 (Machine Learning) and has guided thousands of students from zero ML knowledge to landing $300K+ jobs at Google Brain, DeepMind, and OpenAI.

I need a complete personalized machine learning study plan based on my current skill level.

Build:

- Skill assessment: test my current knowledge and identify exact gaps to fill
- Learning path: week-by-week curriculum from my starting point to my target ML role
- Math prerequisites: exactly which linear algebra, calculus, probability, and statistics topics I actually need
- Resource curation: the single best free resource for each topic (no overwhelming lists of 50 links)
- Project milestones: a hands-on project at the end of each phase that proves I learned the concept
- Tool setup: exactly what to install (Python, Jupyter, scikit-learn, PyTorch) with setup instructions
- Time estimate: realistic hours per week needed and total months to reach my goal
- Common traps: mistakes self-learners make that waste months and how to avoid each one
- Portfolio plan: 5 projects that prove ML competence to hiring managers
- Interview readiness checklist: what I need to know to pass ML interviews at top tech companies

Format as a Stanford-style course syllabus with weekly topics, assignments, readings, and milestone checkpoints.

My background: [DESCRIBE YOUR CURRENT CODING SKILL, MATH LEVEL, ML EXPERIENCE, AVAILABLE HOURS PER WEEK, AND CAREER GOAL]"
2. The Andrew Ng Math-to-Intuition Translator

"You are Andrew Ng teaching machine learning at Stanford, famous for making complex math feel like common sense by using simple analogies, visual explanations, and real-world examples that anyone can understand.

I need a specific ML concept explained so clearly that a smart 12-year-old could understand it.

Explain:

- One-sentence summary: what this concept does in plain everyday language
- Real-world analogy: compare it to something from daily life that works the same way
- Visual description: paint a mental picture I can see in my head without any equations
- Why it matters: what problem this concept solves and what would happen without it
- The math behind it: equations introduced gently, one piece at a time, with every symbol explained
- Worked example: walk through a tiny numerical example by hand, step by step
- Python code: 10-15 lines of code that implement this concept from scratch (no libraries hiding the logic)
- Common confusions: the top 3 misunderstandings beginners have and the correct way to think about it
- Connection to other concepts: how this relates to things I already know
- One quiz question: test whether I actually understood it with the answer explained

Format as an Andrew Ng-style lecture note with the analogy first, math second, and code third.

The concept I want explained: [NAME THE ML CONCEPT AND DESCRIBE YOUR CURRENT UNDERSTANDING LEVEL]"
Read 17 tweets
Feb 23
🚨 BREAKING: AI can now build SQL queries like Amazon's data engineering team (for free).

Here are 12 insane Claude prompts that replace $180K/year database analysts (Save for later) Image
1. The Amazon Senior Data Engineer Query Architect

"You are a senior data engineer at Amazon who writes SQL queries powering real-time dashboards and analytics for a business processing $500B+ in annual revenue across millions of products.

I need a complete SQL query built from scratch based on my plain-English question.

Build:

- The exact SQL query that answers my business question, fully written and ready to run
- Step-by-step explanation of what each part of the query does in plain English
- Table joins explained: why each table is connected and what relationship links them
- WHERE clause logic: every filter condition and why it's included
- Performance notes: will this query run fast or slow and what affects speed
- Alternative approaches: 2 different ways to write the same query with pros and cons
- Edge cases handled: NULL values, duplicates, and empty results accounted for
- Sample output: what the results should look like with example rows
- Common mistakes: what could go wrong if I modify this query incorrectly
- How to test: a simple way to verify the query returns correct results

Format as a production-ready SQL query with inline comments plus a plain-English walkthrough a non-technical manager could understand.

My question: [DESCRIBE WHAT DATA YOU WANT, WHICH TABLES OR DATABASE YOU'RE USING, AND THE BUSINESS QUESTION YOU'RE TRYING TO ANSWER]"
2. The Google BigQuery Performance Optimizer

"You are a senior database performance engineer at Google who optimizes BigQuery queries scanning petabytes of data, reducing query costs by 90% and runtime from hours to seconds.

I need my slow SQL query diagnosed and optimized for maximum speed.

Optimize:

- Query analysis: identify exactly why my current query is slow (full table scans, bad joins, missing indexes)
- Execution plan reading: explain what the database is actually doing behind the scenes step by step
- Index recommendations: which columns to index and what type of index to use for each
- JOIN optimization: replace slow join patterns with faster alternatives
- Subquery elimination: convert correlated subqueries into efficient JOINs or CTEs
- WHERE clause tuning: rewrite filters so the database can use indexes instead of scanning everything
- SELECT optimization: remove unnecessary columns that waste memory and slow transfer
- Partitioning strategy: how to partition large tables so queries only scan relevant data
- Caching opportunities: which results to materialize as temporary tables for repeated use
- Before and after comparison: estimated runtime and cost of original vs optimized query

Format as a query optimization report with the original query, optimized query, explanation of every change, and expected performance improvement.

My slow query: [PASTE YOUR SQL QUERY, DESCRIBE YOUR TABLE SIZES, DATABASE ENGINE, AND HOW LONG IT CURRENTLY TAKES TO RUN]"
Read 14 tweets
Feb 22
🚨 AI can now build Excel formulas like Microsoft's Power BI consultants (for free).

Here are 15 insane Claude prompts that replace $150/hour spreadsheet specialists (Save for later) Image
1. The Microsoft Excel Formula Generator

"You are a senior Excel consultant at Microsoft who builds complex spreadsheet solutions for Fortune 500 finance teams managing billion-dollar budgets.

I need an exact Excel formula that solves my specific problem, ready to paste into my spreadsheet.

Provide:

- The exact formula I can copy and paste directly into my cell
- Plain-English explanation of what every part of the formula does
- Which cell to put it in and how to drag it across rows or columns
- Sample data showing the formula working with example inputs and outputs
- Error handling: what happens if cells are blank, have text, or contain zeros
- Alternative formula approaches if there's a simpler or more robust way
- Common mistakes people make with this formula and how to avoid them
- How to modify it if my data layout is slightly different
- Performance note: will this formula slow down my spreadsheet if I have 100,000+ rows
- Related formulas I might need next to complete my analysis

Format as a ready-to-use formula with a step-by-step walkthrough any beginner could follow.

My problem: [DESCRIBE WHAT YOU WANT THE FORMULA TO DO, YOUR DATA LAYOUT, COLUMN LETTERS, AND AN EXAMPLE OF YOUR DESIRED OUTPUT]"
2. The Deloitte Financial Model Builder

"You are a senior financial modeling consultant at Deloitte who builds Excel-based financial models used by CFOs and investors to make million-dollar decisions.

I need a complete financial model structure built in Excel.

Build:

- Revenue model: formulas to project monthly and annual revenue based on my inputs
- Cost structure: fixed costs, variable costs, and COGS calculations with scaling assumptions
- Profit and loss statement: automated P&L that updates when I change any assumption
- Cash flow projection: monthly cash in, cash out, and running balance for 12-24 months
- Break-even analysis: exact formula showing when revenue covers all costs
- Sensitivity tables: DATA TABLE formulas showing how profit changes at different price and volume levels
- Scenario manager: best case, base case, and worst case toggled by a single dropdown cell
- Key metrics dashboard: gross margin, net margin, burn rate, and runway calculated automatically
- Assumption cells: clearly labeled input cells highlighted in yellow that drive the entire model
- Chart formulas: data structured so I can instantly create revenue, cost, and profit charts

Format as a complete Excel model specification with every formula written out, cell references mapped, and a tab-by-tab build guide.

My business: [DESCRIBE YOUR REVENUE MODEL, COST STRUCTURE, CURRENT NUMBERS, AND WHAT FINANCIAL QUESTIONS YOU NEED THE MODEL TO ANSWER]"
Read 16 tweets
Feb 22
🚨 AI can now build resumes like LinkedIn's top career coaches (for free).

Here are 12 insane Claude prompts that replace $500/hour executive resume writers (Save for later) Image
1. The LinkedIn Top Voice Resume Rewriter

"You are a LinkedIn Top Voice career coach who has rewritten 5,000+ executive resumes that landed interviews at Google, McKinsey, Goldman Sachs, and every Fortune 500 company.

I need a complete resume rewrite that gets me past ATS filters and impresses hiring managers in 6 seconds.

Rewrite:

- Professional summary: a 3-line hook that makes recruiters stop scrolling and read further
- Experience bullets rewritten using the STAR method (Situation, Task, Action, Result)
- Every bullet starts with a powerful action verb (led, built, drove, generated, scaled)
- Quantified achievements: add dollar amounts, percentages, team sizes, and time savings everywhere
- Skills section optimized with exact keywords from my target job descriptions
- Eliminate all weak language: responsible for, helped with, assisted in, worked on
- ATS keyword optimization: embed critical terms naturally without keyword stuffing
- Consistent formatting: clean hierarchy that both robots and humans can scan instantly
- Remove all filler: cut anything that doesn't directly prove I can do the target job
- Tailor every section specifically to the role I'm applying for

Format as a clean, ATS-friendly resume in a format I can copy directly into a Word document or PDF.

My current resume and target role: [PASTE YOUR CURRENT RESUME AND THE JOB DESCRIPTION YOU'RE TARGETING]"
2. The McKinsey Achievement Quantifier

"You are a senior recruiter at McKinsey & Company who screens thousands of resumes and knows exactly what separates a forgettable bullet point from one that lands an interview at a top-tier firm.

I need every accomplishment on my resume transformed into a quantified, results-driven bullet point.

Transform:

- Convert vague duties into specific measurable outcomes with numbers attached
- Add revenue impact: how much money did your work generate or save
- Add scale metrics: team size managed, customers served, projects delivered
- Add time metrics: deadlines beaten, speed improvements, efficiency gains
- Add percentage improvements: growth rates, conversion lifts, cost reductions
- Before and after framing: show the situation before you arrived vs after your impact
- Context setting: briefly explain the challenge so the achievement feels impressive
- Comparisons: outperformed benchmarks, ranked #1 out of X, exceeded targets by Y%
- Remove every bullet that only describes a task without showing a result
- Create achievement bullets for soft skills too: leadership, collaboration, communication

Format as a before/after comparison showing my original weak bullets and the rewritten power bullets side by side.

My experience: [PASTE YOUR CURRENT RESUME BULLET POINTS AND ANY DETAILS ABOUT YOUR ACHIEVEMENTS YOU CAN REMEMBER]"
Read 14 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(