{"id":349451,"date":"2020-06-30T19:59:12","date_gmt":"2020-07-01T02:59:12","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcnews&#038;p=349451"},"modified":"2020-06-25T15:29:49","modified_gmt":"2020-06-25T22:29:49","slug":"data-visualization-app-increases-financial-transparency","status":"publish","type":"arcnews","link":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency","title":{"rendered":"Data Visualization App Increases Financial Transparency"},"author":5752,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","castos_file_data":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_links_to":"","_links_to_target":""},"categories":[10582,260002,134052],"tags":[300082,306352,165542,276132,1281],"arcnews_issues":[457841],"class_list":["post-349451","arcnews","type-arcnews","status-publish","format-standard","hentry","category-arcgis-insights","category-data-management","category-public-works","tag-actionable-information","tag-budget","tag-data-sharing","tag-government-transparency","tag-visualization","arcnews_issues-summer-2020","arcnews_sections-your-work"],"acf":{"short_description":"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.","pdf":{"host_remotely":false,"file":"","file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"<h2 style=\"text-align: center;\">Public Works Department in Topeka, Kansas, Uses ArcGIS Insights to Organize and Present Budget Information<\/h2>\r\nThe Public Works Department for the City of Topeka, Kansas, designs, builds, renovates, and operates public projects. These range from bridges, traffic signs and signals, and city-owned trees to streets, sidewalks, and parking meters and garages. The department strives to deliver programs and projects that enhance public health and the quality of life for everyone who lives in and visits Topeka.\r\n\r\nBecause the department relies on public funds, it has to collect and share accurate data about its programs and projects to enable leaders to make informed decisions about how funds are spent, as well as to increase transparency with the public. Tracking this information is the responsibility of the department\u2019s technical support group (TSG) division."},{"acf_fc_layout":"image","image":349461,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Toward the end of 2019, the TSG decided to upgrade how it displays the Public Works Department\u2019s budget information. It wanted to do this in a clear way so the public could understand where funds are allocated and others at the city could more easily see how finances are distributed among various departments. The division chose to use ArcGIS Insights for its advanced analytics capabilities and engaging visual displays."},{"acf_fc_layout":"content","content":"<h2>A Need to Share Financial Information<\/h2>\r\nAccording to TSG division manager Brandon Bayless, various divisions and departments within the City of Topeka were not sharing financial information, which meant there were likely no larger discussions going on about the data. This made it difficult for different units to collaborate and get the details they needed to make data-informed decisions. What\u2019s more, residents didn\u2019t have a good idea of how public funds were being used.\r\n\r\n\u201cFor the city, there\u2019s been a big push to have reliable, timely, and accurate information [to help] make better decisions based on support data,\u201d said Bayless. \u201cA lot of the information was not necessarily being shared or analyzed.\u201d The data was there, he said, but were various departments able to infer anything from it?\r\n\r\nBayless explained that ArcGIS Insights ended up being a great solution to this problem because it had all the tools the TSG needed to display data in a web-based platform. Darren Haag, a solutions architect in the TSG division, agreed."},{"acf_fc_layout":"quote","image":349481,"text":"Everything that\u2019s done around the city, whether it be fixing potholes or fixing water main breaks, has a location. Being able to analyze that and show people on a map or [provide] information [visually] is extremely beneficial.","author_name":"Brandon Bayless","author_profession_organization":"Division Manager, City of Topeka Public Works Department Technical Support Group"},{"acf_fc_layout":"content","content":"\u201cWhen I was going through and building different pieces for open data, I knew I wanted to utilize ArcGIS Insights, and I thought the budgets were a good [way] to use it,\u201d said Haag. \u201cEven though we don\u2019t necessarily need to map that data, I felt like ArcGIS Insights is a powerful business intelligence-type application that we could use for financial data.\u201d\r\n\r\nWith ArcGIS Insights, the TSG can bring in information that, when applied to real-world situations, gives the city a more holistic picture of what\u2019s going on.\r\n\r\n\u201cEverything that\u2019s done around the city, whether it be fixing potholes or fixing water main breaks, has a location,\u201d said Bayless. \u201cBeing able to analyze that and show people on a map or [provide] information [visually] is extremely beneficial.\u201d"},{"acf_fc_layout":"content","content":"<h2>More than Numbers on a Spreadsheet<\/h2>\r\nWith ArcGIS Insights, the TSG division can provide city employees and the public with more than just numbers on a spreadsheet. It can present information visually, making it easier to understand.\r\n\r\nWithin the Public Works Department, ArcGIS Insights has improved data collection and analysis. According to Bayless, managers used to spend the majority of their day trying to access and extract data using the city\u2019s financial software, which produced spreadsheets and standard text reports. It took them from an hour to an hour and a half to pull the data, create a ZIP file, and post it to an FTP site. Now, however, managers can easily collect any data requested by the public, city council members, or others and make it available to download via a link on the city\u2019s open data website.\r\n\r\n\u201cArcGIS Insights reduces the time needed to pull data. Now it\u2019s a very simple email response,\u201d said Bayless. \u201cThat\u2019s one of those efficiencies that makes things work smoother because we\u2019re not having to put pressure on somebody to do all this manual work.\u201d"},{"acf_fc_layout":"image","image":349471,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"While the Public Works Department is still in the process of setting up ArcGIS Insights on its internal enterprise GIS platform, it is already realizing how beneficial the analytics app is.\r\n\r\n\u201cIn the short time we have been using ArcGIS Insights, it has become apparent how much more efficiently our time will be used in exploring and analyzing our data,\u201d said Bayless.\r\n\r\nThe Public Works Department is employing ArcGIS Insights to house the budgets and financial data for three of its divisions. This has saved time and improved accuracy. The ease of data input and analysis has enabled division managers to better track their actual spending, analyze trends, and find areas where additional funding is needed or where budgets can be reduced.\r\n\r\n\u201cThe data and analytics that we provide with ArcGIS Insights or that we empower other departments to use help them make better decisions, which benefits the community,\u201d said Bayless.\r\n\r\nFor residents, having access to the eye-catching charts, graphs, and tables in ArcGIS Insights empowers them to find answers to their questions. This frees up city staff so they can focus on the services they provide.\r\n\r\nHaag said ArcGIS Insights is easier to use and better organized than other tools the department tried. While he believes that it could elicit more questions from residents once they review the data, Haag welcomes those questions because they help staff know what\u2019s important to people.\r\n\r\n\u201cThey possibly see trends or look at things and ask questions like, Why is this showing this? or Why aren\u2019t you doing something here?\u201d said Haag. \u201cIt opens up that line of communication, which can help make the organization work better.\u201d\r\n\r\n\u201cWe\u2019re able to more effectively and more efficiently provide services to residents,\u201d added Bayless."}],"references":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Visualization App Increases Financial Transparency<\/title>\n<meta name=\"description\" content=\"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Visualization App Increases Financial Transparency\" \/>\n<meta property=\"og:description\" content=\"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2020\/06\/arcnews-banner-datavisualizationapp-wide.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Data Visualization App Increases Financial Transparency\" \/>\n<meta name=\"twitter:description\" content=\"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2020\/06\/arcnews-banner-datavisualizationapp-wide.jpg\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency\",\n\t            \"name\": \"Data Visualization App Increases Financial Transparency\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2020-07-01T02:59:12+00:00\",\n\t            \"description\": \"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"Home\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"ArcNews Articles\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\/arcnews\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 3,\n\t                    \"name\": \"Data Visualization App Increases Financial Transparency\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/\",\n\t            \"name\": \"Esri\",\n\t            \"description\": \"Esri Newsroom\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/41c803b2ea8734c36f9c4e9586d1449d\",\n\t            \"name\": \"Amy Ambard\",\n\t            \"image\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/\",\n\t                \"url\": \"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g\",\n\t                \"caption\": \"Amy Ambard\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Visualization App Increases Financial Transparency","description":"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency","og_locale":"en_US","og_type":"article","og_title":"Data Visualization App Increases Financial Transparency","og_description":"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2020\/06\/arcnews-banner-datavisualizationapp-wide.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_title":"Data Visualization App Increases Financial Transparency","twitter_description":"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.","twitter_image":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2020\/06\/arcnews-banner-datavisualizationapp-wide.jpg","twitter_site":"@Esri","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency","url":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency","name":"Data Visualization App Increases Financial Transparency","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2020-07-01T02:59:12+00:00","description":"The Topeka Public Works Department uses ArcGIS Insights to organize and present budget information in an easy-to-understand way.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcnews\/data-visualization-app-increases-financial-transparency#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"ArcNews Articles","item":"https:\/\/www.esri.com\/about\/newsroom\/arcnews"},{"@type":"ListItem","position":3,"name":"Data Visualization App Increases Financial Transparency"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/about\/newsroom\/#website","url":"https:\/\/www.esri.com\/about\/newsroom\/","name":"Esri","description":"Esri Newsroom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/41c803b2ea8734c36f9c4e9586d1449d","name":"Amy Ambard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f356480172f8ad0bc8d72b855e84171c52f1944c7c7779f3e425d73bf3efa3c7?s=96&d=blank&r=g","caption":"Amy Ambard"},"url":""}]}},"sort_order":"13","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/349451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcnews"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/5752"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews\/349451\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=349451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=349451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=349451"},{"taxonomy":"arcnews_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcnews_issues?post=349451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}