Designed and modeled a relational database to manage academic information for an educational institution, including students, professors, courses, and grade history. The project demonstrates advanced database modeling, SQL analytics, and business intelligence visualization.

Educational institutions often struggle to manage large volumes of student and course data while ensuring accurate performance tracking. The challenge was to create a relational schema that could handle complex relationships (students ↔ courses) and provide actionable insights into academic performance.

Database Modeling: Built an ERD using DBeaver, focusing on the Inscripción (Enrollment) table to capture grades, status, and semester.

SQL Analytics: Developed queries to calculate course averages, student GPAs, and detailed grade histories.

Visualization: Connected Power BI to the database, creating dashboards that show rankings and individual gradebooks.

Tools Used: PostgreSQL, pgAdmin, DBeaver, SQL, Power BI.

Delivered a relational schema with referential integrity, analytical queries for performance metrics, and a Power BI dashboard that provides both high‑level rankings and detailed grade histories.

Enabled administrators to track course performance trends.

Provided a ranking system for students and courses.

Created a gradebook view for detailed individual tracking.

Demonstrated how raw academic data can be transformed into actionable insights for decision‑making.

This project highlights the ability to design normalized relational schemas, write advanced SQL queries, and integrate BI tools for visualization. It showcases a complete workflow from data modeling to insight delivery, reinforcing expertise in database design and analytics.