Cleaning Data in Tableau Prep
When a more comprehensive cleaning of a data source is required to ensure the analysis is accurate, the best tool to use is Tableau Prep. An example of this could be three distinct Sales data sources from offices in three different regions, each of them with their own methodology. Although the general metrics might be the same, the specific names of fields, the calculation logic applied, and the level of data aggregation may differ between each office. In this case, all three of the data sources can be cleaned in separate streams in Tableau Prep until they all have a common format, before combining them all together.
Tableau Prep offers a wide variety of data cleaning functionalities. Tableau Prep works by inputting data, which then goes through a series of logical steps. One of the logical steps available is called the clean step, and it provides all of the functionalities available for cleaning data in Tableau Prep.
To filter out outliers or unnecessary...