Kohesi: Jurnal Sains dan Teknologi

Articles

Vol. 10 No. 7 (2025): Kohesi: Jurnal Sains dan Teknologi, ISSN 3025-1311

UNDERSTANDING DATA VISUALIZATION THROUGH MACHINE LEARNING USING PYTHON AS A VISUALIZATION MEDIA: SQL PRACTICAL ANALYSIS OF INFORMATION SYSTEMS STUDENTS

Submitted
December 26, 2025
Published
2025-12-26

Abstract

SQL practicum evaluation for Information Systems students is often hampered by raw tabular formats that make it difficult to identify error patterns quickly. This study implemented Python on Google Colab to analyze data scores and technical descriptions from 20 students, applying automated preprocessing (regex error extraction), KMeans clustering (k=3, silhouette=0.72), and comprehensive visualizations (bar ranking, violin-swarmplot, pie chart, JOIN heatmap, cluster scatterplot, boxplot). The results showed a 65% success rate with a critical threshold of 70, where JOIN errors dominated 42% of failed cases (average score 62), while performance segmentation was divided into High (89.2), Medium (77.8), and Low (62.5) clusters. This approach resulted in precise curriculum recommendations in the form of remedial <70 and intensive JOIN modules, shifting the assessment paradigm from manual to automated, data-driven

References

  1. [1] N. C. Kamila, “UTILIZATION OF POWER BI FOR VISUALIZATION OF STUDENT EDUCATION DATA,” Journal of Information Systems (TEKNOFILE), vol. 2, pp. 773–782, Oct. 2024.
  2. [2] K. Citra Ghania and I. Maurits, “VISUALIZATION OF DATA ON SMALL AND MEDIUM ENTERPRISES (UKM) DKI JAKARTA PROVINCE USING METABASES,” vol. 3, doi: 10.56127/jukim.v3i02.
  3. [3] A. Mulyani, P. Informatics Studies, and F. Information Technology, “VISUALIZATION OF DATA TICKETING SERVICESK WITH DASHBOARD AT PT BRANTAS ABIPRAYA (PERSERO) Ticketing Servicedesk Data Visualization with Dashboard at PT Brantas Abipraya (Persero),” Journal of Information Systems, Applied, Management, Accounting and Research, vol. 7, no. 2, pp. 289–300, 2023, doi: 10.52362/jisamar.v7i2.1074.
  4. [4] A. Kencana Putri and D. Ichsanuddin Nur, “USE OF PYTHON LANGUAGE FOR ANALYSIS AND VISUALIZATION OF POPULATION DATA IN SUMBERJO VILLAGE, NGANJUK,” 2023. [Online]. Available: https://jurnalfkip.samawa-university.ac.id/karya_jpm/index
  5. [5] D. Nurlaily, M. Silfiani, S. Puspita Sari, A. Taufik Amrullah, P. Statistics Studies, and I. Kalimantan Technology, “Data Visualization Training Using Google Data Studio,” vol. 1, 2022, [Online]. Available: https://jurnal.jomparnd.com/index.php/jpabdi
  6. [6] F. Azhar, N. W. Abdulmajid, and B. A. Hidayatullah, “Dashboard for Student Achievements at SMPN 1 Purwakarta: Data Visualization with Google Looker Studio,” Progressive: Computer Scientific Journal, vol. 21, no. 2, p. 495, Aug. 2025, doi: 10.35889/progressive.v21i2.2883.
  7. [7] L. Anggraini, E. Princess, R. Vivi Nola Br Ks, and N. Lecturer, “Cohesion: Multidisciplinary Journal Saintek UNDERSTANDING DATA VISUALIZATION THROUGH MACHINE LEARNING USING PYTHON AS A VISUALIZATION MEDIUM”, doi: 10.8734/Kohesi.v1i2.365.
  8. [8] A. S. Agstriningtyas, A. Y. Primary, K. Roso, and A. Krismahardi, “Visualization of Awareness Data and Implementation of Circular Economics in Malang City Using Python and Google Colab,” Journal of Innovative Research, vol. 5, no. 1, pp. 285–294, Jan. 2025, doi: 10.54082/jupin.963.
  9. [9] D. Nurlaily, M. Silfiani, S. Puspita Sari, A. Taufik Amrullah, P. Statistics Studies, and I. Kalimantan Technology, “Data Visualization Training Using Google Data Studio,” vol. 1, 2022, [Online]. Available: https://jurnal.jomparnd.com/index.php/jpabdi
  10. [10] S. Junaidi, M. Devegi, and H. Kurniawan, “Training in Processing and Visualization of Population Data using Python,” ADMA: Journal of Community Service and Empowerment, vol. 4, no. 1, pp. 151–162, Jul. 2023, doi: 10.30812/adma.v4i1.2963.

Similar Articles

211-220 of 370

You may also start an advanced similarity search for this article.