ShopifyQL Notebooks: Simplifying Querying with Commerce Data Models - Shopify

What this post added

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.