pbPassingBI
/

Visualisation & sharing — flashcards

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

  1. Designing report pages — what are the key points?

    Set Edit interactions explicitly once a page has several visuals · Bookmarks capture state; drillthrough carries context to a detail page · Drive conditional formatting from a measure to keep rules in one place Read the lesson

  2. Workspaces, apps and refresh — what are the key points?

    Build in a workspace, distribute via an app · Gateway needed for non-public sources; personal mode is refresh-only · Pro allows 8 refreshes/day, Premium capacity 48 Read the lesson

  3. Row-level security — what are the key points?

    Use USERPRINCIPALNAME(), not USERNAME(), for dynamic RLS · An entitlement table scales; one role covers every user · Workspace Admins/Members bypass RLS — test as a Viewer Read the lesson

  4. Preparing for PL-300 — what are the key points?

    PL-300 replaced DA-100; four skill areas with periodically adjusted weightings · Modelling and Power Query carry heavy weight; governance is easy to under-prepare · Drill: Date table, YTD/PY measures, dynamic RLS, incremental refresh Read the lesson

  5. Drill-down and drill-through — what are the key points?

    Drill-down moves within a visual; drill-through moves to another page · Keep all filters controls whether page filters travel with the drill · Summary page plus detail pages beats one dense page Read the lesson

  6. Bookmarks and navigation — what are the key points?

    Bookmarks save filters, visibility and drill state · Selection pane plus bookmarks is how chart switchers are built · Bookmarks capture state at save time — update them after edits Read the lesson