{"id":12054,"date":"2009-07-01T11:28:59","date_gmt":"2009-07-01T10:28:59","guid":{"rendered":"http:\/\/timoelliott.com\/blog\/?p=1028"},"modified":"2009-07-01T11:28:59","modified_gmt":"2009-07-01T10:28:59","slug":"great-examples-of-us-government-bi-transparency","status":"publish","type":"post","link":"https:\/\/timoelliott.com\/blog\/2009\/07\/great-examples-of-us-government-bi-transparency.html","title":{"rendered":"Great Examples of US Government BI Transparency"},"content":{"rendered":"<p>We\u2019re clearly entering a new era in government transparency, and we can hope that allowing citizens to access information interactively through business intelligence functionality to spot inefficiencies and opportunities will be a big part of transforming the way the public sector works.<\/p>\n<p>In my previous post, I talked about how the American Recovery and Reinvestment act is perhaps the largest, most complex business intelligence application ever. And since the US has now appointed its <a href=\"http:\/\/www.theiia.org\/blogs\/marks\/index.cfm\/post\/Chief%20Performance%20Officer\" target=\"_blank\">first ever \u201cChief Performance Officer\u201d<\/a>, <a href=\"http:\/\/en.wikipedia.org\/wiki\/Nancy_Killefer\" target=\"_blank\">Nancy Killefer<\/a>, who will work with economic officials to increase efficiencies and eliminate waste in government spending, it seemed like a great time to talk about other great examples of US government transparency and business intelligence.<\/p>\n<h3>Open Government<\/h3>\n<p>The Recovery Act is only one tiny part of government transparency. <a href=\"https:\/\/www.sdn.sap.com\/irj\/servlet\/prt\/portal\/prtroot\/com.sap.sdn.businesscard.SDNBusinessCard?u=O1lRpOj\/T%2BQ%3D\" target=\"_blank\">Dan Everett Jr<\/a>. of SAP has written <a href=\"https:\/\/www.sdn.sap.com\/irj\/scn\/weblogs?blog=\/pub\/wlg\/14572\" target=\"_blank\">a great blog post<\/a> about the subject and points out that in May the National Academy of Public Administration started soliciting input from the public on how to make the government more transparent at <a href=\"http:\/\/opengov.ideascale.com\/\">http:\/\/opengov.ideascale.com\/<\/a> (sadly, there\u2019s no moderator on the site, and the nutters have taken over: check out <a href=\"http:\/\/opengov.ideascale.com\/akira\/ideafactory.do?discussionID=2236\" target=\"_blank\">the dialog around making data more accessible<\/a>).<\/p>\n<p><a href=\"http:\/\/opengov.ideascale.com\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image13\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image13.jpg?resize=690%2C443&#038;ssl=1\" border=\"0\" alt=\"image13\" width=\"690\" height=\"443\" \/><\/a><\/p>\n<p>Another Obama administration initiative, the <a href=\"http:\/\/data.gov\">http:\/\/data.gov<\/a> web site is starting to providing lots of other US government data to anybody who wants to analyze it:<\/p>\n<blockquote><p>\u201cThe purpose of Data.gov is to increase public access to high value, machine readable datasets generated by the Executive Branch of the Federal Government. Although the initial launch of Data.gov provides a limited portion of the rich variety of Federal datasets presently available, we invite you to actively participate in shaping the future of Data.gov by suggesting additional datasets and site enhancements to provide seamless access and use of your Federal data. Visit today with us, but come back often. With your help, Data.gov will continue to grow and change in the weeks, months, and years ahead.\u201d<\/p><\/blockquote>\n<p><a href=\"http:\/\/data.gov\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image241\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image241.jpg?resize=690%2C570&#038;ssl=1\" border=\"0\" alt=\"image241\" width=\"690\" height=\"570\" \/><\/a><\/p>\n<p>There\u2019s a content for applications that can best make use of this data at <a href=\"http:\/\/sunlightlabs.com\/contests\/appsforamerica2\/\">http:\/\/sunlightlabs.com\/contests\/appsforamerica2\/<\/a><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image42\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image42.jpg?resize=690%2C248&#038;ssl=1\" border=\"0\" alt=\"image42\" width=\"690\" height=\"248\" \/><\/p>\n<p>There doesn\u2019t seem to be much uptake so far \u2013 maybe because the first submitted application seems a little trivial \u2013 it lets you play a memory game <a href=\"http:\/\/fbi.thatsaspicymeatball.com\/\" target=\"_blank\">with photos of FBI Fugitives culled from the FBI&#8217;s feeds of fugitives<\/a> (but it doesn\u2019t even tell you who they are!)<\/p>\n<p><a href=\"http:\/\/fbi.thatsaspicymeatball.com\/\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image34\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image34.jpg?resize=690%2C702&#038;ssl=1\" border=\"0\" alt=\"image34\" width=\"690\" height=\"702\" \/><\/a><\/p>\n<h3>Federal and Regional BI Examples<\/h3>\n<p>In an article on how <a href=\"http:\/\/www.b-eye-network.com\/view\/10641\" target=\"_blank\">ARRA Will be a Boon for Business Intelligence<\/a>, Dr. Ramon Barquin reports how education provisions are also driving business intelligence, and gives some examples of mandated metrics as communicated by the Department of Education last month:<\/p>\n<ul>\n<li>Number and percent of teachers and principals rated at each performance level in each local education association\u2019s (LEA) teacher evaluation system<\/li>\n<li>Number and percent of LEA teacher and principal evaluation systems that require evidence of student achievement outcomes<\/li>\n<li>Most recent math and reading National Assessment of Educational Progress (NAEP) scores<\/li>\n<li>Percent of ELLs and students with disabilities tested in math and English language arts (ELA)<\/li>\n<li>Number and percent of students who graduate and complete one year of college<\/li>\n<li>Number of schools in restructuring status that demonstrated substantial gains in achievement, closed or consolidated \u2013 last 3 years<\/li>\n<li>Number of schools in the bottom 5% of those schools that demonstrated substantial gains in student achievement, closed or consolidated \u2013 last 3 years<\/li>\n<li>Number and percent of schools in restructuring status that have made progress in math and ELA in last year<\/li>\n<li>Charter school caps, number operating, number closed<\/li>\n<\/ul>\n<p>The <a href=\"http:\/\/www.fec.gov\/\" target=\"_blank\">Federal Election Commission provides information about campaign financing<\/a><\/p>\n<p><a href=\"http:\/\/www.fec.gov\/DisclosureSearch\/mapHSApp.do?election_yr=2010\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image101\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image101.jpg?resize=692%2C517&#038;ssl=1\" border=\"0\" alt=\"image101\" width=\"692\" height=\"517\" \/><\/a><\/p>\n<p>The State of Washington Transportation Improvement Board, an independent state agency that makes and manages street construction and maintenance grants throughout Washington State, uses <a href=\"http:\/\/www.tib.wa.gov\/performance\/Dashboard\/\" target=\"_blank\">Xcelsius dashboards<\/a> to manage the agency\u2019s $200 million of revenues generated from state gas taxes. In a nice example of transparency, they <a href=\"http:\/\/www.tib.wa.gov\/performance\/Performance.cfm\" target=\"_blank\">provide the public with the same view<\/a> as the agency\u2019s Executive Director.<\/p>\n<p><a href=\"http:\/\/www.tib.wa.gov\/performance\/Dashboard\/\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image23\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image23.jpg?resize=690%2C451&#038;ssl=1\" border=\"0\" alt=\"image23\" width=\"690\" height=\"451\" \/><\/a><\/p>\n<p>Some of the benefits the agency has realized include<\/p>\n<ul>\n<li>Reduced delayed projects by 70%, saving millions in public funds<\/li>\n<li>Reduced accidents by 19% and injuries by 30%<\/li>\n<li>Reduced average payment cycle from 5 months to 17 days<\/li>\n<\/ul>\n<p>New York City has a <a href=\"http:\/\/www.nyc.gov\/html\/ops\/nycstat\/html\/home\/home.shtml\" target=\"_blank\">huge range of different statistics<\/a> available, e.g. my neighborhood statistics:<\/p>\n<blockquote><p>NYCStat is New York City\u2019s one-stop-shop for all essential data, reports, and statistics related to City services. Available at www.nyc.gov, NYCStat provides access to a wide array of performance-related information including citywide and agency-specific information, 311-related data, and interactive mapping features for selected performance data and quality-of-life indicators.<\/p><\/blockquote>\n<p><a href=\"http:\/\/www.nyc.gov\/html\/ops\/nycstat\/html\/home\/home.shtml\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image16[1]\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image161.jpg?resize=690%2C379&#038;ssl=1\" border=\"0\" alt=\"image16[1]\" width=\"690\" height=\"379\" \/><\/a><\/p>\n<p>The State of Washington has a <a href=\"http:\/\/www.accountability.wa.gov\/default.asp\" target=\"_blank\">public \u201cGovernment Management Accountability &amp; Performance\u201d site<\/a> that provides easy access to dashboards of key performance indicators in areas such as economic vitality, government efficiency, health care, public safety, transportation, etc.<\/p>\n<p><a href=\"http:\/\/www.accountability.wa.gov\/default.asp\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image.jpg?resize=690%2C427&#038;ssl=1\" border=\"0\" alt=\"image\" width=\"690\" height=\"427\" \/><\/a><\/p>\n<p><a href=\"http:\/\/performance.wa.gov\/Pages\/default.aspx\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image1.jpg?resize=690%2C425&#038;ssl=1\" border=\"0\" alt=\"image\" width=\"690\" height=\"425\" \/><\/a><\/p>\n<p>The State of Maryland has \u201c<a href=\"http:\/\/www.statestat.maryland.gov\/reports.asp\" target=\"_blank\">StateStat<\/a>\u201d that provides dozens of key performance indicators from different state agencies (agriculture, environment, general services, state police, transportation, etc.)<\/p>\n<p><a href=\"http:\/\/www.statestat.maryland.gov\/reports.asp\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image2.jpg?resize=690%2C518&#038;ssl=1\" border=\"0\" alt=\"image\" width=\"690\" height=\"518\" \/><\/a><\/p>\n<p>The <a href=\"http:\/\/www.cityofhenderson.com\/budget_strategic_management\/index.php\" target=\"_blank\">City of Henderson in Nevada<\/a> uses <a href=\"http:\/\/www.sap.com\/solutions\/sapbusinessobjects\/large\/enterprise-performance-management\/strategy\/index.epx\" target=\"_blank\">SAP\u2019s Strategy Management software<\/a> to track the strategic planning process, and then <a href=\"http:\/\/www.cityofhenderson.com\/budget_strategic_management\/docs\/strategic_plan\/2007_Progress_Report.pdf\" target=\"_blank\">provides that information to residents<\/a>:<\/p>\n<p><a href=\"http:\/\/www.cityofhenderson.com\/budget_strategic_management\/docs\/strategic_plan\/2007_Progress_Report.pdf\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image3.jpg?resize=690%2C459&#038;ssl=1\" border=\"0\" alt=\"image\" width=\"690\" height=\"459\" \/><\/a><\/p>\n<p>Other countries are getting in on the act, too. For example, the British Prime Minister has announced that Sir Tim Berners-Lee, the inventor of the web and an eager proponent of better access to government data, <a href=\"http:\/\/www.guardian.co.uk\/technology\/2009\/jun\/10\/berners-lee-downing-street-web-open\" target=\"_blank\">will be helping the government make more of its data available online<\/a><\/p>\n<h3>Think-Tanks and Watchdogs<\/h3>\n<p>The <a href=\"http:\/\/www.pewcenteronthestates.org\/\" target=\"_blank\">Pew Center on the States<\/a> web site has followed state government performance for more than a decade, studying good and bad practices and analyzing what works. Their conclusion is that results-based budgeting systems works: states cut wasteful spending on programs that are not showing results, and instead direct the resources to more effective :<\/p>\n<blockquote><p>\u201dThe unfortunate truth is that most states today do not have the tools in place to make well-informed programmatic and budget decisions. There is no way\u00a0 to know how much money states lose to mismanaged or underperforming programs. But those states that have begun to make policy decisions based on data<br \/>\nmeasuring the performance of government, a process called \u201cperformance-driven budgeting,\u201d have saved impressive amounts of money\u2014some in very short periods of time. The choices they have made have not been easier, but they have been smarter.\u201d<\/p><\/blockquote>\n<p><a href=\"http:\/\/www.pewcenteronthestates.org\/\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image52\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image52.jpg?resize=690%2C564&#038;ssl=1\" border=\"0\" alt=\"image52\" width=\"690\" height=\"564\" \/><\/a><br \/>\nThe excellent <a href=\"http:\/\/www.gradingthestates.com\" target=\"_blank\">Grading the States<\/a> web site puts the Pew data into dashboard format, making it easy to compare states\u2019 performance.<\/p>\n<p><a href=\"http:\/\/www.gradingthestates.com\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image43\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image43.jpg?resize=692%2C571&#038;ssl=1\" border=\"0\" alt=\"image43\" width=\"692\" height=\"571\" \/><\/a><\/p>\n<p>Here are some interactive models from the site, using <a href=\"http:\/\/www.sap.com\/solutions\/sapbusinessobjects\/sme\/xcelsius\/index.epx\">Xcelsius dashboards<\/a> &#8212; give them a try!<\/p>\n<p>[kml_flashembed fversion=&#8221;8.0.0&#8243; movie=&#8221;http:\/\/www.gradingthestates.com\/benchmarker.swf&#8221; targetclass=&#8221;flashmovie&#8221; publishmethod=&#8221;static&#8221; width=&#8221;690&#8243; height=&#8221;500&#8243;]<\/p>\n<p><a href=\"http:\/\/adobe.com\/go\/getflashplayer\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.adobe.com\/images\/shared\/download_buttons\/get_flash_player.gif\" alt=\"Get Adobe Flash player\" \/><\/a><\/p>\n<p>[\/kml_flashembed]<\/p>\n<p>[kml_flashembed fversion=&#8221;8.0.0&#8243; movie=&#8221;http:\/\/www.gradingthestates.com\/GPPMoney.swf&#8221; targetclass=&#8221;flashmovie&#8221; publishmethod=&#8221;static&#8221; width=&#8221;690&#8243; height=&#8221;750&#8243;]<\/p>\n<p><a href=\"http:\/\/adobe.com\/go\/getflashplayer\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.adobe.com\/images\/shared\/download_buttons\/get_flash_player.gif\" alt=\"Get Adobe Flash player\" \/><\/a><\/p>\n<p>[\/kml_flashembed]<\/p>\n<p>[kml_flashembed fversion=&#8221;8.0.0&#8243; movie=&#8221;http:\/\/www.gradingthestates.com\/allgppgrades.swf&#8221; targetclass=&#8221;flashmovie&#8221; publishmethod=&#8221;static&#8221; width=&#8221;690&#8243; height=&#8221;650&#8243;]<\/p>\n<p><a href=\"http:\/\/adobe.com\/go\/getflashplayer\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.adobe.com\/images\/shared\/download_buttons\/get_flash_player.gif\" alt=\"Get Adobe Flash player\" \/><\/a><\/p>\n<p>[\/kml_flashembed]<\/p>\n<p><a href=\"http:\/\/www.govtrack.us\/\" target=\"_blank\">Govtrack.us keeps track of representatives voting records<\/a><\/p>\n<p><a href=\"http:\/\/www.govtrack.us\/congress\/vote.xpd?vote=h2009-319\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image82\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image82.jpg?resize=692%2C530&#038;ssl=1\" border=\"0\" alt=\"image82\" width=\"692\" height=\"530\" \/><\/a><\/p>\n<p><a href=\"http:\/\/maplight.org\/\" target=\"_blank\">Maplight.org \u201cilluminates the connection between money and politics\u201d<\/a> by bringing together the campaign contributions of legislators and their voting records. Check out their <a href=\"http:\/\/maplight.org\/video\/2\/FedTourMay1662007.html\" target=\"_blank\">intro video<\/a> for a great overview.<\/p>\n<p><a href=\"http:\/\/maplight.org\/\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image911\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image911.jpg?resize=692%2C377&#038;ssl=1\" border=\"0\" alt=\"image911\" width=\"692\" height=\"377\" \/><\/a><\/p>\n<h3>Third-Party Sites that Promote Government Transparency<\/h3>\n<p>The <a href=\"http:\/\/www.swivel.com\/data_sets\/list?view=tile&amp;tag_name=politics&amp;when=all_time&amp;sort=comments_count&amp;official=false&amp;filter=none&amp;sort_direction=ASC&amp;page=100&amp;category=true\" target=\"_blank\">Swivel.com web site features data that furthers public debate and increases transparency<\/a>, and lets people upload and share data from other sources (although the last uploads seem to have been a year ago?)<\/p>\n<p><a href=\"http:\/\/www.swivel.com\/data_sets\/list?view=tile&amp;tag_name=politics&amp;when=all_time&amp;sort=comments_count&amp;official=false&amp;filter=none&amp;sort_direction=ASC&amp;page=100&amp;category=true\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image62\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image62.jpg?resize=692%2C503&#038;ssl=1\" border=\"0\" alt=\"image62\" width=\"692\" height=\"503\" \/><\/a><\/p>\n<p>IBM\u2019s <a href=\"http:\/\/manyeyes.alphaworks.ibm.com\/manyeyes\/visualizations?q=government\" target=\"_blank\">ManyEyes site does something very similar<\/a><\/p>\n<p><a href=\"http:\/\/manyeyes.alphaworks.ibm.com\/manyeyes\/visualizations?q=government\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"image72\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image72.jpg?resize=692%2C583&#038;ssl=1\" border=\"0\" alt=\"image72\" width=\"692\" height=\"583\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.statestat.maryland.gov\/reports.asp\"><\/a><\/p>\n<p>The New York Times has a <a href=\"http:\/\/projects.nytimes.com\/crime\/homicides\/map\" target=\"_blank\">homicide analytics map<\/a>:<\/p>\n<p><a href=\"http:\/\/projects.nytimes.com\/crime\/homicides\/map\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; display: inline; border-left: 0px; border-bottom: 0px\" title=\"image4[1]\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/07\/image41.jpg?resize=690%2C418&#038;ssl=1\" border=\"0\" alt=\"image4[1]\" width=\"690\" height=\"418\" \/><\/a><\/p>\n<p><a href=\"http:\/\/fbi.thatsaspicymeatball.com\/\" target=\"_blank\"><\/a><\/p>\n<h3>Optimizing BI from Governments<\/h3>\n<p>The list above obviously only scratches the surface \u2013 there are many, many other US public sector bodies that are publishing information online.<\/p>\n<p>The scattering of different projects across the different agencies and bodies is similar to the silos of BI projects inside large organizations, with many of the same problems.<\/p>\n<p>There are three in particular that will need to be addressed:<\/p>\n<p><strong>Not enough goals.<\/strong> As <a href=\"http:\/\/www.tholis.com\">Jos van Dongen<\/a> pointed out to me <a href=\"twitter.com\/josvandongen\">on Twitter<\/a>, the most glaring thing missing from most of these performance dashboards is concrete goals: numbers themselves are meaningless unless you have something to compare them to. <\/p>\n<p><strong>Not enough marketing.<\/strong> There\u2019s not enough emphasis on \u201cwhat you can do with this data\u201d. It\u2019s the classic business intelligence \u201cbuild it and they will come issue\u201d. Right now, the sites above all emphasize what data they have, but few of them have good examples of what you can actually do usefully with the data, or great examples of what others have done. Without this, government BI will face the same problem as many private projects: low usage and no grasp of any return on investment, leading to disinvestment over time.<\/p>\n<p><strong>Not enough standards.<\/strong> As you can tell from the bewildering variety of formats and statistics above, there\u2019s clearly a lack of standards on what should be tracked, and how data can be compared between different states and agencies, and the choice of indicators changes over time.<\/p>\n<p>This is exactly the same problems faced by organizations (right down to the choice of KPIs \u2013 a change of State Governor is much like a change of top executive \u2013 in both cases, they are likely to feel like they have to \u201cchange the agenda\u201d and use different KPIs than their predecessor).<\/p>\n<p>In companies, a BI competency center is the recommended approach, a body that explicitly has the authority to overview the different BI projects that are going on within the organization, and impose standards (tools, metadata, definitions, reporting formats\u2026).<\/p>\n<p>How will this be handled for the US Government? The fact that there are sites that now have the job of gathering information across the country, like <a href=\"http:\/\/recovery.gov\" target=\"_blank\">recovery.gov<\/a> and <a href=\"http:\/\/data.gov\" target=\"_blank\">data.gov<\/a> will help, and external organizations like the Pew Trust will help encourage areas. But these pressures alone will not be sufficient.<\/p>\n<p>Ultimately, help will probably come primarily from organizations like the United Nations. As part of their work, they help organizations compare performance in various areas, such as education. They publish league tables of countries that encourage participation, and they have the mechanisms required to negotiate standards that everybody can agree on.<\/p>\n<p>These standards are then increasingly used within countries as well &#8212; although, just like in organizations, some nations prefer their own, \u201cbetter\u201d or \u201cmore adapted\u201d statistics (cynics might call this \u201cleaving wriggle room to explain away bad numbers\u201d).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since the US has now appointed its first ever \u201cChief Performance Officer\u201d, it seems like a great time to talk about other great examples of US government transparency and business intelligence.<\/p>\n","protected":false},"author":2,"featured_media":6150,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2],"tags":[154,160,164,204,320,854,911,1083,1151],"class_list":["post-12054","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practice","tag-benchmarking","tag-bi","tag-bi-competency-center","tag-business-intelligence","tag-dashboard","tag-public-sector","tag-sap","tag-transparency","tag-xcelsius"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2014\/01\/image13-1.jpg?fit=690%2C443&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3X9RF-38q","_links":{"self":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12054","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/comments?post=12054"}],"version-history":[{"count":0,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media\/6150"}],"wp:attachment":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media?parent=12054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/categories?post=12054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/tags?post=12054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}