2. (LO 2.4) This Chapter 2 Problem data set contains a list of outstanding invoices for a fictional company, but the data aren’t ready for analysis yet. Load this data file into Tableau and validate and clean the data by taking the following steps:

a. Click the “Use the Data Interpreter” checkbox. What changes occurred to the data?

Why are these changes helpful?

b. Click into Sheet 1 and create two new calculated fields:

i. To trim and clean the Customer field, create a new calculated field named “New Customer” with the following calculation: TRIM(REPLACE([Customer],SPACE(1), SPACE(0)))

ii. To convert the Days Past Due field to a numerical field, take the following two actions: