codecademy_sql_capstone's People
codecademy_sql_capstone's Issues
Page name
Just being nitpicky, you could also include the page_name column for analysis to double check your result.
Simplifying Last touch
Simplifying first touch
For cleaner code, this could all be defined as a separate table to be called upon when determining first touch counts.
Otherwise, very good use of code ๐
Labeling which capstone this is
Without opening the presentation file, it is hard to tell which capstone project you worked on. Consider including the name of the capstone in the filename or as a /* comment in the coding.
Summary
Rubric Score: 14/16
Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?
- _Score Level: 2
- _Comment(s): There were some fine detail questions that were missing answers in the presentation. From the code, it is clear that you were able to get these results, so it's important to include even the smallest detail. You are missing information on the total number of purchases that were made and what the typical user journey was [whether predicted or extrapolated from the data]. It might help to include a slide at the beginning of the questions you aim to answer so you can use it as a checklist of what needs to be included in the slides.
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
- _Score Level: 4
- _Comment(s): The code was accurate and you were able to retrieve the right answers from the data.
Criteria 3: Query Formatting
- _Score Level: 4
- _Comment(s): Your code followed the style guide for how to write clear SQL code.
Criteria 4: Understanding the underlying concepts and terminology
- _Score Level: 4
- _Comment(s): The presentation was absolutely beautiful! It was clear you understood the data and how to express your findings. There were parts you could have elaborated on, like which utm_source paired with which utm_campaign was the most effective, but that's me being nitpicky.
Overall Score: 14/16
NICE JOB! Your presentation was one of the best I've seen so far, and it's clear you understood data manipulation. I encourage you to play around with the data more to see if you discover anything new, and maybe even work on graphical visualization of the data [pie charts, bar graphs, etc] if you happen to know how to do that.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.