Preparing & Cleaning Data in Tableau Desktop

Tableau Desktop    |    Intermediate
  • 10 Videos | 47m 57s
  • Includes Assessment
  • Earns a Badge
Likes 56 Likes 56
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Blending & Managing Data Files in Tableau Desktop
Likes 88 Likes 88  
BOOK 100 Top Tips: Microsoft Excel in Easy Steps
COURSE Working with Steps in Tableau Prep Builder
Likes 18 Likes 18  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE Blending & Managing Data Files in Tableau Desktop
Likes 88 Likes 88  
COURSE Opening & Connecting Data Sources in Tableau Prep Builder
Likes 50 Likes 50