{"id":155,"date":"2011-06-29T14:04:15","date_gmt":"2011-06-29T21:04:15","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=155"},"modified":"2011-08-09T11:05:35","modified_gmt":"2011-08-09T18:05:35","slug":"most-effective-business-intelligence-charts-and-graphs","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2011\/06\/most-effective-business-intelligence-charts-and-graphs\/","title":{"rendered":"Most Effective Business Intelligence Charts And Graphs"},"content":{"rendered":"<p>As software vendors flood us with flashy dashboards and widgets for our BI projects, some of which clearly obscure information more than they illuminate, I started\u00a0 hunting for research documenting which methods of charting are the most effective.\u00a0 Naomi B. Robbins \"Creating More Effective Graphs\" presentation fits the bill (turns out the presentation is based on her book of the same name: <a href=\"http:\/\/www.amazon.com\/gp\/product\/047127402X\/ref=as_li_ss_tl?ie=UTF8&amp;tag=grocwine-20&amp;linkCode=as2&amp;camp=217145&amp;creative=399369&amp;creativeASIN=047127402X\">Creating More Effective Graphs<\/a>).\u00a0 Good stuff and exactly what I needed.\u00a0 I bulleted out some of the key points<!--more--> below but the document itself is only eight pages and a very easy read.\u00a0 Link to the presentation is at the end of this post.\u00a0 (Strangely, Robbins doesn't recommend my personal favorite: <a title=\"Radar Chart?  You must be kidding.\" href=\"http:\/\/www.sqldbpros.com\/2011\/06\/radar-chart-you-must-be-kidding\/\">The Radar Chart<\/a>.)<\/p>\n<p>Key Points:<\/p>\n<ul>\n<li>One graph is considered more effective than another if it's quantitative information can be decoded more quickly or more easily by most observers.<\/li>\n<li>A table is often very effective for small data sets.<\/li>\n<li>Avoid putting extra dimensions in your charts. The pseudo three-dimensional charts are difficult to read. If you know categories and values for each category, a two-dimensional chart is clearer than a pseudo three-dimensional one.<\/li>\n<li>Data labels don\u2019t help; they confuse the reader even more.<\/li>\n<li>It is difficult to determine trends from stacked bar charts unless we are looking at the bottom category since lengths without a common baseline are difficult to compare.<\/li>\n<li>Dot plots allow us to decode the data by making judgments of positions along the common horizontal scale. Experiments have shown that this is the most accurate of the elementary graphical tasks.<\/li>\n<li>We judge position along identical nonaligned scales almost as accurately as position along a common scale.<\/li>\n<li>Alphabetical order is rarely the most effective. Ordering by size is often better.<\/li>\n<li>Bar charts get cluttered more quickly than dot plots.<\/li>\n<li>Eliminate unnecessary clutter. Look at the graph and notice what you see first. The answer should be the data (or model) and not grid lines, long labels, or other graphical elements.<\/li>\n<li>Reduce clutter by: 1. showing axes labels in thousands, millions, or billions instead of including strings of zeros. 2. Label an axis as percent or dollars rather than including a percent sign or dollar symbol at each tick mark label.<\/li>\n<\/ul>\n<p>The original presentation on Creating More Effective Graphs can be found <a href=\"http:\/\/www.statoo.com\/gss06\/presentations\/Robbins.pdf\">here<\/a>.<\/p>\n<p>Robbins' book can be found on Amazon here:<br \/>\n<a href=\"http:\/\/www.amazon.com\/gp\/product\/047127402X\/ref=as_li_ss_il?ie=UTF8&amp;tag=grocwine-20&amp;linkCode=as2&amp;camp=217145&amp;creative=399369&amp;creativeASIN=047127402X\"><img decoding=\"async\" src=\"http:\/\/ws.assoc-amazon.com\/widgets\/q?_encoding=UTF8&amp;Format=_SL160_&amp;ASIN=047127402X&amp;MarketPlace=US&amp;ID=AsinImage&amp;WS=1&amp;tag=grocwine-20&amp;ServiceVersion=20070822\" alt=\"\" border=\"0\" \/><\/a><img loading=\"lazy\" decoding=\"async\" style=\"border: none !important; margin: 0px !important;\" src=\"http:\/\/www.assoc-amazon.com\/e\/ir?t=&amp;l=as2&amp;o=1&amp;a=047127402X&amp;camp=217145&amp;creative=399369\" alt=\"\" width=\"1\" height=\"1\" border=\"0\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As software vendors flood us with flashy dashboards and widgets for our BI projects, some of which clearly obscure information more than they illuminate, I started\u00a0 hunting for research documenting which methods of charting are the most effective.\u00a0 Naomi B. Robbins \"Creating More Effective Graphs\" presentation fits the bill (turns out the presentation is based [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,26],"tags":[20,25,28,170,27,5],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-businss-intelligence","category-charts-and-graphs","tag-business-intelligence","tag-chart","tag-dashboard","tag-excel","tag-graph","tag-tips"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":7,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":169,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/155\/revisions\/169"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}