W209 Final Project

Overview

The objective of this project is to raise awareness and increase transparency about how governments are spending federal tax dollars, and be able to make comparisons between the spending of different countries.

Our target users are individuals who are curious about where their tax money goes - or any tax-paying people, for that matter. Governments can also use our tool to analyze their own federal spending. By benchmarking other countries/states on how they spend their dollars and linking them with possible policies that impact these spending habits, the solution aims to help inspire users to think of what policies they would like to see implemented in their government(s).

Before you explore...

Here are instructions on how to interact with our visualization.

Step 1:

Select a country (or countries) from the world map.

country

You can select countries by highlighting an area on the map, pressing your CMD or CTRL key + clicking individual countries on the map, by unselecting countries you would like to exclude in the fliter on the right, or searching by country in the top left. This will filter the data on th rest of the visualization to the countries you have selected.

Step 2:

Observe expenditure by sector...

sector

These graphs break down the expenditure of each country you have selected into four categories: social, health, education, and defense spending. The values are shows as a percentage of the total GDP. You can also sort by the various metrics by clicking their respective sort carats.

Step 3:

Observe holistic relations across sectors and countries...

waterfall

Treat the red bar as the amount you pay in taxes, and in return you recieve services in the social, health, education, and defense sectors. The four columns in the middle show breakdown the value of services you recieve in each sector, and the green bar depicts how much extra value you gained in services from the government relative to the taxes you paid.

Federal Spending Around the World

This visualization is intended to be used in full-screen mode. Click the icon in the bottom right corner of the visualization to enter full-screen mode.

Data and Design

All visualizations have been created using Tableau Public. We chose Tableau as our tool for data visualization because it enabled us to quickly create dynamic and interactive visualizations while handling our large datasets. In addition to ease of use of the software itself, Tableau offered a smooth way to integrate our visualizations into a web interface.

Our data comes from the World Bank and OECD (Organisation for Economic Co-operation and Development) and from The World Bank. The earlier of the two provides us with data on country-level government expenditures and GDPs, while the latter dataset provides data on federal tax revenues and tax percentages.

We developed a data pipeline in Alteryx to extract country level data for the nations from the sources and outputted the result into a single file that was ingested by Tableau. Most of the data was expressed in percentages of GDP, but for our purposes converted these percentages into absolute dollars and dollars per capita.

Below you can see a snapshot of what the data cleaning, processing, and transformation processes consisted of:

alteryx

The Team

All team members contributed to researching, designing, and developing the visualizations and website.

Faris

Faris Haddad

Senior Consultant at PwC

Contact

Khizar

Khizar Khan

COO, CFO at SiGenex Inc

Contact

Amanjot

Amanjot Samra

Software Engineer at Amazon

Contact