Business Intelligence with Power BI

L12 · Analytics and AI

Practice — Mild · Solution

What the runs show

FeatureExpected outcome
Q&A regional questionA bar of [Total Revenue] by Region filtered to 2025 — readout confirms the measure, not an implicit sum
"average revenue"Typically resolves to AVERAGE over a revenue column (the ~$404.83 reading) — usually NOT the AOV a VP means; the readout is where you catch it
Influencers on Return RateWeak associations only — "No strong driver of return rate; associations are minor, consistent with the measured 2.44–3.82% band."
Decomposition Midwest → FurnitureLeaf figures reconcile with the drillthrough page (same model, same measures — agreement is the expected boring outcome)
ForecastThe band dips for February — because the Dates table + three years of history exposed the seasonality for the algorithm to extend

Reflection answers

  • The parser most plausibly picks the per-line average — nearly half the number the VP means. Unconfigured Q&A in front of executives is the L05 ambiguity with a friendly interface: the synonym work and the field-readout habit are what make the feature shippable.
  • The model made it possible: a marked date spine and clean history are what the algorithm extends. The "AI" in the forecast is pattern arithmetic standing on YOUR Module 2 — which is the lesson's quiet point about all of these features.