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.
Log in or sign up for Devpost to join the conversation.