[BE-34] Occupancy forecasting: backend

[yusuftomilola]

Overview

Admins manage workspace capacity reactively. Forecasting predicts future demand based on historical booking patterns — enabling proactive pricing adjustments, staffing decisions, and workspace promotion.

Context

• Booking entity: backend/src/bookings/entities/booking.entity.ts — startDate, workspaceId, planType, status
• Workspace entity: backend/src/workspaces/entities/workspace.entity.ts — totalSeats
• DashboardModule: backend/src/dashboard/ — add forecast endpoint here

Tasks

• GET /dashboard/admin/occupancy-forecast — returns predicted occupancy per workspace for the next 30 days
• Algorithm for each future date D and workspace W:
  • Find all CONFIRMED or COMPLETED bookings for W on the same day-of-week as D over the past 90 days
  • Compute average occupied seats on those historical days
  • Divide by W.totalSeats to get predictedOccupancyPercent (0–100)
• Response: { predictions: [{ date, workspaceId, workspaceName, predictedOccupancyPercent }] }
• Supports ?workspaceId= filter to return forecast for a single workspace
• Endpoint is admin only

Files to Modify / Create

• backend/src/dashboard/dashboard.controller.ts
• backend/src/dashboard/providers/admin-analytics.provider.ts

[madisonsc52-del]

@madisonsc52-del has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi maintainer i can work on this, I'll make sure to work on the issue asap

ℹ️ Repo Maintainers: To accept this application, review their application or assign @madisonsc52-del to this issue.

[sketcherzee]

@sketcherzee has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

can i work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @sketcherzee to this issue.

[drips-wave]

Congratulations, @sketcherzee! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @sketcherzee: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox!

@sketcherzee's PR #1324 was approved and merged by @yusuftomilola.

🏆 @sketcherzee: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (331 total points). Track your full progress on GrantFox.

👏 Great work, @sketcherzee! Keep contributing to DistinctCodes.