You can find the SQL code and query results here.
Usage Funnels and A/B Testing with Warby Parker
It had been a while since I used SQL, so I decided to refresh my memory by retaking the SQL course on CodeCademy. Thankfully, writing queries is like riding a bike… at least, if I could ride a bike, but that’s neither here nor there.
Anyways, the first project was a simple one: take some fictional data from Warby Parker’s at home try on A/B testing, create a usage funnel, and analyze the results of the A/B testing. Then, create a presentation about your findings.
Prezi
I could have used normal presentation software like PowerPoint, Slides, or Impress. I’m intimately familiar with all three and it would have taken me maybe fifteen minutes. But, honestly? Where is the fun in that? I thought back to my undergrad years, when my Technology in Education professor taught us how to use Prezi. Turns out: Prezi is still around and is better than ever!
Back in the late ’00s and early ’10s, Prezi was cool. Users could create a presentation by arranging media of various sizes and shapes on a board, then selecting the order that viewers could zoom in, out, and over that media. Since then, they have built on that capability, but also added a bunch of cool stuff:
- Powerful data extensions using programs like PostgreSQL, MySQL, and Oracle.
- The ability to overlay your presentation over video for videoconferencing.
- The ability to record videos of you giving your presentation.
- The ability to make interactive infographics.
For this project, I elected to make an interactive infographic of my data, but I’m incredibly stoked to play around with all of Prezi’s data analysis and visualization tools in future projects!
If the infographic does not show above, try refreshing the page– or just giving it a minute to render.