Tableau Desktop: Preparing & Cleaning Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.7

Lesson Objectives

Tableau Desktop: Preparing & Cleaning Data

  • demonstrate managing data types for columns in Data Source page
  • use unions to combine data from different locations and append values in a single table
  • work with Data Interpreter to identify data anomalies and clean up data
  • 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
  • filter data from the connected data source via the Tableau Data Source Page
  • adjust data sources and connections in a Tableau workbook
  • replace data sources from the Data Source Page and worksheet view in Tableau Desktop
  • refresh live data sources and data extracts that are connected in Tableau Desktop
  • append data from a data source or file to an existing data extract in Tableau Desktop
  • Course Number:
    ds_tbldsk_02_enus

    Expertise Level
    Intermediate