Shopify Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Calculate Week-over-Week Revenue Change Using SQL
transactions +----+---------+---------+------------+ | id | user_id | revenue | order_date | +----+---------+---------+------------+ | 1 | 101 | ...
Measure Pirate-Theme Usage and Revenue Growth Over Time
theme_usage +-----------+------------+-------------+ | user_id | theme_name | created_at | +-----------+------------+-------------+ | 101 | p...
Justify and harden your analytics and BI stack
List your current analytics tech suite end-to-end (ingestion, storage/warehouse, transformation, orchestration, catalog/lineage, experimentation platf...
Determine Growth of Pirated Theme Installations Over Years
merchants +-------------+------------+ | merchant_id | join_date | +-------------+------------+ | 1 | 2020-01-02 | | 2 | 2020-03-...
Analyze Pirate Theme Usage Growth Over Time
themes +----+--------------+-----------+ | id | name | is_pirate | +----+--------------+-----------+ | 1 | Pirate Red | true | | 2 | ...