title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐ¸ÑÑÐµÐ¼Ñ Ð¾Ð²ÐµÑÐ±ÑÐºÐ¸Ð½Ð³Ð° Ñ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸ÐµÐ¼ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² Ð¼Ð°ÑÐ¸Ð½Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÑÑÐµÐ½Ð¸Ñ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development of an Overbooking System Using Machine Learning Methods
Creators: name: Ð¢Ð°Ð»Ð¸Ð¿Ð¾Ð²Ð°, ÐÑÐ»Ð»Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ°
Ð¾Ð²ÐµÑÐ±ÑÐºÐ¸Ð½Ð³
Ð±ÑÐºÐ¸Ð½Ð³
Ð¾Ð½Ð»Ð°Ð¹Ð½ ÑÐºÐ¾Ð»Ð°
Ð¿ÑÐ¾Ð´Ð°Ð¶Ð¸
Ð¼Ð°ÑÑÐµÑ-ÐºÐ»Ð°ÑÑ
ÑÐ°Ð¹Ð¼ÑÐ»Ð¾Ñ
Ð¼Ð°ÑÐ¸Ð½Ð½Ð¾Ðµ Ð¾Ð±ÑÑÐµÐ½Ð¸Ðµ
Python
FastAPI
Catboost
development
overbooking
booking
online school
sales
trial class
timeslot
machine learning

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ Ð¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¾Ð²ÐµÑÐ±ÑÐºÐ¸Ð½Ð³Ð° Ð² Ð¾ÑÐ´ÐµÐ» Ð¿ÑÐ¾Ð´Ð°Ð¶ Ð¾Ð½Ð»Ð°Ð¹Ð½ ÑÐºÐ¾Ð»Ñ. Ð¦ÐµÐ»Ñ ÑÐ°Ð±Ð¾ÑÑ â ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾ÑÑÐ¸ Ð¾Ð²ÐµÑÐ±ÑÐºÐ¸Ð½Ð³Ð°, Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÑÑÐµÐ¹ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð¸ÑÐ¾Ð²Ð°ÑÑ Ð·Ð°Ð¿Ð¸ÑÑ ÐºÐ»Ð¸ÐµÐ½ÑÐ¾Ð² Ð½Ð° Ð¼Ð°ÑÑÐµÑ-ÐºÐ»Ð°ÑÑÑ, Ð¼Ð¸Ð½Ð¸Ð¼Ð¸Ð·Ð¸ÑÑÑ Ð¸Ð·Ð´ÐµÑÐ¶ÐºÐ¸ Ð¸ ÑÐ²ÐµÐ»Ð¸ÑÐ¸Ð²Ð°Ñ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð¾ Ð¿ÑÐ¾Ð´Ð°Ð¶. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² Ð¿ÑÐ¾ÑÐµÑÑÐµ ÑÐ°Ð±Ð¾ÑÑ: â¢ ÐÐ½Ð°Ð»Ð¸Ð· Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½ÑÑ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð¿Ð¾ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ Ð¾Ð²ÐµÑÐ±ÑÐºÐ¸Ð½Ð³Ð°. â¢ Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ð¹ Ðº ÑÐ¸ÑÑÐµÐ¼Ðµ. â¢ Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÑ ÑÐ¸ÑÑÐµÐ¼Ñ. â¢ Ð¡Ð±Ð¾Ñ Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð¾Ð±ÑÑÐ°ÑÑÐµÐ³Ð¾ Ð½Ð°Ð±Ð¾ÑÐ° Ð´Ð°Ð½Ð½ÑÑ. â¢ ÐÐ±ÑÑÐµÐ½Ð¸Ðµ Ð¸ Ð²ÑÐ±Ð¾Ñ Ð¼Ð¾Ð´ÐµÐ»Ð¸ Ð¼Ð°ÑÐ¸Ð½Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÑÑÐµÐ½Ð¸Ñ. â¢ Ð¡Ð¾Ð·Ð´Ð°Ð½Ð¸Ðµ ÑÐµÑÐ²Ð¸ÑÐ° Ð¾ÑÐµÐ½ÐºÐ¸ ÐºÐ»Ð¸ÐµÐ½ÑÐ¾Ð² (Ð»Ð¸Ð´Ð¾Ð²). â¢ Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐ¸ÑÑÐµÐ¼Ñ Ð¾Ð²ÐµÑÐ±ÑÐºÐ¸Ð½Ð³Ð° Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð¾ÑÐµÐ½ÐºÐ¸ Ð»Ð¸Ð´Ð¾Ð². Ð ÑÐ¾Ð´Ðµ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ» Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÑÐµÐº, Ð²ÐºÐ»ÑÑÐ°ÑÑÐ¸Ð¹ ÑÐ·ÑÐº Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Python Ð¸ ÑÑÐµÐ¹Ð¼Ð²Ð¾ÑÐº FastAPI Ð´Ð»Ñ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð¼Ð¸ÐºÑÐ¾ÑÐµÑÐ²Ð¸ÑÐ¾Ð², MongoDB Ð´Ð»Ñ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ, Celery Ð´Ð»Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð·Ð°Ð´Ð°ÑÐ°Ð¼Ð¸ Ð¸ Betterstack Ð´Ð»Ñ Ð¼Ð¾Ð½Ð¸ÑÐ¾ÑÐ¸Ð½Ð³Ð°. ÐÑÐ»Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¸ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð° Ð¼Ð¾Ð´ÐµÐ»Ñ Ð¼Ð°ÑÐ¸Ð½Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÑÑÐµÐ½Ð¸Ñ, Ð¾Ð±ÑÑÐµÐ½Ð½Ð°Ñ Ð½Ð° Ð´Ð°Ð½Ð½ÑÑ, ÑÐ¾Ð±ÑÐ°Ð½Ð½ÑÑ Ð¸Ð· ÐºÐ¾ÑÐ¿Ð¾ÑÐ°ÑÐ¸Ð²Ð½Ð¾Ð³Ð¾ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Amazon Redshift. ÐÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð½Ð¾ÑÐ¸Ñ Ð¿ÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ°ÑÐ°ÐºÑÐµÑ. Ð¡Ð¸ÑÑÐµÐ¼Ð° Ð¼Ð¾Ð¶ÐµÑ Ð±ÑÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð° Ð´Ð»Ñ ÑÐ»ÑÑÑÐµÐ½Ð¸Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¾ÑÐ´ÐµÐ»Ð° Ð¿ÑÐ¾Ð´Ð°Ð¶ Ð² Ð¾Ð½Ð»Ð°Ð¹Ð½ ÑÐºÐ¾Ð»Ð°Ñ Ð¸ Ð½Ðµ ÑÐ¾Ð»ÑÐºÐ¾.
description: This work is dedicated to the development and implementation of an overbooking system for the sales department of an online school. The goal of the work is to develop overbooking functionality that optimizes client registration for masterclasses, minimizing costs and increasing the number of sales. Tasks addressed during the work: â¢ Analysis of possible solutions for implementing overbooking. â¢ Development of system requirements. â¢ Development of system architecture. â¢ Data collection and analysis for creating the training dataset. â¢ Training and selection of the machine learning model. â¢ Creation of a lead scoring service. â¢ Development of the overbooking system based on lead scoring results. During the execution of the final qualification work, a technology stack was used, including the Python programming language and the FastAPI framework for creating microservices, MongoDB for data storage, Celery for task management, and Betterstack for monitoring. A machine learning model was developed and applied, trained on data collected from the corporate data warehouse based on Amazon Redshift. The final qualification work is practical. The system can be used to improve the efficiency of the sales department in online schools and beyond.