Abstract:
Vocational Education is a type of study. There are both government and private colleges affiliated. In the private affiliated, there is increasing interest. Causing more competition between colleges. In addition, the missions and policies of the Office of the Vocational Education Commission want to increase the number of vocational students, raising the quality of vocational education both at the college and among students. Including in terms of improving management efficiency in college. Data Warehouse, Business Intelligence and Advanced Data Analytics of Vocational Education College consist of 5 systems: Students Admission Analysis System, Colleges in Chonburi Province Analysis System, Students Analysis System, Revenue and Expense Analysis System and Number of Students Expected to Apply for Admission Prediction System. The first four systems were developed by using Microsoft SQL Server 2018 as the database management system and Tableau Desktop Professional Edition Version 2020.4 as the developing tool. The model in the last system was developed by using Python Programming Language. To help executives and related personnel have information for decision-making in business planning. Whether it is a lesson plan or admission strategy. Managing various budgets to be more efficient. Therefore, information technology has to be used as a tool to support analysis. The system will help administrators analyze data from different perspectives accurately and quickly to be used for decision-making.