stephanie-sswl
commented
6 years ago Thanks Jordan for your feedback! It’s very insightful and much appreciated!
Best regards, Stephanie www.stephanieseow.com Sent from my📱
On 23 Jul 2018, at 1:21 AM, jordanwillis notifications@github.com wrote:
Rubric Score
Criteria 1: Report: Are conclusions clear and supported by evidence in all answers?
Score Level: 4/4 Comment(s): Great job on your presentation! Not only did it contain answers to the expected questions along with supporting data and query evidence, but it looked great as well. I particularly liked your final 3 data analysis slides because they were well organized, were able to contain a lot of info on a single slide, and included the data insights, queries, and actual raw data all together. One thing that I would recommend for the future (in case you are ever tasked with creating a presentation report of your post data analysis findings) is to ensure that your conclusions or insights are actually actionable. For example, the below example conclusions that I copied from your presentations are very insightful..
Users, who were sent 5 pairs of eyewear for home try-on, had a 79.23% conversion rate that is significantly higher than users who were sent 3 pairs as 53.03% The highest purchased eyewear model was the Eugene Narrow
But the are missing the action that should be taken (e.g. there is at most just a inference to the appropriate actions). Instead, actionable insights might be...
We should switch to always sending 5 pairs for home-try on because customers will purchase 79% of the time over only 53% with 3 pairs. Since the most purchase model was Eugene Narrow, we should experiment with offering a Narrow size for our other popular models that don't currently come in narrow. These are just some quick examples, but hopefully my point is clear. Often times those reading presentations like this are interested in hearing what you think should be done based upon the data instead of being given a bundle of facts and leaving it to them to draw their own conclusions.
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
Score Level: 4/4 Comment(s): All of your queries correctly manipulated the data accordingly! Criteria 3: Query Formatting
Score Level: 3/4 Comment(s): Your query formatting is pretty good, but don't forget to add some indentation to make things clearer! Check out the example in the SQL style guide for an example. https://s3.amazonaws.com/codecademy-content/programs/learn-sql-from-scratch/SQL+Style+Guide+for+Learn+SQL+from+Scratch.pdf
Criteria 4: Understanding underlying concepts and terminology
Score Level: 4/4 Comment(s): It was very clear that you have a good understanding of the key concepts and terminology at play in this project! Overall Score: 15/16
Overall you did a fantastic job on your project! Your presentation was very nicely done and more importantly you created queries that provided good insights about the data and business domain. Be sure to bring things to the next level by adding in some more action and keep up the great work!
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.
Rubric Score
Criteria 1: Report: Are conclusions clear and supported by evidence in all answers?
One thing that I would recommend for the future (in case you are ever tasked with creating a presentation report of your post data analysis findings) is to ensure that your conclusions or insights are actually actionable. For example, the below example conclusions that I copied from your presentations are very insightful..
But the are missing the action that should be taken (e.g. there is at most just a inference to the appropriate actions). Instead, actionable insights might be...
These are just some quick examples, but hopefully my point is clear. Often times those reading presentations like this are interested in hearing what you think should be done based upon the data instead of being given a bundle of facts and leaving it to them to draw their own conclusions.
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
Criteria 3: Query Formatting
https://s3.amazonaws.com/codecademy-content/programs/learn-sql-from-scratch/SQL+Style+Guide+for+Learn+SQL+from+Scratch.pdf
Criteria 4: Understanding underlying concepts and terminology
Comment(s): It was very clear that you have a good understanding of the key concepts and terminology at play in this project!
Overall Score: 15/16
Overall you did a fantastic job on your project! Your presentation was very nicely done and more importantly you created queries that provided good insights about the data and business domain. Be sure to bring things to the next level by adding in some more action and keep up the great work!