Preparing & Cleaning Data in Tableau Desktop

Tableau Desktop    |    Intermediate
  • 10 videos | 42m 57s
  • Includes Assessment
  • Earns a Badge
Likes 122 Likes 122
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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Manipulating PivotTable data in Excel 365
Course Working with report tables and charts in Project 2022
Course Database Fundamentals: Getting Started with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Enhancing Data Visualizations in Tableau Desktop
Likes 96 Likes 96  
Course Opening & Connecting Data Sources in Tableau Prep Builder
Likes 50 Likes 50  
Course Introducing SELECT Statement Queries
Likes 29 Likes 29