# ShopifyQL Notebooks: Simplifying Querying with Commerce Data Models

DevFeed: [ShopifyQL Notebooks: Simplifying Querying with Commerce Data Models](<https://devfeed.tech/articles/shopifyql-notebooks-simplifying-querying-with-commerce-data-models-1324.md>)

Original publisher: [Read original article](<https://shopify.engineering/building-commerce-data-models-with-shopifyql>)

Author: Cody Mazza-Anthony

Published: 2023-02-14T16:00:04Z

Content type: article

Language: en

Sources: [Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering.md>), [Shopify Engineering - Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering-shopify-engineering.md>)

Topics: [Shopify](<https://devfeed.tech/topics/shopify.md>), [data](<https://devfeed.tech/topics/data.md>), [datasets](<https://devfeed.tech/topics/datasets.md>)

Tags: [business](<https://devfeed.tech/tags/business.md>), [data](<https://devfeed.tech/tags/data.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [shopify](<https://devfeed.tech/tags/shopify.md>)

## AI overview

The article explains how Shopify built commerce data models for ShopifyQL Notebooks, enabling merchants to explore business metrics and investigate changes without SQL expertise. It discusses designing purpose-driven, explorable, and extensible models that support commerce questions across products, orders, and customers while reconciling dataset granularity and maintaining fast query performance for large merchants.

## Source excerpt

We recently released ShopifyQL Notebooks, a powerful self-serve tool which enables merchants to explore their business metrics without any SQL expertise. Here's how we used ShopifyQL and commerce data models to make it possible.