{"id":1635,"date":"2016-04-22T14:00:31","date_gmt":"2016-04-22T14:00:31","guid":{"rendered":"https:\/\/www.microsoft.com\/industry\/blog\/uncategorized\/bringing-government-data-to-life-with-power-bi\/"},"modified":"2023-05-31T16:34:45","modified_gmt":"2023-05-31T23:34:45","slug":"bringing-government-data-to-life-with-power-bi","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/","title":{"rendered":"Bringing government data to life with Power BI"},"content":{"rendered":"

In today\u2019s digital era, governments across the globe are amassing larger amounts of data than ever before, publishing an increasing quantity as open data for anyone to use. Indeed, the analyst firm Gartner<\/a> predicts that more than 30 percent of digital government projects will treat any data as open data by 2018.<\/p>\n

As the amount of open data grows, the key is turning it into actionable insights that lead to higher-quality decisions. Yet analyzing the skyrocketing quantity of information can be an overwhelming task. Microsoft Power BI<\/a> is designed to help customers overcome this challenge by making it simple to transform vast amounts of data into rich visuals that can be examined from multiple perspectives. By reviewing data in visual form, governments can more easily identify critical patterns that move their communities forward.<\/p>\n

To demonstrate how Power BI can improve government effectiveness, we recently leveraged open data to show how governments can turn publicly available data into critical insights. We leverage open data in four areas of interest\u2014optimizing transportation, promoting job growth, addressing citizen complaints, and analyzing government budgets\u2014to spot patterns that can help government leaders better focus their efforts.<\/p>\n

In each of these instances, we used Power BI to visually display large amounts of data to easily examine the information by different variables\u2014and ultimately obtain key insights that can improve how communities are governed:<\/p>\n

Optimizing transportation<\/h2>\n

Accessing Australian car accidents data, we obtained detailed breakouts of vehicle collisions across the continent, including the time, location, and severity of the accident; the participants involved; whether alcohol was a factor; and much more.<\/p>\n

Analyzing this data, we were able to identify the seasonality of accidents, with the lowest occurring in the winter months, and the highest in the summer and early fall. We concluded that the majority of accidents are vehicle-to-vehicle crashes, with collisions with fixed objects as a predominant second. We also observed a gradual climb in the number of accidents as the day progresses, with the exception of 8 a.m., where there is an abnormal surge in accidents.<\/p>\n

With information such as this at hand, governments can create more measures to prevent vehicle-to-vehicle collisions, especially in the summer months. They can also put measures into place to prevent the high volume of accidents during morning rush hour and evening hours.<\/p>\n

Promoting job growth<\/h2>\n

Using Canada\u2019s employment and social development data, we were able to identify where the majority of Canada\u2019s workforce resides, knowing that a large percentage works in the retail, healthcare and manufacturing sectors. By displaying this data in a map layout, we were able to see employment data by province, with the size of each bubble indicating the number of those employed in each area. These insights could be used for job education and training programs aimed at growing industries where more workers are needed.<\/p>\n

Addressing citizen complaints<\/h2>\n

Analyzing New York City\u2019s detailed 311 data, we obtained detailed information about the calls being made, including the time of day, location, incident type, and agency involved\u2014leading to insights about where the city can ramp up its services.<\/p>\n

Analyzing citizen complaints by month, for example, we were able to see that the highest number of complaints in February were related to street conditions, blocked driveways, and snow. Similarly, analyzing certain types of complaints by time of day, we learned that most garbage-related complaints occur between 8 a.m. and 11 a.m., while most noise-related complaints occur between 11 p.m. and 3 a.m. With these insights, the city could secure snow removal equipment before it\u2019s needed. It could also work with trash removal services to deter complaints, while enforcing noise ordinances during the hours when complaints are highest.<\/p>\n

Analyzing government budgets<\/h2>\n

Lastly, we examined San Francisco\u2019s budget data from 2010 to 2016, gathering detailed information at the departmental level. Visualizing this information using Power BI, we could easily observe where budgets are growing. We could also see where most of the revenue is being generated.<\/p>\n

By comparing revenue to spending by department, for example, we observed that Public Works, Transportation, and Commerce make up the vast majority of both spending and revenue for the city. Examining this data in greater detail, we were also able to see which departments are consistently over budget from year to year. With these insights, the city could either allocate larger budgets to those departments that consistently come in over budget, or focus on ways to increase revenue or cut back spending within those groups.<\/p>\n

These are a few of the ways governments can turn data into critical insights. By putting increasing volumes of data to better use with Power BI, governments have the opportunity to improve efficiency while better serving their constituents. To learn more, please see the Microsoft Power BI blog<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft leverages open data to showcase how government data can be transformed into meaningful insights with Power BI.<\/p>\n","protected":false},"author":0,"featured_media":9779,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"categories":[1515],"post_tag":[],"content-type":[1483],"coauthors":[951],"class_list":["post-1635","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-government","content-type-thought-leadership"],"yoast_head":"\nBringing government data to life with Power BI - Microsoft Industry Blogs<\/title>\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.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bringing government data to life with Power BI - Microsoft Industry Blogs\" \/>\n<meta property=\"og:description\" content=\"Microsoft leverages open data to showcase how government data can be transformed into meaningful insights with Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Industry Blogs\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-22T14:00:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-31T23:34:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Parul Bhandari\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/author\/parul-bhandari_1\/\",\"@type\":\"Person\",\"@name\":\"Parul Bhandari\"}],\"headline\":\"Bringing government data to life with Power BI\",\"datePublished\":\"2016-04-22T14:00:31+00:00\",\"dateModified\":\"2023-05-31T23:34:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\"},\"wordCount\":800,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg\",\"articleSection\":[\"Government\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\",\"name\":\"Bringing government data to life with Power BI - Microsoft Industry Blogs\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg\",\"datePublished\":\"2016-04-22T14:00:31+00:00\",\"dateModified\":\"2023-05-31T23:34:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg\",\"width\":2000,\"height\":1000,\"caption\":\"Three people discussing business while looking at laptop.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bringing government data to life with Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/\",\"name\":\"Microsoft Industry Blogs\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#organization\",\"name\":\"Microsoft Industry Blogs\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft Industry Blogs\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bringing government data to life with Power BI - Microsoft Industry Blogs","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.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Bringing government data to life with Power BI - Microsoft Industry Blogs","og_description":"Microsoft leverages open data to showcase how government data can be transformed into meaningful insights with Power BI.","og_url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/","og_site_name":"Microsoft Industry Blogs","article_published_time":"2016-04-22T14:00:31+00:00","article_modified_time":"2023-05-31T23:34:45+00:00","og_image":[{"width":2000,"height":1000,"url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 min read","Written by":"Parul Bhandari"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/author\/parul-bhandari_1\/","@type":"Person","@name":"Parul Bhandari"}],"headline":"Bringing government data to life with Power BI","datePublished":"2016-04-22T14:00:31+00:00","dateModified":"2023-05-31T23:34:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/"},"wordCount":800,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg","articleSection":["Government"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/","url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/","name":"Bringing government data to life with Power BI - Microsoft Industry Blogs","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg","datePublished":"2016-04-22T14:00:31+00:00","dateModified":"2023-05-31T23:34:45+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2016\/04\/government-data-2.jpg","width":2000,"height":1000,"caption":"Three people discussing business while looking at laptop."},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/government\/2016\/04\/22\/bringing-government-data-to-life-with-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/"},{"@type":"ListItem","position":2,"name":"Bringing government data to life with Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/","name":"Microsoft Industry Blogs","description":"","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#organization","name":"Microsoft Industry Blogs","url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft Industry Blogs"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Industry Blogs","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/industry\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/posts\/1635"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/comments?post=1635"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/posts\/1635\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/media\/9779"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/media?parent=1635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/categories?post=1635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/post_tag?post=1635"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/content-type?post=1635"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/industry\/blog\/wp-json\/wp\/v2\/coauthors?post=1635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}