Practice — Mild · Specialty Rehearsal
Skills focus. The map-with-caption, the scatter, the heat grid, and small
multiples — assembled once with the answer key open.
Ungraded. Start from your A06/A07 model.
Tasks
- Map + caption. Filled map, State × [Total Revenue]. Write the caption first: what does this map exclude, and how much? Check: $29.89M — 44.7% — Online. Then a sorted state bar beside it. Check: CA $2.91M · NY $2.84M · TX $2.82M.
- Scatter. Create
Avg Selling Price = DIVIDE([Total Revenue], [Total Units]); scatter with X = [Total Units], Y = the new measure, ProductName in details, Category as legend. Find and label the two corners. Check: Aurora Signature Bed Frame upper-left ($941 avg, 922 units); Cedarline Petite Floor Lamp lower-right (1,399 units). - Heat grid. Matrix of [Return Rate], Category × Region, sequential scale, values on. Check: floor 2.44% (Decor–Northeast), ceiling 3.82% (Furniture–Midwest). Write the one-sentence finding this grid supports.
- Small multiples. Monthly revenue line, split by Category, shared axes. Check: Outdoor's summer wave and Decor's December spike each visible on its own baseline.
Reflection
- You wrote the map's caption before building the map. What did that order buy you?
- The heat grid's finding was "no problem region." Why is that worth shipping at all?