Assignment A12 — The Verified Assistant
Skills assessed. Q&A configuration · honest influencer reporting · the
decomposition tree · an equipped forecast · generated-DAX review.
Submit: A12_LastFirst.pbix plus a one-page verification memo. Worth 20
points. Where a tenant lacks a feature, the memo's written analysis substitutes — every
point is earnable in every lane.
Requirements
- Page "Ask": a Q&A visual, with synonyms configured so all three of these resolve correctly: sales → [Total Revenue] · basket size → [Avg Units per Order] · hit rate → [Attainment %]. In the memo: the three test questions you typed and the field-readout each produced.
- Influencers, honestly: run key influencers on [Return Rate]. In the memo, write the two-sentence finding — which must reconcile with the verified 2.44–3.82% band (an honest null is the expected result; drama is a red flag in your own work).
- Page "Decompose": a decomposition tree on [Total Revenue] with Region, Category, and Subcategory available as splits.
- The equipped forecast: monthly revenue line with a 6-month forecast — band visible, and the title or caption stating the assumption ("assumes historical trend and seasonality continue").
- Generated-DAX review (memo): the assignment hands you three
"assistant-generated" measures below. For each: accept or reject, with the one-sentence
reason. Verified figures are your evidence.
- (a)
AOV 2 = DIVIDE ( [Total Revenue], DISTINCTCOUNT ( Sales[OrderID] ) ) - (b)
Cost Estimate = SUMX ( Sales, Sales[Quantity] * Sales[UnitPrice] * 0.42 ) - (c)
Growth = DIVIDE ( [Total Revenue], [Revenue LY] )
- (a)
Checklist (what the grader checks)
| # | Check | Points |
|---|---|---|
| 1 | Q&A visual present; three synonyms defined on the correct measures | 4 |
| 2 | Memo: influencer finding reconciles with the band (honest null) | 3 |
| 3 | Decomposition tree with the three splits available | 3 |
| 4 | Forecast with visible band AND stated assumption | 4 |
| 5 | DAX review: (a) accept (it IS the AOV definition, $781.10) · (b) reject (invented 0.42 ratio vs RELATED unit costs; verified cost $28,099,192.18) · (c) reject or fix (returns the index ~1.12, not growth — missing the subtraction) | 5 |
| 6 | File named A12_LastFirst.pbix | 1 |
Before you submit
- Type your three Q&A questions one more time and read each field-readout — the memo reports what happened, not what should have.
- Reread your influencer finding: does it contain the word "drives"? Fix it.
- Save, close, reopen, verify — for the last weekly time. The capstone inherits the habit.