With the release of Tableau Desktop Public Edition 9.0, there's a ton of goodies for journalists, bloggers, and viz fans to be excited for. For me, the most exciting features are the ones that make data cleanup easier.
We've all been there. You get all excited about a great new dataset but when you open it up in Excel there's merged cells, blank rows and columns, cross-tabbed data and all of those other spreadsheet things that make us cry. It's never fun to come to realization that you'll have to spend the next couple hours of your life reformatting a dataset so that you can get it into Tableau and let the data party begin. Luckily, version 9.0 comes with a few handy new features that should save you lots of time and headaches!
One of the easiest new features to use is the Data Interpreter. This tool cleans up merged cells, titles, footnotes, blank rows, and all kinds of other annoying stuff. Just click the button to turn the data interpreter on and that messy dataset above starts to look pretty nice: