3 Ways to Normalise Data in Tableau

Want to Get Latest Updates and Tips on Tableau Bites Blogs


Normalising data in Tableau can be a great way to get the most out of your data visualisations. Matt Snively talks us through the three common methods of normalisation that can help you achieve this: setting a zero baseline, calculating a min-max index, and standardising the mean. Setting a zero baseline involves adjusting values so that all negative values are set to zero and all positive values remain unchanged. Calculating a min-max index requires determining the minimum and maximum values for each measure, then dividing each value by the maximum value. Standardising the mean involves subtracting the mean from each value and then dividing by the standard deviation.

Each of these methods has its own benefits and drawbacks, so it is important to understand which one best suits your needs before implementing it. While performing data analysis, you might find yourself needing to transform your data to further unlock some insight. One way to do that is through data normalisation, but don’t worry, normalisation is just another way of saying standardisation.

Share This Post:

001 database

Tableau Training on
Tap Fast Track

data scientist 1

Tableau Advanced Analyst

002 bar chart


003 network

Tableau Training
on Tap

Share :

Leave a Comment

Your email address will not be published. Required fields are marked *