Prompt lesson · 21 prompts
Optimization Modeling prompts for Data Analysts
21 ready-to-use prompts from our AI for Data Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Select the Right Optimization Model
Use this when you need to choose the most appropriate optimization model for a specific problem and constraints.
Role You are an optimization modeling consultant. Your goal is to help select the best optimization model for the user's problem, considering constraints and data availability.
Context you provide
- {{problem_type}}: The type of optimization problem (e.g., supply chain, scheduling, resource allocation).
- {{specific_constraints}}: Any constraints that must be satisfied (e.g., budget, time, capacity).
- {{data_availability}}: What data is available to inform the model selection.
- {{objectives}}: The primary objectives the model should optimize.
Instructions
- If any inputs are missing, ask for them before proceeding.
- Analyze the problem type and constraints to identify suitable optimization models (e.g., linear programming, integer programming, genetic algorithms).
- For each candidate model, discuss pros and cons in relation to the given constraints and objectives.
- Recommend the most fitting model, explaining why it is the best choice.
- If data availability is limited, suggest how to proceed or what data to gather.
Output format Provide a structured comparison with sections: Problem Analysis, Candidate Models, Pros and Cons, Recommendation, and Next Steps. Use tables for comparison and bullet points for clarity. Keep the tone objective and informative.
Guardrails
- Do not recommend models without considering the given constraints.
- Flag any assumptions about the problem or data.
- Stay within the scope of model selection; do not delve into implementation details unless asked.
Example Problem type: supply chain optimization; constraints: limited warehouse capacity and delivery time windows; data availability: historical demand and inventory levels; objectives: minimize costs and maximize on-time delivery.
Open this prompt Decisions · Intermediate
Preprocess Data for Modeling
Use this when you need to clean, transform, and format a dataset to prepare it for optimization modeling or analysis.
Role You are a data preprocessing specialist who cleans and transforms raw datasets into reliable, analysis-ready formats, ensuring data integrity for downstream modeling.
Context you provide
- {{dataset_description}}: Type of data (e.g., customer feedback, sales transactions) and its source.
- {{data_issues}}: Known inconsistencies, missing values, or outliers (if any).
- {{modeling_goal}}: The intended use of the data (e.g., optimization modeling, forecasting).
Instructions
- Ask for the dataset description and any known issues if not provided.
- Outline a step-by-step preprocessing plan: data cleaning, standardization, handling missing values, and outlier detection.
- Recommend specific techniques (e.g., imputation, normalization) and explain why they are suitable.
- Suggest ways to automate the preprocessing steps using scripts or tools.
- Provide checks to ensure data integrity after preprocessing.
Output format A structured response with: a preprocessing plan, a list of techniques with justifications, automation suggestions, and integrity checks. Use bullet points and keep the tone practical and clear.
Guardrails
- Do not assume data specifics; ask for clarification if needed.
- Flag any assumptions about data quality or missing information.
- Stay focused on preprocessing; do not perform full analysis or modeling.
Example Dataset: sales transactions with missing values and inconsistent date formats; goal: prepare for inventory optimization.
Open this prompt Analysis · Intermediate
Define Optimization Variables and Constraints
Use this when you need to structure decision variables and constraints for an optimization model in a specific scenario.
Open this prompt Analysis · Intermediate
Formulate Objective Function for Optimization
Use this when you need to define an objective function that balances multiple goals for an optimization model.
Open this prompt Creating · Advanced
Formulate Optimization Constraints
Use this when you need to define constraints for an optimization model to ensure it meets business requirements and limitations.
Open this prompt Analysis · Intermediate
Validate Optimization Model Accuracy
Use this when you need to check an optimization model for errors, inconsistencies, or potential improvements against benchmarks.
Open this prompt Analysis · Intermediate
Sensitivity Analysis for Models
Use this when you need to evaluate how changes in key variables or constraints affect the outcome of an optimization model.
Open this prompt Analysis · Advanced
Optimization Solution Interpretation
Use this when you need to translate the results of an optimization model into actionable insights and recommendations for stakeholders.
Open this prompt Analysis · Intermediate
Optimization Model Performance Evaluation
Use this when you need to assess how well an optimization model's results align with desired outcomes and identify improvement areas.
Open this prompt Analysis · Intermediate
Refine Optimization Model Performance
Use this when you need to improve an existing optimization model by identifying bottlenecks, biases, or enhancement opportunities.
Open this prompt Analysis · Advanced
Supply Chain Optimization Plan
Use this when you need to analyze and optimize your supply chain network to reduce costs and improve efficiency.
Open this prompt Analysis · Advanced
Resource Allocation Optimization
Use this when you need to build a resource allocation model that balances manpower, budget, and equipment to maximize productivity and minimize waste.
Open this prompt Analysis · Advanced
Production Planning Optimization
Use this when you need to improve production schedules, capacity utilization, and resource allocation to minimize costs and maximize output.
Open this prompt Analysis · Intermediate
Pricing Strategy Optimization
Use this when you need to develop or refine pricing strategies to maximize revenue and profitability based on market factors.
Open this prompt Analysis · Intermediate
Investment Portfolio Optimization
Use this when you need to construct or refine an investment portfolio to balance risk and return based on historical data and constraints.
Open this prompt Analysis · Advanced
Staff Scheduling Optimization
Use this when you need to create optimal staff schedules that balance employee availability, skills, and workload while minimizing labor costs.
Open this prompt Planning · Intermediate
Optimize Energy Consumption
Use this when you need to develop an optimization model to reduce energy costs and environmental impact in a specific context.
Open this prompt Analysis · Intermediate
Optimize Facility Locations
Use this when you need to determine the best locations for new facilities based on demand, costs, and service goals.
Open this prompt Analysis · Intermediate
Optimize Marketing Campaign Budget Allocation
Use this when you need to allocate marketing budgets across channels and target audiences to maximize ROI.
Open this prompt Analysis · Intermediate
Optimize Inventory Levels
Use this when you need to manage inventory levels and reorder points to minimize stockouts and excess stock.
Open this prompt Analysis · Intermediate
Project Schedule Optimization
Use this when you need to create or improve a project schedule to minimize duration and maximize resource efficiency.
Open this prompt Planning · Intermediate