Data & Operations

Excel/SQL Logic

Explain how to create a formula or query that finds [DATA GOAL, e.g., monthly churn rate] from a table named [TABLE NAME]. Provide the logic first, then the code snippet.

Trend Summarizer

Analyze the following raw data points and identifying the top 3 trends: [PASTE DATA]. Explain why these trends are significant for a business in the [INDUSTRY] sector.

KPI Dashboard Planner

I want to build a dashboard for [DEPARTMENT]. Suggest the 5 most important KPIs we should track daily to ensure we are hit our goal of [GOAL].

Inventory Reorder Logic

Provide a logic/formula for a retail business to determine the 'Reorder Point' for [PRODUCT] considering lead time and safety stock.

Web Scraping Logic

Explain a technical logic to extract [DATA FIELDS] from a website using Python. Suggest a specific library (e.g., BeautifulSoup) and a method to handle pagination.

Python CSV Cleaner

Write a Python script using Pandas to load a CSV named [FILE], remove rows with missing values in the [COLUMN] column, and save the result to a new file.

Process SOP (Standard Operating Procedure)

Write a step-by-step SOP for a new Virtual Assistant to handle [TASK, e.g., processing refund requests]. Include what to do if the request doesn't meet our criteria.

Risk Assessment

Act as an Operations Consultant. Review this project plan: [PLAN SUMMARY]. List 5 potential bottlenecks and provide a mitigation strategy for each.

Meeting Agenda

Create a 30-minute lean meeting agenda for a [DEPARTMENT] sync. Focus on [PROJECT UPDATE], [ROADBOCKS], and [NEXT STEPS] only. Ensure it is action-focused.

Workflow Automation Plan

I want to automate the flow between [APP 1] and [APP 2] when [TRIGGER happens]. Suggest a Zapier or Make.com logic to handle this including a data formatting step.

API Integration Flow

Map out an API integration flow between [SERVICE A] and [SERVICE B]. Identify the primary endpoints needed and suggest how to handle authentication (e.g., OAuth2).

Cloud Cost Audit

Generate a 10-point checklist for auditing our [AWS/Azure/GCP] cloud spend. Focus on identifying underutilized resources and suggest 3 ways to reduce monthly costs.

Data Privacy Audit

Generate a 10-point checklist for a small business to audit their basic data privacy compliance (GDPR/basic security) for [CRITICAL DATA TYPE].

Supplier Audit Review

Draft a polite email to a supplier, [SUPPLIER NAME], requesting an update on their quality compliance certification for the upcoming year.

Sentiment Tagger

Act as a Data Analyst. Categorize these 10 customer feedback snippets into: 'Positive', 'Neutral', or 'Negative' and identify the primary theme for each: [PASTE FEEDBACK].

Cybersecurity Checklist

Create a basic 5-step cybersecurity hygiene checklist for non-technical employees working from home. Focus on passwords, VPNs, and identifying phishing emails.