Shopify

Shopify Data Analyst Interview Questions

Shopify is one of the Big Tech companies, and its data analyst interviews lean on window functions, reshaping and running totals. These questions cover the same ground, in SQL and pandas.

Start solving and check your level of preparation.

The questions

Plan changesSQLWindow functionsmedium
Revenue by plan and monthPandasReshapingmedium
Revenue to date per merchantSQLRunning totalsmedium
Unbroken runs of monthsSQLWindow functionshard

Questions last reviewed 19 October 2026.

Topics they cover

Window functions2
Reshaping1
Running totals1

Shopify sits in

Big Tech Data Analyst
Retail and e-commerce Data Analyst

Data Analyst questions at other companies

Amazon20
Walmart12
Stripe11
Target10
Best Buy8
Uber8
DoorDash5
Meta5
Netflix5
Robinhood5
Salesforce5
Swiggy5

All data analyst questions