{"id":46,"date":"2011-03-12T13:28:39","date_gmt":"2011-03-12T13:28:39","guid":{"rendered":"http:\/\/blog.soton.ac.uk\/data\/?p=46"},"modified":"2011-03-12T14:16:20","modified_gmt":"2011-03-12T14:16:20","slug":"money","status":"publish","type":"post","link":"https:\/\/blog.soton.ac.uk\/data\/2011\/03\/12\/money\/","title":{"rendered":"Where does the Money Go?"},"content":{"rendered":"<div style=\"float: right; margin-left: 10px;\"><a href=\"https:\/\/twitter.com\/share\" class=\"twitter-share-button\" data-count=\"vertical\" data-url=\"https:\/\/blog.soton.ac.uk\/data\/2011\/03\/12\/money\/\">Tweet<\/a><\/div>\n<p>After many battles with excel, pivot tables and the IBM &#8220;Many Eyes&#8221;s site, I&#8217;ve had a go at visualising our <a href=\"http:\/\/data.southampton.ac.uk\/dataset\/payments\/201011-201101.html\">Payments Dataset<\/a>. I&#8217;m now an armchair auditor!<\/p>\n<p>Please note that I am far an expert in working with such data so the below graphs should not be considered &#8220;official&#8221; data from the university as I may have made mistakes in my processing. The data is not entirely complete as it contains no payments to individuals, and nothing commercially sensitive.<\/p>\n<p>Here&#8217;s who we&#8217;ve paid money to in that dataset&#8230; I had to trim the data down to payments of \u00a310K+ as otherwise it seemed to crash their java!<\/p>\n<p><a style=\"margin: 0pt; padding: 0pt;\" href=\"http:\/\/www-958.ibm.com\/me\/visualizations\/u-of-southampton-spending-by-compa\/comments\/76277d504cac11e08690000255111976\"> <img decoding=\"async\" style=\"border: 1px solid #6898C8; margin: 0; padding-top: 10px; padding-bottom: 15px;\" title=\"U. of Southampton Spending by company 10K+\" src=\"http:\/\/www-958.ibm.com\/me\/files\/thumbnails\/75dd4604-4cac-11e0-8690-000255111976.png?size=600x400\" alt=\"U. of Southampton Spending by company 10K+\" \/> <img decoding=\"async\" style=\"border: 0pt none; margin: 0pt; padding: 0pt; display: block; position: relative; top: -9px;\" title=\"Many Eyes\" src=\"http:\/\/www-958.ibm.com\/me\/images\/blog_this_caption.jpg\" alt=\"Many Eyes\" \/><\/a><\/p>\n<p>This shows a break down of the broad categories and sub categories of what we paid money for.<\/p>\n<p><a style=\"margin: 0pt; padding: 0pt;\" href=\"http:\/\/www-958.ibm.com\/me\/visualizations\/where-does-our-u-of-southampton-mo\/comments\/79319e544ca711e0b0f3000255111976\"> <img decoding=\"async\" style=\"border: 1px solid #6898C8; margin: 0; padding-top: 10px; padding-bottom: 15px;\" title=\"Where does our (U of Southampton) Money Go?\" src=\"http:\/\/www-958.ibm.com\/me\/files\/thumbnails\/7905fd12-4ca7-11e0-b0f3-000255111976.png?size=600x400\" alt=\"Where does our (U of Southampton) Money Go?\" \/> <img decoding=\"async\" style=\"border: 0pt none; margin: 0pt; padding: 0pt; display: block; position: relative; top: -9px;\" title=\"Many Eyes\" src=\"http:\/\/www-958.ibm.com\/me\/images\/blog_this_caption.jpg\" alt=\"Many Eyes\" \/><\/a><\/p>\n<p>I hope that we&#8217;ve got some budding statisticians, accountants or data visualisers who can do something better than me!<\/p>\n<p>One cool idea; find out what payees we have in common with the local hospitals and council:<\/p>\n<ul>\n<li><a href=\"http:\/\/data.gov.uk\/dataset\/transactions\">Spend over \u00a325,000 in Southampton University Hospitals NHS Trust<\/a><\/li>\n<li><a href=\"http:\/\/data.gov.uk\/dataset\/local-authority-spending-over-500-southampton\">Payments to suppliers with a value over \u00a3500 from Southampton City Council<\/a><\/li>\n<li><a href=\"http:\/\/data.gov.uk\/dataset\/financial-transactions-data-southampton-city-pct\">Spend over \u00a325,000 in Southampton City PCT<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Tweet After many battles with excel, pivot tables and the IBM &#8220;Many Eyes&#8221;s site, I&#8217;ve had a go at visualising our Payments Dataset. I&#8217;m now an armchair auditor! Please note that I am far an expert in working with such data so the below graphs should not be considered &#8220;official&#8221; data from the university as [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8217,8216],"tags":[8218],"class_list":["post-46","post","type-post","status-publish","format-standard","hentry","category-datasets","category-visualisation","tag-payments"],"_links":{"self":[{"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":6,"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/posts\/46\/revisions"}],"predecessor-version":[{"id":48,"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/posts\/46\/revisions\/48"}],"wp:attachment":[{"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/media?parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/categories?post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.soton.ac.uk\/data\/wp-json\/wp\/v2\/tags?post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}