Back to problems

Model Data for Analytics, Reporting, and Applications

System Design · ByteDance · Medium

Propose a design for a shared business data model that lets ad-hoc analytics, scheduled reporting, and data-driven product features operate from one consistent set of definitions. Your design must explain how to ingest upstream data, organize fact and dimension tables, retain history, enforce data contracts, and provide appropriate serving layers. Constraints and assumptions: Upstream systems refresh on independent schedules and may deliver delayed or corrected records.…

Checking your access…