From the course: Tableau Essential Training

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Clean up source data

Clean up source data - Tableau Tutorial

From the course: Tableau Essential Training

Start my 1-month free trial Buy for my team

Clean up source data

“

- [Instructor] Most of the time, the data that you end up bringing into Tableau will be pretty clean. You'll have Excel workbooks that contain single tables we know are correct values. However, there might be times when you find that your data isn't laid out exactly 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 your data. I have started Tableau, but what I'd like to do is to show you what the Excel file that I've created looks like so you can see the type of error that we will get in Tableau. So I will switch to my Excel file and I see at the top that I have a file that says Created 2/9/2023 and it is just above the row of column headings for my table. So let's keep that in mind and I will close this file and go back into Tableau. With that done, I can connect to the file that I just identified, so I'll go over to the Connect pane…

Contents