This chart also addresses the comparison problems. Note that I would normally have ordered the categories alphabetically, but I sorted them in the same order as the Nielsen viz so that you could compare the mine and their’s more easily.Ī second alternative would be a simple bar chart like this.
Look at Downloaded Music in Italy now: 20% now looks like it’s a bit less than 1/3 the size of the US bubble (62%). It’s easier to compare bubble sizes, you don’t have to lookup the colors since they’re organized in columns, and the bubble sizes are relative to each other. With this viz, it’s so much easier to compare values both across and down. First, if you like the bubbles, then a viz like this works. There are two better alternatives for presenting this data. Maybe they’re ordered by the total? Nope. At first I thought they were sized by the US percentages, but that’s not it.
You can’t tell me that the orange Italy bubble for Downloaded Music is 1/3 the size of the US bubble. The bubbles are not sized according to their percentage, making comparing bubble sizes meaningless and inaccurate.It kind of makes me feel like I’m in a tennis match. For example, your eyes are constantly pinging left to right to left trying to compare the UK values. The data is not aligned vertically, making comparisons across categories for the same country difficult.I find this chart hard to read and interpret because: With some simple fixes, this data can communicate much more effectively. The chart below comes from a recently released study by Nielsen. Although it has been tested to work on 32-bit and 64-bit versions of Excel you should back up your data before using it. Important: This tool is a free, unsupported, undocumented add-in from Tableau. We hope that this new version of the tool will speed up your analytics using Tableau and Excel files. The final change is the addition of 2 keyboard shortcuts to help speed up your process. Visually we have updated the UI so that it now has an Excel ribbon style interface making it easier to get to the buttons and generally making things a little easier on the eye. Press this and, hey presto, Tableau opens a new workbook connected to your current workbook. The biggest change is the addition of the “Open in Tableau” button.
#CURTIS HAIRSTON (1986 DOWNLOAD BLOGSPOT FREE#
For those who are not familiar with this tool, it’s a free add-in that helps you prepare your Excel files for analysis. Today we are releasing a new version of our data reshaper add-in for Excel 2007-2010 (32- and 64-bit). Andy Cotgreave did an excellent job upgrading the tool.įor more information on preparing Excel files for analysis, please click here. If you have been using the 4.1 version, there’s really not much difference. It’s recreated with the permission of Ross Perez. This blog post is mostly a duplication of the Reshaping Data Made Easy” blog post from Tableau Software.
0 kommentar(er)
