How Shopify Built An In-Context Analytics Experience - Shopify

What this post added

This post details the technical process of bringing analytics into the Shopify admin's Orders page. It covers the steps of identifying key metrics and their dimensions by collaborating with product managers and analyzing merchant workflows, understanding the 'shape' of the data across various merchant segments (order volume, journey stage, fulfillment processes, geography, industry) to validate and refine metrics, prototyping visualizations with real data (e.g., using histograms for fulfillment time distributions), and creating a data specification sheet to ensure consistency in queries and data sources across clients. It also outlines the dataset design for new metrics, including identifying business processes, selecting data grain (event-level), and defining dimensions, and discusses the initial implementation of a batch pipeline for data modeling before a streaming pipeline.