ExamNova

PL-300 · Associate

Microsoft Certified: Power BI Data Analyst Associate

Prepare trustworthy data, model business measures and deliver accessible, governed Power BI analysis.

Start Free

Your free account includes a full PL-300 practice exam.

ExamNova practice

Your first session

Questions
50
Time limit
100 min
Coverage
4 domains

Practise, review your answers and see where to focus next.

Is PL-300 your next step?

Explore the coverage below to see how this certification fits your study goals.

What you’ll study

Your PL-300 practice covers every domain on the exam.

  1. Prepare the Data
  2. Model the Data
  3. Visualize and Analyze the Data
  4. Manage and Secure Power BI

Consult the official guide for the vendor’s current exam outline.

Put it into practice.

Explore hands-on tasks connected to PL-300. These are real Labs from the catalogue.

Lab

Compose time and daily currency calculations

Edit calculation.groups.json. Keep both declared groups and all items; assign distinct integer precedence 0..1000. Item expression and formatExpression are bounded DAX strings. Time Current preserves the selected dates; YTD uses calendar-year dates through the latest selected date. Currency Native preserves native values; Converted applies each date's positive daily rate only to Revenue and only for one selected currency, otherwise returning the native base. Preserve Region. OrderCount receives Current/YTD but no rate division. Keep numeric output numeric, and let the highest-precedence format choose the reporting currency only for converted monetary values; preserve native dollars and count formats otherwise. Supported numeric functions are SELECTEDMEASURE, supplied SUM/COUNTROWS, CALCULATE with DATESYTD(Calendar[Date]) or supplied nondate fact-column REMOVEFILTERS, DIVIDE with optional integer alternate, MAX(Rates[Rate]), one SUMX over VALUES(Calendar[Date]) or Sales, and LOOKUPVALUE with the complete Rates.Date/Code pair. Use explicit CALCULATE when SELECTEDMEASURE appears inside the date iterator. Guards use IF, HASONEVALUE(Currency[Code]), ISSELECTEDMEASURE([Revenue]) and ISBLANK(numeric expression). Format expressions support literal text, SELECTEDVALUE on Currency or the declared group Item column, one-case SWITCH, and SELECTEDMEASUREFORMATSTRING. Other DAX is rejected. Inspect composition, actual facts and rate keys; repair without Reset.

hard · About 35 min

Lab

Reconcile revision-aware transaction facts

Write one read-only SQLite query over raw_lines and products. Return exactly order_id, line_no, product_key, quantity, unit_price_cents, revenue_cents, in that column order; row order is unrestricted. The business key is (order_id,line_no). Choose its greatest revision first, then greatest source_seq within that revision. Choose the latest record BEFORE any status, value or product rejection; never fall back to an older row. Identical replays at the same key/revision/sequence have identical payloads and contribute one fact row. Keep the chosen row only if status='active'. Normalize product_code with surrounding ASCII spaces removed and ASCII letters uppercased; require a matching products.canonical_code and output that product_key. Product codes and keys are unique in products. After removing surrounding ASCII spaces, quantity_text must be 1–4 ASCII digits and its integer value 1–9999; price_cents_text must be 1–6 ASCII digits, giving 0–999999 cents. NULL, empty, signs, decimals and trailing letters are invalid. Leading zeros are valid within those lengths. Reject a chosen row with invalid numbers or an unmapped/NULL product. Output integer quantity and price; revenue_cents is their exact product. Keep distinct business lines even when all other values match. An empty source returns no rows. Derive results for new identities and repair without Reset. These source cleanup rules are fictional local requirements, not Power Query defaults.

medium · About 30 min

Make PL-300 your next step.

Create your free account. Start practising.

Start Free