Preparing & Cleaning Data in Tableau Desktop
Tableau Desktop
| Intermediate
- 10 videos | 42m 57s
- Includes Assessment
- Earns a Badge
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 pageuse unions to combine data from different locations and append values in a single tablework with Data Interpreter to identify data anomalies and clean up datasplit data fields using the split and custom split in the Tableau Data Source Pageuse 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 Pageadjust data sources and connections in a Tableau workbookreplace data sources from the Data Source Page and worksheet view in Tableau Desktoprefresh live data sources and data extracts that are connected in Tableau Desktopappend data from a data source or file to an existing data extract in Tableau Desktop
IN THIS COURSE
-
1.Controlling data types4m 22sUP NEXT
-
2.Unioning data4m 31s
-
3.Cleaning up data3m 51s
-
4.Splitting fields4m 25s
-
5.Pivoting data3m
-
6.Filtering data at the data source level6m 24s
-
7.Managing data sources3m 54s
-
8.Replacing data sources4m 31s
-
9.Refreshing data sources5m 13s
-
10.Appending data to extracts2m 46s
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.