Previous Page

Tableau Desktop: Preparing & Cleaning Data

Tableau Desktop: Preparing & Cleaning Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Preparing, controlling, and cleaning up data before you start working with it is key to getting the most out of your analyses in Tableau Desktop. You can define the types of data you're working with, split the contents of a data field, and use the pivot tool to convert columnar data to row data. Once you have finished preparing your data, you can control what is brought into the Tableau Data Engine, and stay on top of updates and refreshes.



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