ShopifyQL Notebooks: Simplifying Querying with Commerce Data Models - Shopify

This post details the development of ShopifyQL Notebooks and the underlying commerce data models. It outlines the process of building these models, focusing on making them purpose-driven, explorable, and extensible. Key aspects include defining granularity, ensuring additive metrics, and the step-by-step data modeling process: starting with business questions, creating mock data, finding data sources, assessing data quality and consistency, and evaluating model freshness and performance. It also introduces the concept of ShopifyQL as a query language for these models.