Capstone: Funnels with Warby Parker
Learn SQL from Scratch
Warby Parker is a transformative lifestyle brand with a lofty objective: to offer designer eyewear at a revolutionary price while leading the way for socially conscious businesses. Founded in 2010 and named after two characters in an early Jack Kerouac journal, Warby Parker believes in creative thinking, smart design, and doing good in the world — for every pair of eyeglasses and sunglasses sold, a pair is distributed to someone in need.
In this Capstone Project, you will analyze different Warby Parker’s marketing funnels in order to calculate conversion rates. Here are the funnels and the tables that you are given:
Home Try-On Funnel:
Let’s get started!
First, go to the Capstone Project, which will guide you through the queries you need to write with a series of questions. Make sure to save your queries and results — you’ll be using them in your presentation.
Then, create a set of slides using Google Slides, Microsoft PowerPoint, or some other presentation software. Your presentation should answer all of the questions in the project. Each answer should include a text explanation and data to support your claim. The queries used to find that data should be included in a separate .sql file.
- Template: We recommend that you use the template linked here. This template contains examples of the types of slides you’ll want to use.
- Rubric: Your work will be reviewed by a Codecademy coach against this rubric. Make sure to check your work before submitting! You can find submission instructions in the next step in the Learn SQL from Scratch dashboard.
For a refresher, go to the Funnels Lesson.
Note: This project is a collaboration with Warby Parker’s Data Science team (thank you!) and uses fictional data.
Codecademy’s very own Nick Duckwiler (left) and Ryan Tuck from Warby Parker (right) adding finishing touches to the project.