Analytics-DA-201 - Connect to and Transform Data (24% of the exam) - Section 1.2
Assess data quality, perform cleaning operations, organise fields into folders, combine data with relationships, joins, and unions, and prepare data with Data Interpreter, pivot, and split.
Practice question for this objective
lock_openFree sampleConnect to and Transform Datamedium
A data source has grown to forty measures covering finance, logistics, and marketing, and analysts struggle to locate the right field in the long alphabetical list. A lead wants to group the related measures together in the Data pane without changing any field names, data types, or values. Which action achieves this organisation?
ACreate a relationship that links the finance, logistics, and marketing fields
BPivot the measures so each category becomes a row grouping in the pane
CPlace the related measures into named folders in the Data panecheck_circle Correct
DHide the unused measures so only one category is visible at a time
Use folders to organise related fields in the Data pane for easier navigation without altering field names, types, or values. Folders are a Data pane organisation feature that groups chosen fields under custom labels affecting only display order and discoverability, leaving the underlying field definitions and data untouched.
Why A is wrong: A relationship combines tables for analysis and does nothing to rearrange how fields are displayed within a single Data pane, so it does not group the measures visually.
Why B is wrong: Pivot reshapes data from columns to rows and would alter the structure and values of the source, which the lead has ruled out, and it does not group items in the Data pane.
Why C is correct: Folders let the analyst gather related fields under named groups in the Data pane purely for navigation, organising the forty measures without touching field names, data types, or values.
Why D is wrong: Hiding removes fields from view rather than grouping them, so analysts could not see all categories together and the related measures would still not be organised.
Answers that look right on this material and are not. Each one is a distractor from a different question in the Analytics-DA-201 bank for this domain.
Create a hierarchy for each theme by dragging the related fields together so they nest under a single drillable parent in the Data pane.
errorWhy it is wrong: A hierarchy nests fields for drill-down on a view and implies a parent-to-child relationship, which is not the same as simply grouping unrelated peers under labelled headings for findability.
Columns-to-rows turns several rows into one wide column, while rows-to-columns merges several columns into one tall field.
errorWhy it is wrong: This is tempting because it names both directions, but it inverts each one: it describes the outcomes the opposite way round to what actually happens.
Union the four quarter columns together so the revenue figures stack into one column under a shared field name.
errorWhy it is wrong: Union stacks whole tables of matching structure, not columns within a row, so it cannot reshape the quarter columns.