Connecting & Preparing Data Flashcards

In Tableau Prep, what is the purpose of a Clean step?

Answer: Apply filters, rename fields, and fix values in the data flow

A Clean step lets you filter, rename, group, split, and adjust field values within a flow.

What does the Aggregate step in Tableau Prep do?

Answer: Group rows and roll up measures to a chosen level of detail

The Aggregate step groups data and summarizes measures to change granularity.

Which Tableau Prep feature suggests grouping similar text values that may be misspellings?

Answer: Group and Replace (fuzzy match)

Group and Replace can use fuzzy matching to combine similar or misspelled values.

What output options does a Tableau Prep flow's Output step support?

Answer: Extract files, published data sources, and database tables

An Output step can write to .hyper extracts, published data sources, or database tables.

When connecting to a CSV in Tableau, which setting controls how text is divided into fields?

Answer: Field separator (delimiter)

The field separator defines the delimiter used to break each line into columns.

Why might you choose an extract over a live connection for a large slow database?

Answer: Extracts improve performance and enable offline use

Extracts cache data in the fast Hyper engine, improving speed and allowing offline work.

What does an incremental extract refresh do?

Answer: Add only new rows since the last refresh

An incremental refresh appends only newly added rows based on a chosen field.