PBSA ANALYSIS TASK PLANNING FRAMEWORK

Task Decomposition Plan:

validate_query_scope Confirm the query falls within PBSA analysis scope and identify any clarifications needed

request_clarification Ask specific questions about geographic scope, time period, property types, or analysis depth needed

gather_market_data Collect relevant market data including supply, demand, pricing, and competitive information

analyze_market_conditions Process market data to identify trends, patterns, and competitive dynamics

collect_property_metrics Gather occupancy, pricing, revenue, and operational performance data

benchmark_performance Compare property performance against market standards and peer properties

identify_competitive_set Define relevant competitors based on location, property type, and target demographic

analyze_competitive_positioning Compare pricing, amenities, occupancy, and market positioning against competitors

build_forecasting_model Develop appropriate forecasting methodology based on historical data and market drivers

generate_predictions Create forecasts with confidence intervals and scenario analysis

synthesize_findings Integrate analysis results into coherent insights and business recommendations

validate_results Review findings for accuracy, completeness, and business relevance

format_presentation Present results in appropriate format with clear recommendations and limitations

Analysis Complexity Considerations:

Simple Queries (Complexity: Low):

• Single metric requests (e.g., "What's the average occupancy in Leeds?")
• Basic comparisons (e.g., "How do our prices compare to competitors?")
• Straightforward trend analysis (e.g., "Show me booking patterns this year")

Moderate Queries (Complexity: Medium):

• Multi-dimensional analysis (e.g., "Compare performance across multiple properties")
• Seasonal pattern analysis (e.g., "How does pricing vary throughout the academic year?")
• Market segmentation studies (e.g., "What room types perform best in different cities?")

Complex Queries (Complexity: High):

• Strategic investment analysis (e.g., "Should we expand into Manchester market?")
• Multi-factor optimization (e.g., "What's the optimal pricing strategy for maximum revenue?")
• Predictive modeling (e.g., "Forecast occupancy for next academic year")

Available Data Sources:

Available tables and general context: - variant: pricing/availability data. - room: room details. - scheme: property information. - provider: accommodation operators. - city: geographic reference. - roomtype: room classifications.

Quality Validation Checkpoints:

• Query scope clearly defined and within PBSA domain
• Required data sources identified and accessible
• Analysis methodology appropriate for question complexity
• Results validation approach defined
• Presentation format matches stakeholder needs

Based on the following question and context, generate an execution plan.

    Question: What is the total number of PBSA schemes (properties)?

    Schema Context (relevant tables): variant
    Schema Context (similar examples for plan structure, if any):
    No similar examples provided.

    Create a comprehensive execution plan that addresses the question effectively.