pbPassingBI
/
tableau prep/flashcards/tableau-prep-cards-clean

Cleaning & transforming — flashcards

One card per lesson — 3 in this module. Recall the key points, then check. 3 cards. Click a card to flip, or use the arrow keys and space bar.

  1. Clean steps — what are the key points?

    The Changes panel records every action in order and is editable · Right-click values in the profile pane for the fastest cleaning · Trim and normalise case on any field you will join on Read the lesson

  2. Grouping and cleaning values — what are the key points?

    Group Values offers pronunciation, common characters and spelling methods · Automatic grouping over-merges — review the proposed groups · Recurring inconsistency is better fixed at source than re-grouped monthly Read the lesson

  3. Splitting fields and calculations — what are the key points?

    Split from the right when a middle element is optional · Prep uses Tableau calculation syntax, including FIXED LOD expressions · Shaping calculations belong in Prep; view-dependent ones belong in Desktop Read the lesson