100 Best Claude Excel Data Analysis Prompts for Car Dealerships

Direct Answer

The best Claude prompts for Excel data analysis for car dealerships are practical, actionable tasks that turn Excel data into clear business insights. They cover sales trends, inventory aging, profitability by region, financing impact, and service metrics, with explicit outputs and formats to guide Claude results. Use placeholders to customize datasets and regions.

Introduction

This page is a practical prompt library for Excel data analysis tailored to car dealerships. It helps analysts turn dealership data into actionable insights using Claude AI prompts.

The prompts are designed for analysts, managers, and operations teams who want repeatable, auditable analyses directly in Excel-enabled workflows.

How to Use These Claude Prompts

• Replace placeholders like [region], [model], and [date range] with your actual data fields.
• Add constraints such as time frames, regions, or performance targets to focus results.
• Request outputs in structured formats like tables and bullet-point summaries to support reporting.
• Ask Claude to produce a narrative explanation of the data insights to accompany each table.
• Verify outputs against your source data and adjust prompts if data definitions differ in your dataset.

100 Best Claude Excel Data Analysis Prompts for Car Dealerships

1. Sales trend by month: You are a data analyst for a car dealership. Task: Analyze monthly sales data in a provided Excel dataset. Context: The workbook includes columns Date, Vehicle_ID, Make, Model, MSRP, Discount, Sold_Price, and Region. Output: A 12-month trend chart description, top 3 growth months, and a narrative explaining drivers. Output format: bullet list and a short executive summary. Constraints: Use at most two visuals descriptions and avoid external links.
2. Top models by region: Role: Market analyst for a multi-location dealership network. Task: Identify top selling models by region from an Excel sheet with columns Region, Model, Units, Revenue, and Date. Context: Data spans 24 months. Output: List top 3 models per region with 1) units and revenue, 2) year-over-year change, and 3) recommended actions. Output format: table and short insights. Constraints: Exclude discontinued models; focus on current year data.
3. Inventory aging heatmap: You are an inventory optimization consultant. Task: Create an aging analysis for dealership inventory using columns Vehicle_ID, Stock_Status, Age_days, MSRP, Cost, Location. Context: 90 days aging threshold, target stock turn of 6. Output: Heatmap categories and recommended actions for aging buckets. Output format: structured list with color labels (red, orange, yellow, green). Constraints: Propose actions per bucket.
4. Gross profit per unit: Role: Financial analyst in automotive retail. Task: Calculate gross profit per unit and gross margin by model using an Excel dataset with Vehicle_ID, Model, Cost, Sold_Price, Quantity, and Region. Context: Provide per-model profitability analysis for the last 12 months. Output: table of Model, Units Sold, Gross Profit, Gross Margin, and 3 recommended profitability improvements. Output format: table + brief narrative.
5. Promotional ROI model: You are a promotions analyst. Task: Build a ROI model for vehicle promotions using columns Promotion_ID, Start_Date, End_Date, Campaign_Cost, Discount, Units_Sold, and Region. Context: Include scenario analysis for different discount levels. Output: ROI per campaign, payback period, and recommended budget rules. Output format: table and executive summary.
6. Financing mix impact: Role: Automotive finance analyst. Task: Analyze how financing mix affects profitability using fields Finance_Product, APR, Units, Revenue_per_unit, and Region. Context: Compare promos with and without low-interest financing. Output: 2-page summary describing revenue impact, bad debt risk, and recommended financing strategies. Output format: narrative + bullet list.
7. Service revenue contribution: You are a dealership operations analyst. Task: Determine service department revenue contribution using fields Service_Type, Units, Revenue, Labor_Hours, and Date. Context: Distinguish fixed vs variable costs. Output: share of total revenue, trend by month, and 3 optimization ideas. Output format: bullet list and small chart descriptions.
8. Warranty vs retail returns: Role: Warranty analytics specialist. Task: Compare warranty costs vs retail returns using columns Warranty_Claim, Model, Claim_Amount, Sold_Date, and Region. Context: 12-month window. Output: ratio of warranty cost to revenue, top 3 cost drivers, and mitigation steps. Output format: table + narrative.
9. Vehicle aging cohorts: You are a data scientist for a dealer group. Task: Segment inventory into aging cohorts (0-30, 31-60, 61-90, 91+ days) using columns Vehicle_ID, Age_days, Model, Region, MSRP. Context: Provide cohort-based recommendation for promotions. Output: cohort table and action list per cohort. Output format: table + action bullets.
10. Dealership mix optimization: Role: Strategy analyst. Task: Optimize dealership mix across regions using data columns Region, Revenue, Units, Model, and Margin. Context: 3-year horizon with seasonal effects. Output: recommended regional mix and 5 actions to implement. Output format: structured report with bullet recommendations.
11. Dealership profitability map: You are a business intelligence analyst. Task: Create a profitability map by location using Region, Location, Revenue, Costs, and Units. Context: Use 12-month data. Output: color-coded map description and top 3 loss-making locations with corrective actions. Output format: bullet list and location table.
12. Pricing elasticity test: Role: Pricing analyst. Task: Assess price elasticity by model using fields Model, Discount, Sold_Price, Demand_Signal, and Region. Context: Run two scenarios: maintain price vs 5 percent discount. Output: elasticity scores, recommended price bands, and risk notes. Output format: table + narrative.
13. Customer lifetime value: You are a CRM data scientist. Task: Compute customer lifetime value by customer_segment using fields Customer_ID, Segment, Total_Spent, Visit_Count, and Date. Context: Compare new vs returning customers. Output: LTV per segment and 2 retention actions. Output format: table + bullets.
14. Lead conversion funnel: Role: Digital marketing analyst. Task: Analyze lead-to-sale funnel using fields Lead_ID, Source, Date_Created, Date_Sold, Model, and Region. Context: 12-month window. Output: funnel stages, conversion rate by source, and 2 optimization actions. Output format: funnel diagram description and table.
15. Cost-to-serve analysis: You are a cost accountant. Task: Compute cost-to-serve by channel using fields Channel, Cost, Revenue, Units, and Region. Context: Include fixed and variable costs. Output: per-channel cost-to-serve and 3 efficiency ideas. Output format: table + narrative.
16. Inventory replenishment plan: Role: Inventory planner. Task: Generate replenishment recommendations by SKU using fields SKU, On_Hand, Reorder_Point, Lead_Time, and Region. Context: Seasonality influences demand. Output: order quantities, safety stock, and stop-loss triggers. Output format: table + action bullets.
17. Sales forecasting model: You are a forecasting analyst. Task: Build a 12-month sales forecast by Model using historical_units, seasonality, and promotions. Context: Use exponential smoothing; provide confidence intervals. Output: forecast table, interval ranges, and 2 risk factors. Output format: table + brief narrative.
18. Gross margin by region: Role: Financial controller. Task: Compute gross margin by region with fields Region, Model, Revenue, Cost_of_Goods, Units. Context: 12 months. Output: region table, trend, and 3 margin-improving actions. Output format: table + bullets.
19. Discount policy impact: You are a policy analyst. Task: Evaluate impact of discount policy changes using fields Policy_ID, Discount, Start_Date, End_Date, Units_Sold, and Region. Context: Compare before/after scenarios. Output: impact summary with 2 recommended policy tweaks. Output format: narrative + bullet list.
20. Vehicle lifecycle cost: Role: Cost analyst. Task: Compute lifecycle cost per model including purchase, financing, maintenance, and resale using fields Model, Purchase, Financing, Maintenance, Resale_Value, and Months. Context: 36-month horizon. Output: lifecycle cost per model and 2 cost-saving ideas. Output format: table + bullets.
21. Regional promotional calendar: You are a promotions planner. Task: Build a regional promotions calendar aligning with inventory and demand signals using fields Region, Month, Promotion_Type, Discount, and Units. Context: 12-month view. Output: calendar with 2-3 promotions per region. Output format: table + brief notes.
22. New vs used mix: Role: Market analyst. Task: Compare new vs used vehicle mix by region using fields Vehicle_Type, Region, Units, Revenue, and Margin. Context: 24 months. Output: split by new/used and 3 actionable suggestions. Output format: table + narrative.
23. Dealer credit risk: You are a risk analyst. Task: Assess credit risk exposure from financing portfolios using fields Finance_Product, Delinquency_Rate, Avg_Term, and Region. Context: 12 months. Output: risk score per product and mitigations. Output format: table + bullets.
24. Promote high-margin models: Role: Product strategist. Task: Identify high-margin models to push using fields Model, Margin, Units_Sold, and Region. Context: 12 months. Output: top models per region with recommended actions. Output format: table + narrative.
25. Seasonal demand forecast: You are a demand planner. Task: Forecast seasonality by region for top models using Date, Region, Model, and Unit_Demand. Context: 3 seasonal cycles. Output: seasonal index by month and 2 inventory actions. Output format: table + bullets.
26. Sales conversion timing: Role: Sales ops analyst. Task: Analyze time-to-sale from lead to sale using Lead_Tenure, Region, Model, and Source. Context: 6-month window. Output: distribution chart and two process improvements. Output format: table + narrative.
27. Dealership banner testing: You are a marketing data analyst. Task: Evaluate A/B test results for online banners affecting vehicle inquiries using fields Banner_ID, Variant, Clicks, Inquiries, and Region. Context: 4 weeks. Output: statistical significance notes and recommended banner mix. Output format: table + summary.
28. Upsell and accessory impact: Role: Merchandising analyst. Task: Measure impact of upsell accessories on average order value using fields Accessory, Price, Units_Sold, and Revenue. Context: 12 months. Output: contribution to AOV and 2 upsell recommendations. Output format: table + bullets.
29. Trade-in value accuracy: You are a data quality analyst. Task: Assess trade-in value accuracy vs actual sale price using fields TradeIn_Value, Sold_Price, Model, and Region. Context: 12 months. Output: variance metrics and data-cleaning actions. Output format: table + narrative.
30. Channel profitability by region: Role: Channel analyst. Task: Compute profitability by channel (online, showroom, third-party) and region using fields Channel, Revenue, Costs, Units, Region. Context: 12 months. Output: table with action items to improve channel mix.
31. Customer churn risk: You are a CRM data scientist. Task: Predict churn risk by customer segment using Total_Spent, Visit_Count, Last_Purchase, and Region. Context: 12 months. Output: risk scores and 2 retention actions. Output format: table + bullets.
32. Fleet sales performance: Role: Fleet sales analyst. Task: Analyze fleet sales performance by region, including units, revenue, and average deal size. Context: 24 months. Output: regional leaderboard and 3 fleet-specific tactics. Output format: table + narrative.
33. Warranty cost control: You are a cost accountant. Task: Break down warranty costs by model and defect type using fields Model, Defect, Warranty_Cost, and Units. Context: 12 months. Output: cost drivers with 3 control measures. Output format: table + bullets.
34. Rebate optimization: Role: Pricing analyst. Task: Optimize rebates by model and region using fields Model, Rebate_Amount, Units, Revenue, and Region. Context: 6-month window. Output: recommended rebate levels and expected impact. Output format: table + narrative.
35. Inventory turn rate: You are an inventory analyst. Task: Calculate inventory turnover by location using on_hand, sold_units, and average_inventory. Context: 12 months. Output: turn rate per location and 2 actions to improve. Output format: table + bullets.
36. Deal closing probability: Role: Sales analyst. Task: Build a probability model for deal closing by model and region using fields Deal_ID, Stage, Probability, and Time_to_close. Context: Pipeline of 18 months. Output: probability ladder and recommended actions. Output format: table + narrative.
37. Financing term sensitivity: You are a financial analyst. Task: Analyze sensitivity of financing term on monthly payment using fields Principal, Rate, Term_months, and Taxes. Context: 36-month financing. Output: payment scenarios and risk notes. Output format: table + bullets.
38. Dealer network benchmarking: Role: BI analyst. Task: Benchmark dealerships by key metrics (Revenue, Margin, Turns) across locations using Region, Location, Revenue, Margin, and Turns. Context: 24 months. Output: ranking with 3 improvement ideas per top decile. Output format: table + narrative.
39. Used car depreciation model: You are a forecasting analyst. Task: Model depreciation curves for used inventory by model using Age_days, Mileage, Region, and MSRP. Context: 36-month horizon. Output: depreciation forecast and 2 liquidation actions. Output format: table + bullets.
40. Promotional lift analysis: Role: Promotions analyst. Task: Measure lift from promotions on unit sales using Promotion_ID, Discount, Days_Active, Region, and Units_Sold. Context: Compare with non-promotional baseline. Output: lift percentage and 2 optimization ideas. Output format: table + narrative.
41. Delivery latency study: You are an operations analyst. Task: Analyze delivery and logistic latency impact on customer satisfaction using Region, Delivery_Time, and Satisfaction_Score. Context: 12 months. Output: latency distribution and 2 process improvements. Output format: table + bullets.
42. Cash flow forecast: Role: Treasurer. Task: Generate a 12-month cash flow forecast using revenues, costs, financing, and seasonality. Context: Include worst-case and best-case scenarios. Output: cash balance projections and 2 liquidity actions. Output format: table + narrative.
43. Brand health signals: You are a brand analyst. Task: Track brand sentiment proxies using online reviews, inquiries, and regional feedback. Context: 12 months. Output: sentiment trend and 3 brand actions. Output format: table + bullets.
44. VIP customer segmentation: Role: CRM strategist. Task: Segment VIP customers by spend and frequency using Total_Spent, Visit_Count, Recency, and Region. Context: 12 months. Output: VIP tiers and targeted offers. Output format: table + narrative.
45. Vehicle returns diagnostic: You are a quality analytics lead. Task: Diagnose reasons for vehicle returns using Return_ID, Model, Region, and Reason_Code. Context: 12 months. Output: top 3 return drivers and corrective actions. Output format: table + bullets.
46. Digital channel ROI: Role: Digital marketing analyst. Task: Calculate ROI by digital channel using Clicks, Conversions, Cost, and Revenue. Context: 12 months. Output: ROI per channel and optimization plan. Output format: table + narrative.
47. Trade-in market pricing: You are a pricing strategist. Task: Analyze trade-in price competitiveness by model and region using TradeIn_Value, Market_Value, and Volume. Context: 12 months. Output: price position and two adjustments. Output format: table + bullets.
48. Fleet utilization report: Role: Fleet operations analyst. Task: Assess fleet utilization by client and region using Fleet_ID, Hours_Rused, Revenue, and Region. Context: 12 months. Output: utilization rate and 3 utilization tactics. Output format: table + narrative.
49. Charging/stipend incentives: You are an incentives analyst. Task: Evaluate incentive effectiveness for electric models using Incentive_Amount, Units_Sold, and Region. Context: 6-month window. Output: impact analysis and 2 program refinements. Output format: table + bullets.
50. Holdback and incentives: Role: Channel finance analyst. Task: Model holdback impact on dealer profitability by region using Holdback, Revenue, Costs, and Region. Context: 12 months. Output: profitability delta and 2 negotiation points. Output format: table + narrative.
51. Damage and claims trend: You are a risk analyst. Task: Track damage claims vs claims frequency using Claim_ID, Model, Region, and Cost. Context: 12 months. Output: trend report and mitigation ideas. Output format: table + bullets.
52. Inventory obsolescence risk: Role: Inventory risk analyst. Task: Identify obsolescence risk by model and region using Age_days, Sales_velocity, and Region. Context: 18 months. Output: risk score and 3 mitigation actions. Output format: table + narrative.
53. Price waterfall analysis: You are a pricing analyst. Task: Build a price waterfall for a selected model using List_Price, Discounts, Cost, and Net_Price. Context: Single model analysis. Output: breakdown and 2 optimization recommendations. Output format: table + bullets.
54. Sales by dealership: Role: Regional sales manager. Task: Compare sales by dealership location using Location_ID, Region, Units_Sold, Revenue, and Margin. Context: 12 months. Output: leaderboard and 3 location-specific actions. Output format: table + narrative.
55. Cross-sell opportunity map: You are a merchandising analyst. Task: Identify cross-sell opportunities between vehicles and accessories using Model, Accessory, and Revenue. Context: 12 months. Output: top cross-sell pairs and 2 actions. Output format: table + bullets.
56. Delay in service cycle: Role: Service operations analyst. Task: Analyze service cycle time and its impact on customer satisfaction using Service_Type, Time_in_Service, and Satisfaction. Context: 12 months. Output: cycle-time distribution and 2 process improvements. Output format: table + narrative.
57. Warranty renewal likelihood: You are a lifecycle marketer. Task: Predict warranty renewals by model using Warranty_EndDate, Customer_ID, and Region. Context: 12 months. Output: renewal probability and 2 engagement tactics. Output format: table + bullets.
58. Referral program analysis: Role: Growth analyst. Task: Measure impact of referral programs on new buyer acquisition using Referral_ID, New_Buy, Cost, and Region. Context: 12 months. Output: ROI and optimal referral mix. Output format: table + narrative.
59. Customer sentiment by model: You are a voice of customer analyst. Task: Analyze customer sentiment scores by model using Sentiment_Score, Model, and Region. Context: 12 months. Output: sentiment leaderboard and 2 improvement ideas. Output format: table + bullets.
60. Credit line utilization: Role: Credit manager. Task: Review dealer credit line utilization by region using Line_ID, Utilization, and Region. Context: 12 months. Output: utilization insights and 2 credit policy tweaks. Output format: table + narrative.
61. Vehicle color popularity: You are a product analyst. Task: Determine color popularity by model using Color, Units_Sold, Region, and Season. Context: 18 months. Output: color ranking and 2 merchandising actions. Output format: table + bullets.
62. Upsell conversion by channel: Role: Sales ops analyst. Task: Compare upsell conversion rates by channel using Channel, Upsell_Item, Units_Sold, and Revenue. Context: 12 months. Output: channel-level insights and 2 actions. Output format: table + narrative.
63. Used car stock risk: You are a risk analyst. Task: Assess risk of aged used car stock using Age_days, Mileage, and Region. Context: 12 months. Output: risk score and 2 liquidation actions. Output format: table + bullets.
64. Pickup and delivery cost: Role: Logistics analyst. Task: Compute delivery cost per vehicle and total cost by region using Delivery_Cost, Vehicle_ID, and Region. Context: 12 months. Output: per-vehicle cost and 2 optimization ideas. Output format: table + narrative.
65. Discount leakage audit: You are a compliance analyst. Task: Audit for discount leakage by model using Discount, Net_Price, and Region. Context: 6 months. Output: leakage hotspots and 2 controls. Output format: table + bullets.
66. Green vehicle share: Role: Sustainability analyst. Task: Track share of electrified models by region using Model, Is_Electric, Units_Sold, and Region. Context: 12 months. Output: trend and 2 strategy ideas. Output format: table + narrative.
67. Dealer onboarding metrics: You are a channel operations analyst. Task: Measure onboarding time and early sales performance for new dealers using Dealer_ID, Onboard_Date, First_Sale_Date, and Region. Context: 12 months. Output: onboarding time distribution and 2 improvement tactics. Output format: table + bullets.
68. Lead source profitability: Role: Marketing analyst. Task: Determine profitability by lead source for vehicle inquiries using Source, Revenue, Cost, and Volume. Context: 12 months. Output: source ranking and 2 optimization ideas. Output format: table + narrative.
69. Customer win-back plan: You are a CRM strategist. Task: Develop a win-back plan for lapsed customers using Customer_ID, Last_Purchase, Segment, and Region. Context: 12 months. Output: campaign steps and success metrics. Output format: table + bullets.
70. Garage appointment utilization: Role: Service operations analyst. Task: Optimize appointment slots utilization using Appointment_ID, Time_Slot, Service_Type, and Region. Context: 6 months. Output: occupancy rates and 2 scheduling improvements. Output format: table + narrative.
71. Inventory by supplier: You are a procurement analyst. Task: Analyze supplier contribution to inventory using Supplier_ID, Lead_Time, Cost, and Region. Context: 12 months. Output: supplier ranking and 2 negotiation points. Output format: table + bullets.
72. Event-driven demand spike: Role: Demand planner. Task: Detect and respond to demand spikes around events using Date, Region, Model, and Units. Context: 24 months. Output: spike alerts and 2 response actions. Output format: table + narrative.
73. Performance by salesperson: You are a sales operations specialist. Task: Rank salespeople by revenue and units using Salesperson_ID, Region, Revenue, and Units. Context: 12 months. Output: top performers and 2 coaching tips. Output format: table + bullets.
74. Promotional compliance check: Role: Compliance analyst. Task: Validate promotional claims against policy using Promotion_ID, Discount, Policy, and Region. Context: 12 months. Output: compliance status and remediation steps. Output format: table + narrative.
75. Cost optimization playbook: You are a financial planner. Task: Create a cost optimization playbook across departments using Cost_Category, Amount, and Region. Context: 12 months. Output: 5 high-impact actions and owners. Output format: table + bullets.
76. Vehicle feature impact: Role: Product analyst. Task: Assess impact of feature changes on sales using Model, Feature, and Units_Sold. Context: 12 months. Output: feature scorecards and 2 recommendations. Output format: table + narrative.
77. Record-to-report efficiency: You are a finance operations analyst. Task: Measure record-to-report cycle time by month using Month, Region, and Days_to_Close. Context: 12 months. Output: efficiency trend and 2 automation ideas. Output format: table + bullets.
78. Add-on profitability: Role: Merchandising analyst. Task: Analyze add-on sales profitability using AddOn, Price, Units_Sold, and Revenue. Context: 12 months. Output: profitability per add-on and 2 pricing ideas. Output format: table + narrative.
79. Channel churn risk: You are a channel manager. Task: Predict channel churn risk using Channel, Region, Units_Sold, and Revenue. Context: 12 months. Output: risk scores and retention actions. Output format: table + bullets.
80. Aging inventory forecast: Role: Inventory planner. Task: Forecast aging inventory levels by region using Age_days, Units_On_Hand, and Region. Context: 12 months. Output: aging projections and 2 mitigation steps. Output format: table + narrative.
81. Vehicle color ROI: You are a merchandising analyst. Task: Evaluate profitability by vehicle color using Color, Model, Margin, and Region. Context: 12 months. Output: color-level ROI and 2 merchandising actions. Output format: table + bullets.
82. Test drive demand signals: Role: Experience marketing analyst. Task: Analyze test drive signups and conversion to sales using Test_Drive_ID, Region, and Model. Context: 6 months. Output: demand signal table and 2 outreach actions. Output format: table + narrative.
83. Trade-in stock aging: You are a merchandise analyst. Task: Track aged trade-ins using TradeIn_ID, Age_days, Model, and Region. Context: 12 months. Output: aging report and 2 liquidation ideas. Output format: table + bullets.
84. Promotions risk dashboard: Role: BI developer. Task: Build a promotions risk dashboard for discount abuse using Promotion_ID, Discount, Units, and Region. Context: 12 months. Output: risk flags and 2 controls. Output format: table + narrative.
85. Website inquiries by model: You are a digital analyst. Task: Break down website inquiries by model and region using Inquiries, Model, and Region. Context: 12 months. Output: inquiries leaderboard and 2 conversion actions. Output format: table + bullets.
86. Used car acquisition plan: Role: Procurement strategist. Task: Develop a used car acquisition plan by region using Region, Budget, and Desired_Mix. Context: 12 months. Output: 3 purchase buckets and 2 risk notes. Output format: table + narrative.
87. Dealer rebate leakage: You are a controls analyst. Task: Detect rebate leakage by region using Rebate_Amount, Net_Price, Units, and Region. Context: 6 months. Output: leakage hotspots and remediation steps. Output format: table + bullets.
88. Customer feedback loop: Role: CX analyst. Task: Create a closed-loop process for customer feedback by model using Feedback_ID, Rating, and Region. Context: 12 months. Output: loop stages and 2 enhancements. Output format: table + narrative.
89. Vehicle life-cycle dashboard: You are a BI specialist. Task: Build a lifecycle dashboard covering procurement, sales, service, and resale by model using multiple fields. Context: 12 months. Output: dashboard rows and 2 insights. Output format: table + bullets.
90. Regional risk map: Role: Risk manager. Task: Produce a regional risk map combining financial, operational, and market risk using Region, Metric, and Score. Context: 12 months. Output: risk tiers and 3 preventative actions. Output format: table + narrative.
91. Promotion pre-approval checklist: You are a promotions analyst. Task: Generate a pre-approval checklist for vehicle promotions using Promotion_ID, Discount, Revenue, and Region. Context: 12 months. Output: list of check items and approval steps. Output format: table + bullets.
92. Model-level demand pressure: Role: Demand planner. Task: Detect demand pressure on models using Units_Sold, Backorder, and Region. Context: 6 months. Output: pressure score and 2 mitigation actions. Output format: table + narrative.
93. Loan default risk: You are a credit risk analyst. Task: Analyze loan default risk by financing product using Product, Default_Rate, and Region. Context: 12 months. Output: risk markers and mitigations. Output format: table + bullets.
94. A/B pricing test: Role: Pricing scientist. Task: Run an A/B price test for two price points on a model using Price_A, Price_B, Units_Sold, and Region. Context: 8 weeks. Output: test results and recommended price.
95. Customer segment actions: You are a CRM strategist. Task: Create targeted actions for customer segments using Segment, Offer, and Channel. Context: 12 months. Output: 3 segment action plans and expected impact. Output format: table + narrative.
96. Sales seasonality index: Role: Analytics consultant. Task: Produce a seasonality index by month for top models using Month, Model, and Units_Sold. Context: 3 years. Output: index values and 2 stock actions. Output format: table + bullets.
97. Inventory safety stock: You are an inventory planner. Task: Determine safety stock levels by SKU using On_Hand, Lead_Time, and Demand_Variance. Context: 12 months. Output: safety stock table and 2 trigger actions. Output format: table + narrative.
98. Dealer performance forecast: Role: Dealer performance analyst. Task: Forecast dealer performance across regions using Revenue, Margin, and Units. Context: 12 months. Output: forecast with confidence intervals and 2 improvement actions. Output format: table + narrative.
99. Data quality baseline: You are a data governance lead. Task: Establish data quality baselines for sales and inventory data using Completeness, Consistency, and Accuracy metrics. Context: 12 months. Output: baseline scores and 2 remediation steps. Output format: table + bullets.
100. Executive summary ready: Role: BI lead. Task: Produce a concise executive summary of the Excel data analysis prompts for car dealerships, focusing on revenue, margins, and inventory. Context: 12 months of data. Output: 1-page summary with key metrics and 2 strategic recommendations. Output format: table + bullets.

Best Practices

• Keep prompts specific to your dealership structure (locations, regions, models).
• Include clear output formats (tables, bullet lists) to facilitate downstream reporting.
• Reuse prompts with different datasets by swapping in placeholders rather than rewriting from scratch.
• Validate Claude outputs with your Excel data using spot checks and simple sanity checks.
• Limit complex multi-step prompts by breaking them into smaller, linked prompts for reliability.

Common Mistakes to Avoid

• Using vague prompts without clearly defined data fields or time ranges.
• Overloading prompts with too many outputs, causing inconsistent formatting.
• Ignoring data quality or missing value handling in prompt assumptions.
• Not validating Claude results against the actual Excel workbook or data definitions.
• Assuming Claude can fetch data from files without providing explicit data structure in the prompt.

FAQ

What is the purpose of these Claude prompts for Excel data analysis in car dealerships?

They provide ready-to-run, topic-specific prompts that extract actionable insights from dealership data in Excel using Claude AI.

How do I customize prompts to my dealership data?

Replace placeholders like [region], [model], [date range], and similar fields with your actual dataset column names and values.

Can prompts handle multi-location dealership networks?

Yes, prompts are designed to aggregate data across regions and locations, with outputs that highlight regional performance and actionable actions.

What output formats are expected from Claude prompts?

Typical outputs include tables, bullet lists, charts descriptions, and short narrative explanations suitable for reports.

How can I ensure data safety and accuracy when using Claude prompts?

Validate Claude outputs against your source Excel data, ensure data mappings are correct, and apply data quality checks before use.

Are there prompts tailored for performance dashboards?

Yes, some prompts summarize metrics into dashboard-ready descriptions, trends, and top drivers for executive view.