3 Super Handy Tableau Features

(1) Shelf calculations (also known as ad-hoc calculations or in-line calculations) are quickies that you can create by double clicking on Marks, Row, Columns and Measure Values Since shelf calculations are not added to your dataset, they're not re-usable between different worksheets in a workbook, which means that they're not a sustainable way of building a … Continue reading 3 Super Handy Tableau Features

Tracking progress against goals

Remember doughnut charts? Yes, next to neatly visualizing shares of totals, they can also make decent progress trackers! You'll need to create a couple of additional calculations to help you create a progress doughnut chart, however: A parameter where you can dynamically input your Sales Target 2. Sales Remaining = Sales Target - Sales 3. … Continue reading Tracking progress against goals

How can I sort by the values of a sub-category in Tableau?

I was thrilled to attend a live #MakeoverMonday at the Netherlands Tableau User Group today. https://twitter.com/VizWizBI/status/978687243224322049 We were given 45 minutes to re-design the following viz I decided to go for a simple bar chart with a few twists As it was an inverted scale in which 1 would represent the highest rank and 10 … Continue reading How can I sort by the values of a sub-category in Tableau?

How do I build a Pareto chart in Tableau?

What is a Pareto chart, though? A Pareto chart is simply an illustration of the well-known Pareto principle, stating that roughly 80% of the effects are driven by 20% of the causes. Applied to business, this often translates in companies achieving 80% of their revenue with 20% of their customers. Economics is not much different. … Continue reading How do I build a Pareto chart in Tableau?

Which countries have signed and ratified the Istanbul Convention?

Have you heard of the Istanbul Convention? It's been quite the controversial topic lately with Bulgaria backtracking on its ratification. https://twitter.com/StanaIliev/status/972024066902196224 Curious to see where the other European countries stood on this, I whipped up a Tableau Public viz The first map shows the countries that have signed and the year in which they did. The … Continue reading Which countries have signed and ratified the Istanbul Convention?

Let’s visualize those sales and profits in a butterfly chart!

Searching for another way to visualize sales and discount in the same graph? You find the lollipop chart insufficiently informative? Then you might consider the butterfly chart So, what does a brief inspection of these charts tell us? • Hefty discounts do little to boost sales in the Netherlands • Despite being in the top … Continue reading Let’s visualize those sales and profits in a butterfly chart!

How Do I Quickly Tweak All Files in a Folder?

I recently got hooked on Tableau Public. It's pretty awesome! One of the downsides, however, is the need to find yourself some interesting "open" datasets to visualize. As the number of prospective students at British universities has long been of interest to me, I thought I'd check out if UCAS had any publicly available data … Continue reading How Do I Quickly Tweak All Files in a Folder?