Practice / Data & AI

Star schema for a ride-share company

Medium · Whiteboard

Design a warehouse schema for a ride-share company so analysts can answer: trips and revenue by city, by day, by driver, and by rider. Draw the tables.

Create a free account to answer it and get scored on what a strong answer covers.