As a part of the Udacity Full Stack Web Developer Nanodegree programme, this project involved writing SQL queries and a Python reporting tool to answer three specific questions.
The scenario is that a newspaper website needs a reporting tool that the boss can run and get valuable insights, rather than looking through raw server logs. The logs are written to a PostgreSQL database that the reporting tool needs to run queries on to answer the following three questions:
- What are the most popular three articles of all time?
- Who are the most popular article authors of all time?
- On which days did more than 1% of requests lead to errors?
To review the project, check it out on GitHub here: