zzq126
commented
7 years ago Hi Chris, Thanks for your comments and I joined to two tables in problem to study the intersection between views and visits and to see if there is correlation between the 2 factors. Thank you and have a good day!
Cheers, Ziqing
Great job with this project, it was very easy for me to go through.
The column descriptions were great and I really liked how you gave us the aim of your analysis so we knew what direction the project was heading in. One thing I noticed which I would have liked to see an explanation for was there was a record with 'none' for page, title, and visits, but it had 23123911 views; I am really curious as to what that record might be.
You did a good job giving a better name to the null values within three of the attributes when creating your tables suing SQL. I was a bit confused by your problem 2 analysis where you joined two tables, I am not really sure what you were trying to show there. With that being said the end analysis was really interesting.
Your star schema was simple and well done and made it easy for me to see what you were doing within the notebook. I liked how you added the quarter column to the webtime dimension table, and you did a good job creating the fact table--my group did something similar.
I thought your problem 4 analysis was great and easy to follow. I really liked your use of rollups, which I did not really understand but seeing how you did it made it clear how to use them. The use of matplotlib was really interesting and gave great visuals for your analysis. Very nice job overall!