pbPassingBI
/
looker studio/flashcards/looker-studio-cards-build

Building reports — flashcards

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

  1. Scorecards and tables — what are the key points?

    A scorecard without a comparison gives the reader no context · Bars or heatmaps in table cells make a table scannable · Sort tables by metric, not alphabetically Read the lesson

  2. Choosing and building charts — what are the key points?

    Sort bar charts by metric and use horizontal bars for long labels · A breakdown dimension with many values makes a time series unreadable · Optional metrics keep a chart clean while allowing depth on demand Read the lesson

  3. Calculated fields — what are the key points?

    Data-source calculated fields are reusable; chart-level ones are not · CASE conditions evaluate in order, first match wins · Divide the sums, not the row-level ratios, when computing a rate Read the lesson

  4. Blending data sources — what are the key points?

    Blends join up to five sources on shared dimension keys · Mismatched key formatting produces null metrics with no error · Where possible, do the join upstream rather than in a blend Read the lesson