Learn a little bit more about the dataset.
About
This dataset is San Francisco's Financial Data of Spending and Revenue from 1999-2016 by department/organization group/fund categories. You can explore and download your own copy of the dataset through SF Open Data. This dataset consists of 549,215 rows and 22 columns. I focused mainly on the hierarchical columns of Organization Group, which consists of many Departments who manage Programs and gain revenue from various Fund Categories. The amount is entailed in the final column, which is a positive or negative number representing the revenue expenditures. This allows analysis of which types of departments use how much spending and how revenue/spending has been looking over the span of many years. Whether the amount is of Revenue/Spending is noted in the beginning of the dataset.The multivariate line chart above shows the totals of revenue and spending from 1999-2016, giving a little background into the dataset before diving deeper. It is evident that until 2008, Revenue and Spending were intermittently greater than the other, respectively. After 2008, however, Revenue has shown itself to be greater than Spending until today. This may be a sign of the results of the 2008 Financial Crisis.