Modeling Device Capabilities for Analytics

This post details the evolution of Netflix's device capability data model for analytics. It describes the use of a cumulative table to store the latest state of each device's capabilities (e.g., screen resolution, video profiles, surround sound, RAM size) for analytics and reporting. It also introduces a histogram table that tracks active device counts over 28 days, categorized by device model and software version, to analyze the distribution of devices supporting specific capabilities, such as HD vs. UHD profiles. This data informs decisions on feature enablement for devices.