Preparing & Cleaning Data in Tableau Desktop
Discover how to prepare control and clean up data before you start working with it to ensure that you get the most out of your analyses in Tableau Desktop in this 10-video course. Learners begin by observing how to manage data types for columns in Data Source page then take a look at unioning data and using unions to combine data from different locations and appending values in a single table. Tableau works best with clean data so next you will explore how to work with data interpreter to identify data anomalies and clean up data. Learn how to split data fields using the split and custom split in the Tableau Data Source Page; use the pivot tool to prepare data for extraction into the Tableau Data Engine and filter data at the data source level. Delve into managing data sources in a Tableau workbook; replace data sources from the Data Source Page and worksheet view in Tableau Desktop and refresh live data sources. The course concludes by helping learners discover how to append data to extracts.