{"id":12079,"date":"2009-09-21T13:43:14","date_gmt":"2009-09-21T12:43:14","guid":{"rendered":"http:\/\/timoelliott.com\/blog\/?p=1250"},"modified":"2009-09-21T13:43:14","modified_gmt":"2009-09-21T12:43:14","slug":"bi-fail-2","status":"publish","type":"post","link":"https:\/\/timoelliott.com\/blog\/2009\/09\/bi-fail-2.html","title":{"rendered":"BI FAIL #2"},"content":{"rendered":"<p><a href=\"http:\/\/sethgrimes.com\/\" target=\"_blank\">Seth Grimes<\/a> of Alta Plana gives us a <a href=\"http:\/\/www.intelligententerprise.com\/blog\/archives\/2009\/09\/serious_design.html\" target=\"_blank\">great example of business intelligence failure<\/a> this week on the site <a href=\"http:\/\/usaspending.gov\" target=\"_blank\">USAspending.gov<\/a>.<\/p>\n<p>I wrote about this site and others in a post in July, <a href=\"https:\/\/timoelliott.com\/blog\/2009\/07\/great-examples-of-us-government-bi-transparency.html\" target=\"_blank\">Great Examples of US Government BI Transparency<\/a>. Unfortunately, it turns out that it\u2019s not so great, in that some of the data shown was completely false\u2026 (this is generally considered a reasonable baseline of things to avoid).<\/p>\n<p>Seth gave the example of the graphic on the left below: \u201cThe Green and Purple segments are approximately equally sized even though the green segment should be 25% larger than the purple segment\u201d.\u00a0 Thankfully the problem has now been corrected, and the site now shows what the chart should look like (with the data values now slightly updated) \u2013 see how much larger the \u201cgrants\u201d area is now.<\/p>\n<p><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/altaplana.com\/USAspending.png\" alt=\"USAspending.gov graphic\" \/><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0px;\" title=\"image\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/09\/image9.jpg?resize=319%2C362&#038;ssl=1\" border=\"0\" alt=\"image\" width=\"319\" height=\"362\" \/><\/p>\n<p>The problem turned out to be with the way the site calls the <a href=\"http:\/\/code.google.com\/apis\/chart\/\">Google Chart API<\/a>. The values passed to the engine for display were absolute values, not percentages, so they are being truncated. (I\u2019m biased, of course, but to me, that sounds like a good reason to rely on a full BI solution, rather than the Google Chart API\u2026 )<\/p>\n<p>The real big cause for concern is that it was apparently only when the webmasters read Seth\u2019s blog posting that they realized they had a problem\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Business Intelligence Fail #2 &#8212; showing a chart that&#8217;s completely different from the data, on the site USAspending.gov<\/p>\n","protected":false},"author":2,"featured_media":6132,"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":[21],"tags":[160,198,213,240,483],"class_list":["post-12079","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-fail","tag-bi","tag-business-analytics","tag-businessobjects","tag-chart","tag-fail"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2014\/01\/USAspending-1.png?fit=369%2C375&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3X9RF-38P","_links":{"self":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12079","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=12079"}],"version-history":[{"count":0,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media\/6132"}],"wp:attachment":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media?parent=12079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/categories?post=12079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/tags?post=12079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}