Goodwater Capital Commerce Data Exercise

Two-part take-home from Goodwater Capital. Part 1: Write a SQL query computing YoY growth of the trailing 28-day average of product-level app downloads across iOS and Android, joining a Products table and a Downloads table. Part 2: Analyze sales and cohort data for several successful e-commerce companies to identify common 'winner' patterns, then train a predictive model in Python to forecast Brandless's monthly sales over 12 months (through September 2019) and assess Brandless's likelihood of becoming a winner. Deliverable is a presentation for data-savvy investors plus the modeling code.