From the course: Tableau 10 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Cleaning up source data

Cleaning up source data - Tableau Tutorial

From the course: Tableau 10 Essential Training

Start my 1-month free trial

Cleaning up source data

- [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…

Contents