Summary - Githubissues

Rubric Score

Criteria 1: Report

Score Level: 2 (Approaches Expectations)
Comment(s): Your slides provide minimal interpretation of the SQL queries. Although you provide SQL queries and tables and describe what each step of syntax in the query is doing, there are few connections made about the meaning of these results (with the exception of "1.3"). The lack of exploration is especially apparent in the home-try on funnel ("2.1"). We want you to demonstrate that you thought about the data and its meaning. Also, you actionable insights slide is completely blank and do not provide any recommendations for the client.

Criteria 2: Query Accuracy

Score Level: 3 (Meets Expectations)
Comment(s): Most queries accurately retrieve the data intended. However, some of your queries are incomplete. Specifically, funnel 2.1 only combines the tables, but it does not summarize the data - please see my note for further explanation.

Criteria 3: Query Formatting

Score Level: 4 (Exceeds Expectations)
Comment(s): Your queries are generally formatted correctly. Queries adhere to 7 rules of the style guide.

Criteria 4: Understanding underlying concepts and terminology

Score Level: 1 (Does Not Meet Expectations)
Comment(s): You do not demonstrate a sufficient understanding of funnels. In quiz funnel (1.3) you do not calculate conversion correctly and in the home trial funnel (2.1), you fail to create a funnel at all. I have already gone over the home trial funnel here. In regards to the quiz funnel (1.3): it is important to note the funnels are calculated by measuring the drop-off between each consecutive step not just the initial count. The correct way to calculate the conversion rate between questions is as follows:

Question	# of Responses	Calculation	Percent Completed
1	500	= 500/500	100.0%
2	475	= 475/500	95.0%
3	380	= 380/475	80.0%
4	361	= 361/380	95.0%
5	270	= 270/361	74.8%

Therefore, the questions that are most contributing to drop off are: (5) When was your last eye exam? and (3) Which shapes do you like?. Question (4) Which colors do you like? is one of the highest performers.

Overall Score: 10/16

Although you did demonstrate some ability to format and execute SQL queries, you failed to demonstrate any deeper understanding of the data. You did not provide any recommendation on how Warby Parker can improve conversion rates and better serve their clients. I recommend you review subqueries and how to calculate conversion by each-consecutive-step in a funnel. Then take some time to consider how Warby Parker can adapt their business model (i.e. change the order of questions or wording in the survey? make 3 or 5 trial pairs the standard?) to secure more customers.

chelloveswine / sql-scratch-capstone-turn-in

Summary #2