Grade Analysis

A comprehensive system for analyzing academic performance across the University of Ottawa. This project leverages a custom-built ETL pipeline that collects, scrapes, and cleans grade data from multiple sources, storing it in a structured SQL database. The platform enables detailed querying of metrics such as classes, professors, semesters, and faculties.

Built with

  • SQL
  • Tableau
  • Java
Sort grade data by class, faculty, or professor, and apply filters based on criteria such as semester or course level. Explore detailed insights including key statistics like the mean and mode, helping you uncover trends in academic performance across various dimensions.
Execute custom SQL queries through a secure backend framework powered by Java and Apache Tomcat. This robust system allows you to safely search for specific classes or academic information, offering flexible and dynamic querying to meet your data needs.
An interactive Tableau dashboard visualizes and brings the data to life, with dynamic charts that provide deep insights into grade distributions, faculty comparisons, and temporal trends, enabling intuitive exploration."