Summary - Meets Expectations (14/16)

[Tzuridis]

Rubric Score

Criteria 1: Report:

Score Level: 3 (Meets Expectations)

This is a good presentation deck but there are some issues with some styling and formatting such as on the first slide as you can see below:

The organization of your slides is great providing the SQL queries, results and text interpretation in a very balanced way (without feeling like the page is overcrowded). The overlay of SQL results over the "Style Quiz" is also good.

Criteria 2: Query Accuracy

Score Level: 3 (Meets Expectations)

All queries accurately retrieve the data intended. In question 3, SQL is capable of creating new columns from calculations on existing columns, so there is a way to achieve this analysis with SQL queries. But it is somewhat cumbersome in this case, so I understand why you avoided that.

Criteria 3: Query Formatting

Score Level: 4 (Exceeds Expectations)

Queries are formatted according to the SQL style guide. Some highlights are making good use of aliases for tables and renamed columns for improved readability.

Criteria 4: Understanding the underlying concepts and terminology

Score Level: 4 (Exceeds Expectations)

The report demonstrates a clear mastery of funnels and the data sets we're working with. The interpretation of results not only report the findings but also wonder what could be driving that behaviour. The actionable insights you developed dig into the data and examine trends that would affect different segments of Warby Parker's customer base.

Overall Score: 14/16

You did a great job. The presentation is great at navigating through the business problem, interpreting the data and engaging the client's curiosity. You are capable of using the SQL to explore the dataset and extract meaning for executives. Well done.

[dcko]

@Tzuridis

Thank you for reviewing! It all makes sense and I appreciate the time you spent. My only question is on the first score (Report). I am not seeing the misformatted title page on my version or when I view through Google drive. Is it possible this is a version compatability issue? Can you please double check. I've attached how I see the title page.

Thank you, Dan

[Tzuridis]

When I check it through Google Drive you are correct there is no issue, it is a compatibility issue as I still have the issue locally. One other thing to solve this though is to make it a .pdf, pptx can result in issues like this and the pptx is too large to be loaded on GitHub as well so it has to be downloaded instead of previewed on GitHub.

Good job overall though, the power point presentation obviously isn't as important as the SQL queries.