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:

  1. What are the most popular three articles of all time?
  2. Who are the most popular article authors of all time?
  3. On which days did more than 1% of requests lead to errors?

To review the project, check it out on GitHub here:


Photo by Thomas Peham / Unsplash