# AVAA Alumni Analytics Dashboard

> AVAA's first alumni dashboard, built in Power BI from years of scattered spreadsheets I cleaned with Python.

- URL: https://kevinbravo.com/projects/avaa-power-bi-dashboard
- Author: Kevin Bravo (https://kevinbravo.com/)
- Year: 2023
- Stack: Power BI, Python, data analytics, dashboard design
- Tags: power bi, python, data analytics, dashboards

## Overview

During my software developer internship at **AVAA**, I helped digitize internal processes for the **ProExcelencia** program, a talent accelerator for high-potential university students in Venezuela.

My main project was a **fully interactive Power BI dashboard** for alumni analysis. It helped the team explore graduate outcomes, satisfaction, location, academic data, and employment information without manually filtering spreadsheets.

I also wrote Python scripts to extract, clean, and prepare historical data before loading it into Power BI.

## The problem

AVAA had useful alumni data, but it was spread across different spreadsheets and historical records. This made reporting slow and difficult to maintain.

The project focused on three needs:

- recover and structure scholar activity data from 2020 to 2023
- reduce manual spreadsheet work through Python scripts
- give stakeholders one interactive place to understand program impact

## What I built

I built a Power BI dashboard with sections for demographics, university data, work information, and satisfaction results. The dashboard included filters, maps, tables, stacked charts, and summary cards so the team could move from a general alumni count to more specific questions.

The Python scripts helped prepare the source data by normalizing spreadsheets, organizing alumni fields, and reducing repetitive cleanup before analysis.

## Dashboard screens

<figure>
  <img src="/assets/projects/avaa-dashboard/demographics.avif" alt="Demographic dashboard view showing alumni location, gender distribution, age breakdown, and graduate records." />
  <figcaption>
    Demographic dashboard view showing alumni location, gender distribution, age breakdown, and graduate records.
  </figcaption>
</figure>

<figure>
  <img src="/assets/projects/avaa-dashboard/academic-data.avif" alt="Academic dashboard view showing graduate counts by university, average grades, recognitions, and study time." />
  <figcaption>
    Academic dashboard view showing graduate counts by university, average grades, recognitions, and study time.
  </figcaption>
</figure>

<figure>
  <img src="/assets/projects/avaa-dashboard/satisfaction.avif" alt="Satisfaction dashboard view showing how graduates evaluated different components of the ProExcelencia program." />
  <figcaption>
    Satisfaction dashboard view showing how graduates evaluated different components of the ProExcelencia program.
  </figcaption>
</figure>

## Outcome

The dashboard turned scattered alumni records into a clearer analytics workflow for AVAA.

It helped the team:

- track long-term program impact
- review demographic, academic, work, and satisfaction data
- reduce manual work in scholar tracking
- prepare structured historical data for future SEP integration

This project gave me practical experience connecting software development, data cleaning, and program operations. It also showed me how much a dashboard depends on the quality of the data process behind it.
