The best data sources are ones that don't require any cleaning. All of the data matches up, there are no stray values, and you can join the fields easily. Reality is rarely so kind. In this movie, the data cleaning tool is introduced, the tool that helps you import your data and manage any issues that come due to inconsistencies in the source file.
- [Narrator] Most of the time,…the data that you bring into Tableau will be pretty clean.…You will have Excel workbooks…that contain single tables with no stray values…that can throw off the data interpretation.…However, there might be times when you find…that your data isn't formatted as cleanly as it should be,…and Tableau has a hard time reading it.…In this movie, I will show you how to use…the Data Interpreter to clean up data…that you're reading in.…I have started Tableau, and I have a blank workbook…with the start screen displayed.…
From here I want to bring in an Excel workbook,…so I will go to the Connect tab, and click Excel.…And then, in the Chapter02 folder…of the Exercise Files folder,…I will double-click YearlyData.…Doing so takes me to the connection screen,…but you can see already that there might be a problem.…In the left-hand panel here,…you can see Tableau has displayed a message saying…that Data Interpreter might be able…to clean my Excel workbook.…
I don't know what the problem is,…so what I will do is double-click the Products sheet,…
Author
Updated
5/10/2017Released
10/13/2016- Managing data sources and visualizations
- Managing Tableau worksheets and workbooks
- Creating custom calculations and fields
- Analyzing data using statistical tools
- Sorting and filtering Tableau data
- Defining groups and sets
- Creating and pivoting crosstabs
- Formatting Tableau visualizations
- Creating basic charts
- Annotating and formatting charts
- Mapping geographic data
- Creating dashboard and actions
Skill Level Intermediate
Duration
Views
Q. This course was updated 5/10/2017. What topics were part of the update?
A. Topics related to version 10.1 and 10.2 were part of the course update.
Related Courses
-
Creating Interactive Dashboards in Tableau
with Nate Makdad1h 37m Intermediate -
Tableau 10 for Data Scientists
with Matt Francis2h 24m Intermediate -
Data Visualization: Storytelling
with Bill Shander1h 37m Intermediate
-
Introduction
-
Welcome59s
-
-
1. Introducing Tableau
-
Downloading Tableau2m 36s
-
Installing Tableau drivers2m 15s
-
Getting help in Tableau2m 2s
-
-
2. Managing Data Sources and Visualizations
-
Connecting to a data source1m 56s
-
Joining related data sources3m 27s
-
Cleaning up source data2m 37s
-
-
3. Managing Tableau Worksheets and Workbooks
-
Saving your changes2m 24s
-
Creating a packaged workbook1m 33s
-
4. Creating Custom Calculations and Fields
-
Creating a calculated field3m 21s
-
Adding a table calculation3m 46s
-
5. Analyzing Data Using Statistical Tools
-
Displaying the Summary Card2m 30s
-
Forecasting future values3m 58s
-
6. Sorting and Filtering Tableau Data
-
Creating a selection filter2m 58s
-
Creating a wildcard filter3m 50s
-
Creating a condition filter2m 53s
-
Creating a top filter2m 46s
-
7. Defining Groups and Sets
-
Defining a group1m 55s
-
Defining a set2m 14s
-
Combining sets3m 31s
-
Editing and deleting sets1m 37s
-
-
8. Creating and Pivoting Crosstabs
-
Creating a crosstab3m 20s
-
Unpivoting a crosstab1m 50s
-
-
9. Formatting Tableau Visualizations
-
Resizing a visualization3m 39s
-
10. Creating Basic Charts
-
Creating pie charts3m 45s
-
Creating scatter plots3m 19s
-
Identifying data clusters3m 54s
-
Creating histograms3m 6s
-
Creating a treemap3m 26s
-
11. Annotating and Formatting Charts
-
Adding a text box to a chart2m 25s
-
-
12. Mapping Geographic Data
-
Creating a basic map4m 24s
-
Setting map options3m 46s
-
Defining custom regions3m 57s
-
13. Creating Dashboards and Actions
-
Creating a dashboard3m 54s
-
Defining a filter action2m 40s
-
Defining a highlight action3m 44s
-
Defining a URL action2m 36s
-
-
14. What's New in Tableau 10.1 and 10.2
-
Export data to CSV files1m 20s
-
Scale maps dynamically1m 34s
-
Conclusion
-
Further resources1m 17s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Cleaning up source data