Dashboard » Module 03 » Section 7
review

Module 03 Self-Test

  1. What does LAG(revenue) OVER (ORDER BY month) return for the first row?
  2. transform() vs agg() — which changes the number of rows?
  3. Poisson distribution: mean = 7. What's the variance?
  4. What does GAME stand for?
  5. What's a guardrail metric and why does it matter?
  6. Write CASE WHEN to compute a conversion rate from events with types 'view' and 'purchase'.

Practice Questions

Q: What does LAG(revenue) OVER (ORDER BY month) return for the first row?
Q: transform() vs agg() — which changes the number of rows?
Q: Poisson distribution: mean = 7. What's the variance?
Q: What does GAME stand for?
Q: What's a guardrail metric and why does it matter?
Q: Write CASE WHEN to compute a conversion rate from events with types 'view' and 'purchase'.