Logs Analysis Project

By Robert Vo

Objective

Build an internal reporting tool that will use information from a news database to discover and 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?

Required Skills

• Relational Datasbases
• SQL
• Python

Tools Preparation

1. Install Vagrant
   
2. Install VirtualBox
   
3. Download or clone from Github the necessary setup files from fullstack-nandegree-vm repository
   
4. Download the database setup file - Download data here
5. Unzip the file after downloading it.
6. Find the file, newsdata.sql, and put it into the vagrant directory which is shared with your virtual machine
7. Download this reporting tool - Logs Analysis Tool
8. Copy the files into the vagrant directory

Start the VM

1. Change your current working directory to vagrant directory.
   
2. Open Terminal and run vagrant up to build the VM.
   
3. Run vagrant ssh to log in and connect to the VM.
   
4. Once you're in vagrant, run cd /vagrant to change the directory to the vagrant directory.
   
5. Run command psql -d news -f newsdata.sql to load the database
   
6. Use command python logs_analysis.py to run the programm