Tableau is capable of creating highly advanced visualizations and hence ranks very highly in the list of BI tools. Although Tableau is one of the leading BI tools in the market today, sometimes it seems to be missing some very fundamental and necessary features.
One such feature is of creating different line types or Line charts as below:
“Design is not just what it looks like and feels like. Design is how it works.”— Steve Jobs
In the reporting world, you would often come across situations wherein the stakeholders would request for features or functionality not directly available in Tableau.
One such use case I came across was having a table expand and collapse on a click, more like having a hidden sheet show up when clicked on its parent table. (for folks who are familiar with Tableau, it’s just like clicking on a ‘+’ and ‘-‘ action of a hierarchy, but without using it). …
There are numerous ways of creating a button/toggle in your dashboards. Providing the user with an option to make selections on the reports or dashboards, helps improve the user experience.
The most common way to provide this functionality to the user in Tableau is to provide a filter option, wherein the user can make a customized selection and view the data accordingly.
However, at times one would accumulate multiple filters on the dashboard, making the dashboard look — one; cluttered and second; inefficient, diminishing the user experience.
Analytics is usually applied to structured, unstructured, numeric, or visual data to uncover decision driving insights.
Graph analytics is a relatively new area for analytics which refers to analysis applied on graph-based data.
Graph analytics (also called network analysis) as its name suggests is an analysis based amongst entities or graph nodes which could be products or customers or operations or even devices. Organizations and companies around the world are beginning to implement graph analytics to help uncover impactful insights in the field of marketing, fraud detection, supply chain, and search engine optimization and the like.
Butterfly charts, also called Tornado or Divergent Chart, are essentially bar charts comparing two differing metrics at a time. In these visuals, data categories are listed out vertically with the bars of differing metrics extending horizontally, on both ends of the listed categories, resembling the butterfly wings. An example of this can be seen below.
The butterfly charts come in handy while comparing two data sets or metrics which are contrasting in nature such as male-female, positive-negative, and the like.
These charts are also a great alternative to the regular bar/stacked bar charts regularly used in reporting.
One of the techniques, perhaps, widely used to create rich, interactive yet clutter-free dashboards is sheet swapping.
Sheet swapping essentially involves, dynamically swapping of one view to display another.
This brief article will walk you through, how to enable your dashboard users to swap visuals in real-time using containers in Tableau.
Step 1: Make your visuals/charts/views
I’ve created a simple scatter plot and a Bar plot as below.
“ Stories are just data with Soul “ — Dr. Brene Brown
Sankey chart named after the Irish Captain Matthew Henry Phineas Riall Sankey, who used this type of visual in 1898 shown below representing the energy efficiency of a steam engine.
Sankey diagrams are essentially, flow diagrams, which highlight flows in a system. Flows could be energy, costs, materials etc, depending on your use case. They are instrumental in drawing the viewers’ attention to chief contributors of the flow.
Below is an example of what a Sankey diagram looks like
How to remove the ‘Abc’ column? - might be the most commonly asked Tableau question.
If you are a regular Tableau user, you would have invariably, come across a situation wherein you have had a column with ‘Abc’ listed out in your visual like below, and no matter what you do, this column just wouldn’t get erased.
Tableau is currently the most popular data visualization software in the market today. Its popularity is rightly validated by the value it provides across industries and organizations.
Tableau shines as a Business Intelligence software providing high-quality visualization analytics and has been noted as BI platform leader in Gartner’s magic quadrant two years in a row (2020 and 2019) as seen below.
“I kind of have to be the master of cleaning, extracting and trusting my data before I do anything with it” — Scott Nicholson
Data professionals spend the majority of their time, cleaning data, before working on it any further, hence it becomes imperative to choose powerful data cleaning tools.
Tableau Prep Builder is a tool in the Tableau suite of products, aimed at providing functionalities for data preparation. Tableau Prep is designed to help you shape and clean your data for your analysis in Tableau.
Tableau prep allows the user to curate the data, before analyzing or visualizing it…