Assignment A08 — The Specialty Page
Skills assessed. Maps with honest captions · scatterplot construction ·
conditional formatting · small multiples · tooltip design.
Submit: A08_LastFirst.pbix. Worth 20 points. Start from your A06/A07
model.
Scenario
The regional VPs want geography; merchandising wants the catalog's structure; operations wants the returns picture. One page, named Specialty, serving all three — with every specialty visual wearing its honesty equipment.
Requirements
- Map: filled map of [Total Revenue] by State. Its title or subtitle must state the Online exclusion and its share ("excludes Online — 44.7% of revenue" or equivalent). Beside it, a sorted bar of the top states carries the ranking. Check: CA leads at $2.91M.
- Scatter: 240 products — X: [Total Units], Y: a new measure
Avg Selling Price = DIVIDE([Total Revenue],[Total Units]), color by Category. Label (only) the two landmarks: Aurora Signature Bed Frame and Cedarline Petite Floor Lamp. - Heat matrix: [Return Rate], Category × Region, sequential color scale, values visible. Check: extremes 2.44% (Decor–Northeast) and 3.82% (Furniture–Midwest).
- Small multiples: monthly [Total Revenue] line, split by Category, shared axes.
- Tooltip: the state bar's tooltip carries Gross Margin %, Total Units, and % of Total Revenue.
Checklist (what the grader checks)
| # | Check | Points |
|---|---|---|
| 1 | Filled map, State × [Total Revenue]; caption text mentions Online and a ~44.7% figure | 4 |
| 2 | Sorted state bar beside it; CA on top at $2.91M | 2 |
| 3 | Scatter: correct axes (Avg Selling Price measure exists, DIVIDE), category legend, exactly two data labels | 5 |
| 4 | Heat matrix: sequential scale, values on, verified extremes | 4 |
| 5 | Small multiples by Category, shared axes | 2 |
| 6 | Tooltip fields on the state bar: the three named measures | 2 |
| 7 | File named A08_LastFirst.pbix | 1 |
Before you submit
- Cover the map's caption and ask: would a reader discover the missing $29.89M? That is why the caption is graded.
- Hover a state bar and read the tooltip as the VP would — does it answer the next question?
- Save, close, reopen, verify.