Hard Data Analyst questions
32 questions · 20 points each for a correct first answer.
- 1.Overall rate goes the other waystatistics, ab-testinghard
- 2.Stopping a test earlyab-testing, statisticshard
- 3.NOT IN returns nothingsql, null-handlinghard
- 4.Detecting a small liftab-testing, statisticshard
- 5.Average of averagesmetrics, aggregationhard
- 6.Only looking at active customerscritical-thinking, product-analyticshard
- 7.Daily numbers do not matchdata-quality, sqlhard
- 8.A metric that can be gamedmetrics, business-thinkinghard
- 9.Running total with tied datessql, window-functionshard
- 10.Filter inside the ON clausesql, joinshard
- 11.Not-equal filter loses rowssql, null-handlinghard
- 12.PERCENTILE_CONT vs PERCENTILE_DISCsql, statisticshard
- 13.NTILE with 10 rowssql, window-functionshard
- 14.Latest order changes between runssql, window-functions, data-qualityhard
- 15.Click-through rate with zero impressionssql, metricshard
- 16.Adding up daily active usersmetrics, sqlhard
- 17.How reliable is a fraud flagstatistics, probabilityhard
- 18.Uneven groups in a 50/50 testab-testing, data-qualityhard
- 19.Lift that fades after week oneab-testing, experiment-designhard
- 20.Randomised by user, analysed by sessionab-testing, statisticshard
- 21.Halving the margin of errorstatistics, samplinghard
- 22.Worst stores improved on their ownstatistics, causal-inferencehard
- 23.Correlation near zerostatistics, data-visualizationhard
- 24.Feature users retain bettercausal-inference, metricshard
- 25.Total row is less than the sumpower-bi, dax, metricshard
- 26.FIXED LOD ignores a filtertableau, bi-toolshard
- 27.Grand total of an average pivotexcel, pivot-tables, statisticshard
- 28.Filtering NaN with == in pandaspython, pandas, null-handlinghard
- 29.Combining two store mediansstatistics, descriptive-statisticshard
- 30.Comparing a week to last yeartime-series, metricshard
- 31.East sales on the West rowpower-bi, daxhard
- 32.GROUP BY with NULL citiessql, null-handling, aggregationhard