Data analyst interview: make the metric trustworthy
Work through common analyst screens: repeat buyers, missing relationships, rankings and defensible denominators.
Practise each question under time pressure, then explain your assumptions, data grain and edge cases aloud before comparing solutions.
Start interview practice→ 02
→ 03
Your exercises
01Return customer name and paid_order_count for customers with at least two paid orders, ordered by paid_order_count descending and name alphabetically.
Return the name of every customer who has never placed a paid order, sorted alphabetically. Customers with only refunded or cancelled orders should appear.
Return channel and the count of paid orders as paid_orders for every channel with paid orders, sorted by paid_orders descending and channel alphabetically.
Return country and customer_count for the three countries with the most customers, sorted by customer_count descending and country alphabetically.
Return customer name and paid_spend (quantity times charged unit_price, rounded to two decimals) for the five highest-spending customers on paid orders. Sort by paid_spend descending, then name alphabetically.