In today’s universities, managing large volumes of data—such as student records, course enrollments, fee payments, scholarships, and attendance—can be challenging and time-consuming. Senior managers and administrators often need quick insights to make important decisions, but manually analyzing multiple tables and reports is inefficient. Our project, Smart University Analytics with Chatbot, addresses this problem by combining a centralized university database with an intelligent analytics system and a natural language chatbot interface. The system stores all student, course, fee, scholarship, and attendance data in a structured database. Senior managers can interact with the chatbot by typing questions in natural language, and the system instantly provides accurate answers and visual reports. For example, the chatbot can answer queries such as: how many students have not paid full fees, what is the maximum scholarship awarded, how many students come from distant areas, what percentage of students are from urban versus rural regions, and which courses are most or least in demand. These insights help administrators track trends, monitor financial records, and make data-driven decisions quickly. The system is built using HTML, CSS, and JavaScript for the frontend, Python Flask or Django for the backend, and MySQL or PostgreSQL as the database. Data analytics is handled using SQL queries and Pandas, while visualizations are displayed with Chart.js. Optional NLP APIs or AI libraries allow the chatbot to understand natural language queries effectively.
Built With
- aicloud
- gemini
Log in or sign up for Devpost to join the conversation.