This dashboard is for the use of the Board of Directors of the Community Foundation of Middlesex County. Trends in the incoming funds and the outgoing grants will be analyzed with the interactive visualizations on this dashboard. Eventually, a community-facing version will be constructed.
git clone https://github.com/fredcorpuz06/cfmc-dashboard.git
cd cfmc-dashboard
Check if you have installed all the Python package dependencies contained in requirements.txt
. Then run in terminal
python index.py
You can now access dashboard at
http://127.0.0.1:8050/
Additionally, a live version of this dashboard is deployed on Heroku at https://cfmc-dashboard.herokuapp.com
- Interactive components
- Year selection slider
- Summary type dropdown
- Variable selection dropdown
- Nonprofit selection dropdown
- Visualizations
- Sankey diagram: display the flow of money from the different sources of funds (field of interest funds, donor-advised funds, etc.) to the project impact areas (poverty alleviation, arts, etc.) and the regions in Middlesex that the money flows to
- Web App - Dash is a Python framework built on top of Flask and React.js ideal for building highly custom user interfaces
- Data Visualizations - Plotly is a graphing library for interactive, publication-quality graphs online
- App Deployment Platform - Heroku is a cloud platform that allows you to build, deliver, monitor and scale apps
- Database - PostgreSQL is an open source object-relational database management system with an emphasis on extensibility
- Frederick Corpuz, student at Wesleyan University '20, analyzed the data, designed and built the visualizations, and deployed the dashboard for use
- Thayer Talbott, Vice President of Programs & Operations at CFMC, provided data/domain expertise and consulted on the construction of the visualizations