Convenient database management system
I want to share the experience of the evolution of the use of database systems in the GLASHA online language school.
The school was founded in 2012 and at the beginning of work all 12 students studied in it, so there were no problems with managing the schedule and payments. However, with the growth, development and emergence of new students, the question arose about choosing a database system.
The task was to do:
Oddly enough, all this complex reporting was done using Excel.
Moreover, spreadsheets made it possible to combine the budgets of students in one (if members of the same family are involved), combine the budgets of teachers (if they represent partner schools), enter different coefficients for teachers, set different prices for students, track bonuses and penalties of Skype school operators , watch analytics on payments and lessons.
However, when the number of students increased to two hundred people, and the number of teachers to 75, then this functionality, made on the verge of Excel capabilities, ceased to be convenient.
Firstly, the number of reports has become insufficient for the management system, and secondly, the offline version required regular cleaning to maintain high speed. In addition, integration with bots was required to check the free slots for teachers, check the balance at the request of students, send SMS about canceling lessons, etc.
And over time, we created the GLASHA web application, in fact, it is an ERP system that allows you to plan teacher loading, keep personal student timetables, and keep track of finances. Thanks to which different forms of reports are available, there is no need for a monthly base correction, there was an opportunity to make a personal account of a client and upload homework, tests to check knowledge, tie the schedule to the time zone of each student, etc.
I think that such a planning system would be useful for optimization in any kind of business.
The school was founded in 2012 and at the beginning of work all 12 students studied in it, so there were no problems with managing the schedule and payments. However, with the growth, development and emergence of new students, the question arose about choosing a database system.
The task was to do:
- reference book for all clients (students), keeping their name, time zone, contact details and notes;
- a similar list of teachers with the same information about them;
- create a schedule of teachers in the same system;
- make automatic generation of a classbook;
')
- Track your class history
- accounting for finances both for writing off students' budgets and for paying teachers;
- student debtor tracking scheme;
- Notebook for notes on some nuances of lessons with pop-up reminders.
Oddly enough, all this complex reporting was done using Excel.
Moreover, spreadsheets made it possible to combine the budgets of students in one (if members of the same family are involved), combine the budgets of teachers (if they represent partner schools), enter different coefficients for teachers, set different prices for students, track bonuses and penalties of Skype school operators , watch analytics on payments and lessons.
However, when the number of students increased to two hundred people, and the number of teachers to 75, then this functionality, made on the verge of Excel capabilities, ceased to be convenient.
Firstly, the number of reports has become insufficient for the management system, and secondly, the offline version required regular cleaning to maintain high speed. In addition, integration with bots was required to check the free slots for teachers, check the balance at the request of students, send SMS about canceling lessons, etc.
And over time, we created the GLASHA web application, in fact, it is an ERP system that allows you to plan teacher loading, keep personal student timetables, and keep track of finances. Thanks to which different forms of reports are available, there is no need for a monthly base correction, there was an opportunity to make a personal account of a client and upload homework, tests to check knowledge, tie the schedule to the time zone of each student, etc.
I think that such a planning system would be useful for optimization in any kind of business.
Source: https://habr.com/ru/post/460915/
All Articles