Data interpreter for cleaning in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a data analyst at a retail company.

📋 Request: Your manager wants you to clean and prepare the monthly sales data for accurate reporting.

📊 Data: You have a sales data file exported from an old system. It contains extra header rows, merged cells, and some inconsistent formatting that Tableau's Data Interpreter can help clean.

🎯 Deliverable: A clean Tableau data source ready for creating sales reports without manual data fixing.

Sample Data

Row	Data
1	Monthly Sales Report
2	Generated on 2024-06-01
3
4	Region,Product,Month,Sales
5	East,Widget A,January,1000
6	East,Widget B,January,1500
7	West,Widget A,January,1200
8	West,Widget B,January,1300
9	East,Widget A,February,1100
10	East,Widget B,February,1600
11	West,Widget A,February,1250
12	West,Widget B,February,1350

1

Step 1: Open Tableau and connect to the sales data file.

In Tableau, click 'Connect to Data' and select the sales data file.

Expected Result

Tableau shows the raw data preview including extra header rows and blank rows.

2

Step 2: Enable Tableau's Data Interpreter to clean the data.

In the data source page, check the box 'Use Data Interpreter'.

Expected Result

Tableau removes extra header rows and blank rows, showing a clean table with columns: Region, Product, Month, Sales.

3

Step 3: Verify that the first row is now the correct header and data types are assigned properly.

Check that 'Region' and 'Product' are strings, 'Month' is string, and 'Sales' is numeric.

Expected Result

Data preview shows correct headers and data types, ready for analysis.

4

Step 4: Rename the data source to 'Cleaned Monthly Sales'.

Right-click the data source and select 'Rename', then enter 'Cleaned Monthly Sales'.

Expected Result

Data source is renamed for easy identification in Tableau.

5

Step 5: Create a simple worksheet to confirm data is clean by showing total sales by region.

Drag 'Region' to Rows, drag 'Sales' to Columns, and set aggregation to SUM.

Expected Result

Bar chart shows total sales for East and West regions without errors.

Final Result

Cleaned Monthly Sales Data Source

+---------+----------+---------+-------+
| Region  | Product  | Month   | Sales |
+---------+----------+---------+-------+
| East    | Widget A | January | 1000  |
| East    | Widget B | January | 1500  |
| West    | Widget A | January | 1200  |
| West    | Widget B | January | 1300  |
| East    | Widget A | February| 1100  |
| East    | Widget B | February| 1600  |
| West    | Widget A | February| 1250  |
| West    | Widget B | February| 1350  |
+---------+----------+---------+-------+

Sales by Region Bar Chart

East  |█████████████████████ 5200
West  |████████████████ 5100

✓Data Interpreter successfully removed extra header and blank rows.

✓Cleaned data is structured correctly for analysis.

✓Total sales for East region are higher than West region in the sample months.

Bonus Challenge

Use Tableau Prep to automate cleaning for future monthly sales files with similar formatting issues.

Show Hint

Create a flow in Tableau Prep that uses the 'Clean' step to remove extra headers and set data types, then output a clean file for Tableau.