Usage Funnels with Warby Parker

sandeep921348 · July 16, 2020, 2:59pm

this my code of this project

gist.github.com

https://gist.github.com/codecademydev/dd6e0dcdc69f2430260a5deae695d2c1

project.sqlite

SELECT *
FROM survey
LIMIT 10;

SELECT question,
   COUNT(DISTINCT user_id)
FROM survey
GROUP BY question;

This file has been truncated. show original

and presentation file or project assignment
https://drive.google.com/file/d/1CXb2frB-V2TUBdNG6tRIXQO411ECdgoK/view?usp=sharing

garima86 · July 16, 2020, 6:08pm

Could not access your google doc. You need to change the settings for that document.

sandeep921348 · July 17, 2020, 6:40pm

codeneutrino · July 17, 2020, 10:23pm

From looking through the code/results, this looks good! Just with the last screenshot, the ; is on a line all by itself (at the bottom of the code).

thezaplin · July 25, 2020, 5:29am

Hello everyone!
I would love to share with you my presentation, and I’d appreciate your feedback about the results.

Do you agree with my findings?
Do you find it logical?
Or maybe you want to correct something?

Feel free to reply.

codeneutrino · July 25, 2020, 5:40am

Hello @ivtcaplin7896913170, welcome to the forums! I think you’ve set your slideshow out in a very logical and interesting manner, while your visual aids (the graphs, especially the one with 20% drop and 25% drop on them), made understanding your conclusions easy. The code also looks good!

thezaplin · July 25, 2020, 6:03am

Thank you, @codeneutrino, for your kind words!
And special thanks for welcoming me to the forum

joyce.wong · August 16, 2020, 12:09am

Just finished this project a few days ago and was taking a look at how other people did the project too. Was wondering what software you used to make your cool infographics? It looks really professional!

thezaplin · August 21, 2020, 3:26am

Dear Joyce,

Thank you for your kind words about the presentation. (and sorry for the late response).
I usually use PowerPoint to create a presentation. But also, you can use Canva and get inspiration from templates.
Don’t forget that practice makes perfect

Good luck with your learning journey!

mm1002 · September 22, 2020, 12:24pm

Hy Guys,

please find below my presentation.
I would really appreciate if you provide me with your feedback, suggestions, etc.

Do you agree with my findings?
Do you see any flaws?

Thks

Michele

chloe_mcc · December 30, 2020, 11:20am

very impressive, love the cool-looking slides as well.

yunies · April 18, 2021, 1:06pm

I am just finished my project, thank you for this guide line

georggatchev68959644 · May 12, 2021, 4:39pm

Hi everyone ,

Here is the link to my Warby Parker presentation: SQL_Usage Funnels_Warby Parker.pptx - Google Drive

If you could please share with me your comments on my:

Code/queries: Are they correct? Can they be made better?
Answers/conclusions: Are they correct?

Any feedback would be greatly appreciated

harshabindu · June 1, 2021, 10:35pm

Hey Everyone,

It would be greatly appreciated if you can have a look at my Warby Parker presentation for Usage Funnels and let me know your feedback on queries and analysis.

Thanks in advance!

atesoniero · July 24, 2021, 10:10am

Hello everyone,

here is my ‘Warby Parker Marketing Analysis project’.
I hope it might be helpful.
Let me know your thoughts about it.

Thanks

fjorwb · April 6, 2022, 4:06pm

Hello everyone,

Here is my data analsis on Warby Parker.

Warby Parker - Data Analysis with SQL

Let me know your comments,

rambosan · April 28, 2022, 8:59am

Thanks.
Was struggling a bit with task 6, your code was clean elegant and helped me understand where i went wrong in a sec.

jlgarciatucci · April 29, 2022, 8:00am

Hello everyone,

Please check my project for the SQL Skill Path on usage of funnels, you can download the pdf presentation at my github link below, there is also the jupyter notebook for the funnel and histogram plots in plotly.

Thank you and best regards.

Jose Luis Garcia Tucci

dorischu5366006549 · August 29, 2022, 8:46am

I just begin this project. Just wonder what is the fair amount of time to complete this project and the presentation? any comment?

summerlane · September 19, 2022, 11:42pm

@atesoniero - What program did you use to make all your tables and funnels? They look really nice! I would love to know how to make my charts look that great.