Skip to content
RED SAGSkills

Medium Data Analyst questions

34 questions · 10 points each for a correct first answer.

easymediumhard
  1. 1.Revenue doubled after a joinmedium
  2. 2.Latest order per customermedium
  3. 3.Running total of salesmedium
  4. 4.What a p-value meansmedium
  5. 5.Reading a cohort retention tablemedium
  6. 6.Calculating conversion ratemedium
  7. 7.Filling missing income valuesmedium
  8. 8.Designing an executive dashboardmedium
  9. 9.LEFT JOIN that lost customersmedium
  10. 10.RANK vs DENSE_RANK after a tiemedium
  11. 11.Month-over-month change with LAGmedium
  12. 12.Share of paid orders in one querymedium
  13. 13.Customers who never orderedmedium
  14. 14.Grouping orders by monthmedium
  15. 15.Counting repeat customers with a CTEmedium
  16. 16.Looking up a value to the leftmedium
  17. 17.Share of sales in a pivot tablemedium
  18. 18.Pivot ignores new data rowsmedium
  19. 19.Same cleaning every Mondaymedium
  20. 20.Measure or calculated columnmedium
  21. 21.Outlier cutoff with the IQR rulemedium
  22. 22.Average price across two storesmedium
  23. 23.Reading a 95% confidence intervalmedium
  24. 24.False positive in an A/B testmedium
  25. 25.Relative lift of a variantmedium
  26. 26.Rows after a pandas left mergemedium
  27. 27.Month 2 retention for a cohortmedium
  28. 28.ARPU vs ARPPUmedium
  29. 29.Bar chart that exaggeratesmedium
  30. 30.Why use a 7-day moving averagemedium
  31. 31.Report total does not match financemedium
  32. 32.Z-score of a branchmedium
  33. 33.Shaping a Power BI modelmedium
  34. 34.SUM over zero matching rowsmedium