License

Licensed under a Creative Commons License

Disclaimer

All data and information provided on this site is on an as-is basis and for informational purposes only. We do neither guarantee for accuracy, completeness, suitability or validity of information on this blog nor be liable for any errors in this information or any damages arising from its use. This blog may contain links to other web sites. We do not have any control over the content contained on those sites.

2 posts from August 2010

Thursday, August 26, 2010

Selected techniques to emulate a Tableau lookalike dashboard using Microsoft Excel, including some interactive features similar to Tableau Actions

The recent post described the power of Tableau Actions. Tableau actions allow you to add context and user-defined interactivity features across your workbook. If the user clicks on one of your visualizations, Actions give you full control over what should happen on other worksheets or visualizations. Setting up a Tableau dashboard with various actions like filtering, highlighting and linking to web pages is a piece of cake.

How about Microsoft Excel? Is it possible to implement a similar interactivity on a Microsoft Excel dashboard? Yes it is.

Sunday, August 22, 2010

How to create highly interactive Tableau dashboards using actions: a step-by-step tutorial and an example workbook

Even if you are creating the most basic chart with Tableau Software, the visualization already includes a great set of interactive features without the need for using special functionality: clicking on a data point highlights this point and shades off all others. Clicking on an entry in a color legend highlights all data points belonging to this category. Hovering over data points displays tooltips with all used underlying data, and so forth.

However, Tableau offers even more than that: Tableau actions. Basically, actions are Tableau’s way of sending user interactions across the workbook. The user selects a data point of one visualization and actions give you full control of what is supposed to happen on the other visualizations and worksheets.

Today’s post includes a detailed how-to tutorial on the power of Tableau actions:

what are actions and what can you do with them,

what types of actions are possible and

a step-by-step tutorial on how to use actions on a dashboard

The tutorial is based on example data of the 50 most prominent summits on earth and provides a Tableau Public visualization of the final result.