Inspiration
We wanted to create a solution that combined data storage and visualization.
What it does
The database serves as a single source of truth for information regarding SVP Boston's nonprofit partners. It can easily be updated through the web app. The dashboard is a foundation for analyzing/visualizing the data and could be customized further based on SVP Boston's actual data and needs.
How we built it
- We used ChatGPT as a starting point to generate the data and then built a database in DB Browser for SQLite.
- The database editor is a web app built with Python Flask and SQLAlchemy. We used the DataTables library to enhance the table's functionality.
- We made the dashboard with Tableau.
Challenges we ran into
- Not knowing what the actual data looked like
- Minor technical issues
What we're proud of
Collaboratively making decisions and harnessing our individual strengths to develop a multi-component solution.
What we learned
- How to set up a SQLite database
- How to set up a web app with Flask
- How to use Tableau for visualizations
What's next
Future work could involve deploying the web app and publishing the dashboard to the web app.