The Dashboard – Financial Tracker
Details
The Dashboard presents a summary of The New School’s Financial Data that allows users to interact with data visualizations in order to draw comparisons and make their own analysis about the university’s revenue, expenditure, salaries, assets, and liabilities. For a lot of student, their journey at Parsons has not been easy as the university was struggling with its finances and the community was riddled with uncertainty and as a result, endured multiple union-led strikes. This project was created out of growing frustration amongst The New School community and the alleged disproportionate allocation of wages and funds.
Ideation
The idea was simple: solve a pain point that affects me and the community at large with the values this community has taught me: creativity, innovation, and a desire to challenge the status quo. The aim of my design thesis is to take the university’s complex financial data and present it to the Parsons community—primarily the students, parents, staff, and professors—in a clear and digestible format, with a focus on transparency and accessibility.
![](https://framerusercontent.com/images/kHGbLqRPSlrr5spbkGfnE7dMk.jpeg)
![](https://framerusercontent.com/images/93NmYoNMw3CdpM5HFSxiEWRgI.jpg)
Data Pipeline
The New School is a 501(c)3 designated non-profit and their financial data can be publicly accessed by visiting the IRS website and looking up their data with EIN #13-3297197. The data is extracted from the IRS's website, loaded and transformed in Excel using Power Query, and visualized with Tableau.
![](https://framerusercontent.com/images/TBrwbaO4mdEVeWArDGUNDbNius.jpg)
Design Process
The objective was to create a mobile experience that enables users to interact with information and conduct their own analyses. Users can engage with the visualizations using tooltips to better understand the data's significance. The design aimed to blend the aesthetics of the "Bloomberg Terminal" with "The New School's" identity. A "logo system" was developed, featuring the university's narwhal mascot combined with dollar signs and relevant symbols to represent key project sections: salaries, revenue, expenditure, and assets & liabilities. To ensure a cohesive experience, the design system was consistently applied across the project, including in the visualizations and within Tableau, to the fullest technical extent possible.
![](https://framerusercontent.com/images/wzgJcogl6kNKZcgY6Tqer2F1W4.jpg)
![](https://framerusercontent.com/images/nSXuvoDRS7SwhQ4qpWSmU8EEU.jpg)
![](https://framerusercontent.com/images/f45kE25jL9UTMQtuxMrtpOV8OYs.jpg)
Execution
The visualizations from Tableau are compiled into multiple dashboards and embedded on a responsive website. The website design takes a "mobile-first" approach and can be accessed by anyone anywhere. The Dashboard is a simple tool that takes the financial data from the university’s filings to the IRS and visualizes it in a cohesive and accessible format using creative visualizations, graphs, and charts.
The Dashboard provides users with customizable filters to make their own analysis of the university’s financial data during the 2018–2022 period and the users also have the option to export their findings. Ultimately, The Dashboard serves as a tool leveraging the principles of information design to enhance transparency and accountability within The New School community. Users can also compare key data points with other private universities based in NYC.
![](https://framerusercontent.com/images/58vopOdoVKH5esHqElCezv7I0.jpg)
![](https://framerusercontent.com/images/yZEgvRs4bhbvEGnWMgVldSNLF8.jpeg)
![](https://framerusercontent.com/images/HHHdK5UtaAnSyekk9cfh1MgxDDw.jpg)
Campaign Materials
To raise awareness regarding the initiative and solution, deliverables were designed for the project. The goal was to distribute the deliverables with The New School community and allow them to display their support for this endeavor. Campaign deliverables include dashboard-branded embroidered caps, transparent decals, and sticker sheets.
![](https://framerusercontent.com/images/QePG6307wGHYGJASgZIer1OU5g.jpg)
![](https://framerusercontent.com/images/P4tHEXVCUb9jfMgqk9j6wWhL9os.jpeg)
![](https://framerusercontent.com/images/JYwway07yXJDy5KkVai5JSGWuw.jpg)
![](https://framerusercontent.com/images/phaTjPYrIq4Xe39PYsFqtzfn8.jpg)