Labs · Power BI

Lab: Glossary Match-Up – 25 Power BI Terms with Your Own One-Line Examples

By Ravindra Bagale · Last updated: 8 October 2026

Suppose we are…

Suppose we have joined Wipro as a trainee and the first weekly test is a Power BI vocabulary round: the trainer reads a term like "gateway" or "filter context" and we must explain it in one line with an example. We will practise with a spreadsheet of 25 terms and 25 meanings in shuffled order (letters A to Y).

Goal of this lab

• Match all 25 terms to their meanings without notes (10 minutes).
• Score yourself with one formula.
• Write a one-line example from your own labs for each term.

What you need (all free)

• Google Sheets, Excel or LibreOffice Calc.
• Download powerbi_glossary_25.csv (25 terms, shuffled meanings)
• 30 minutes and no notes for the first 10.

The data: before and after

Before. Terms on the left, meanings shuffled on the right with letters A–Y. The "Your letter" and "Your one-line example" columns are empty.

After. Each term has the right letter and an example from your own work.

The formula

To score yourself, type the answer key into column G (rows 2–26) after you finish, then in any empty cell:

=SUMPRODUCT(--(UPPER(TRIM(C2:C26))=G2:G26))

• C2:C26 is your letters; G2:G26 is the key.
• TRIM and UPPER forgive a stray space or a small letter.
• --( … ) turns TRUE/FALSE into 1/0, and SUMPRODUCT adds them up: your score out of 25.

To see which ones you got wrong, put this in H2 and fill down: =IF(UPPER(TRIM(C2))=G2,"OK","CHECK").

Steps

1. Open the CSV in Google Sheets (File → Import → Upload, "Replace spreadsheet") or in Excel/Calc.

   👁 What you should see: 26 rows (1 header + 25 terms) and 6 columns: No, Term, Your letter, Your one-line example, Letter, Meaning (shuffled).

2. Start a 10-minute timer. For each term in column B, read the meanings in column F and type the matching letter in column C. Each letter is used exactly once.

3. When the timer ends, stop, even if some are empty.

4. Open the answer key below and type it into G2:G26.

   Answer key (open only after the timer)

   1-D, 2-J, 3-G, 4-E, 5-K, 6-X, 7-H, 8-V, 9-U, 10-B, 11-P, 12-C, 13-L, 14-F, 15-I, 16-T, 17-R, 18-S, 19-Y, 20-O, 21-W, 22-M, 23-N, 24-Q, 25-A

5. Type the SUMPRODUCT formula in an empty cell (for example I1) and the check formula in H2, filled down to H26.

   👁 What you should see: a number out of 25 in I1, and "OK" or "CHECK" next to each term. 20 or more is good for now.

6. For every "CHECK" row, read the right meaning and say it aloud once.

7. Now fill column D for all 25 terms with your own one-line example. Use what you built: for example, Star schema → "pbi_sales in the middle with DateTable, pbi_products and pbi_cities (Lab 11)"; RLS → "Pune manager sees only Pune, 346,000 (Lab 26)".
8. Save the sheet. Before an interview, read only columns B and D.

Common mistakes

Self-check checklist

Try-at-home challenge

Add 5 more terms of your own to rows 27–31 (for example: Tooltip page, Sync slicers, Mark as date table, Workspace, Scheduled refresh). Write the meaning and your example. Then extend the score formula so it counts all 30 terms.

Samjla ka? Match first, score with one formula, then tie every term to your own work. Aata pudhe jaauya: plan a real project from a client brief.