ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 30 - TDA-C01 discussion

Report
Export

You have the following dataset in Microsoft Excel.

You are using interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

A.
10
Answers
A.
10
B.
20
Answers
B.
20
C.
17
Answers
C.
17
D.
15
Answers
D.
15
Suggested answer: C

Explanation:

Data interpreter is a feature that helps you clean and structure your data in Excel before importing it into Tableau. It detects and removes any headers, footers, subtotals, or other elements that are not part of the actual data. It also splits any merged cells and fills in any missing values. In this case, data interpreter provides the following results:

It removes the first three rows and the last two rows that contain headers and footers.

It splits the merged cells in column A and fills in the missing values with ''Fiction'' or ''Non-Fiction''.

It does not remove or change any other rows or cells.

Therefore, the number of rows of data that will be ingested into Tableau as values is 17, which is the number of rows left after removing the headers and footers.

Reference: https://help.tableau.com/current/pro/desktop/en-us/importing_cleaning_up_data.htm https://help.tableau.com/current/pro/desktop/en-us/importing_data_interpreter.htm

asked 23/09/2024
Sivakumar Balasundram
41 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first