Skip to main content
All Questions

Create geographic and demographic dashboards for weekly, monthly, and yearly analytics using order data (100M daily records for 5 years) and customer data (1B customers).

Unlock detailed company stats for this questionUpgrade
FCT_ORDER_ITEM(product_id,customer_id,view_day,item_price,quantity,page_view_id, is_ordered) 100M/day for 5 years. DIM_CUSTOMER(customer_id, address, age) has 1B rows.

Community answers

No answers contributed by the community yet.

Related courses

Course

Data Engineering Interview Prep

Land your dream data engineering role at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice data modeling, pipeline design, SQL, coding, behavioral interviews, and more.

Course

Behavioral Interviews: A Practical Guide for Engineers

Get offers at the level you deserve. Prep for senior+ behavioral interviews at FAANG and Tier-1 companies. Made with staff and principal engineers from Meta, Netflix, Google, and more. Avoid downleveling, elevate past projects, and stop sounding like a robot.