What it does
Our project, titled "Where's my dollar?," provides a comprehensive data visualization of how the US Treasury allocates and spends funds on various programs. By utilizing advanced analytic tools like Tableau and Python, we track and analyze expenditures, making complex financial data more accessible and understandable to the public.
How we built it
We built the project by leveraging the data available from USAspending.gov. First, we used Python for data extraction and preprocessing, ensuring that the data was clean and structured. Next, we employed Tableau and Tableau Prep for data visualization and analysis, creating interactive dashboards that illustrate spending patterns across different programs and initiatives.
Challenges we ran into
One of the major challenges we faced was ensuring the accuracy and completeness of the data extracted from USAspending.gov. Integrating multiple data sources and formats required extensive preprocessing. Additionally, creating meaningful visualizations that effectively communicated complex financial information was a significant hurdle.
Accomplishments that we're proud of
We are proud of successfully creating an interactive dashboard that not only visualizes spending data but also allows users to filter and explore different aspects of the budget. The integration of Python with Tableau to enhance data processing and visualization capabilities was a significant achievement for our team.
What we learned
Throughout this project, we gained valuable insights into data visualization best practices and the importance of clear communication in presenting complex data. We also enhanced our skills in using Python for data manipulation and improved our proficiency in Tableau for creating dynamic and informative dashboards.
What's next?
Looking ahead, we plan to enhance "Where's my dollar?" by adding more features, such as incorporating additional data sources for a more comprehensive analysis and implementing machine learning techniques to predict future spending trends. We also aim to promote the project to engage more users and gather feedback for continuous improvement.
Log in or sign up for Devpost to join the conversation.