I was fascinated with a dashboard on the growth of patents and trademarks by Ross Perez and David Weiskopf, both of Tableau Software. It displays 124 years of patent and trademark data from a variety of countries.
You can see the original posts on Tableau’s blog and on David’s personal blog. I chose to enhance this further using the very limited space in David’s blog, 600 x 800 pixels.
I made the following enhancements to enable additional insights:
1) Removed the color legend and replaced it with a bar chart showing the ranking of the countries. The top and bottom countries automatically display the percent of total, showing the range of values for the current dashboard selections.
2) Added a filter by country to enable viewing details in smaller countries
3) Added a filter by year, to enable easy reduction of the range of data included in the views.
4) Removed percent of whole view in the bottom half of the trend plot and replaced it with an index of count, using a baseline year of 2007 which indexes to 100% for each country. This allows a consistent termination point across all countries.
Tags: Articles · Charts · Dashboard · Economy · Finance · Government · Graphs · Insights · Politics · Tableau · tableau public · Tableau Tips · Training1 Comment
Posted on August 10th, 2010 by
Great changes Stephen. I may have taken it even further. Ditch the map – I’m a sucker for maps (as often are clients..), but I’m not sure there’s any region by region information that’s useful enough to justify the space. The only caveat to this is if you added page information so you could see how regions/countries blossomed with time.
With more space, there’s now the opportunity for sparklines next to each bar – the chart at the bottom is great for comparing county to country (especially when using the action to highlight it), but looking at the changes within a country (especially for those with fewer filings) can be challenging. This is where the sparklines come in.
Here’s a link to my proposed version with sparklines:
http://public.tableausoftware.com/views/revisedtrends2inpatenttrademarkfilings/PatentandTrademarkFilings?:embed=yes&:toolbar=no&:tabs=no