## 3 Methods and Results
### Data Collection
#### 3.2.2 Data Analysis and Distribution  
The web scraper presented above is used to retrieve all employees' reviews posted on Indeed.com--the first job site in the world with over 250 million unique visitors every month. The final dataset contains reviews for Amazon, added by different employees worldwide. The time range for all entries extracted is from 15 February 2012 until 3 January 2022.  
In the Table 3 below, there can be observed the overall rating of 3.49 across all years. The lowest rating was recorded for management (2.92 out of 5.00) and the greatest for pay benefits (3.47 out of 5.00) close to the average overall rating--which means that most of the employees are satisfied with their salary packages.  
\begin{table}
\begin{tabular}{c c c c} \hline \hline
**Method** & **Time** & **Number of Records** & **Cluster Type** \\ \hline Using metadata & 3.40 h & 66,854 & Runtime version: 10.3 \\ \hline Without metadata & 1.58 h & 67,141 & Worker type: 14 GB Memory, 4 cores \\ \hline \hline \end{tabular}
\end{table}
Table 2: Timing for web scraping.  
\begin{table}
\begin{tabular}{c c c c c c c} \hline \hline
**Year** & **No of Records** & **Avg Overall Rating** & **Avg Work-Life Balance** & **Avg Pay Benefits** & **Avg Job Security** & **Avg Management** & **Avg Culture** \\ \hline
2012 & 539 & 3.71 & 2.99 & 3.38 & 2.92 & 2.98 & 3.19 \\
2013 & 1265 & 3.78 & 2.99 & 3.32 & 2.85 & 3.01 & 3.24 \\
2014 & 2032 & 3.74 & 3.05 & 3.33 & 2.9 & 2.91 & 3.15 \\
2  
In the graph below from Figure 3, there can be seen the top five locations with the greatest number of reviews--where the employees from Phoenix, AZ added 1091 reviews. The next location by the number of records is Seattle, WA with 1078 entries, followed by San Bernardino, CA (875), and Baltimore, MD (848).  
A similar bar chart grape from Figure 4 to display the job positions with most of the reviews. We can notice that most of the reviews come from warehouse employees (Warehouse Associate, Fulfillment Associate, Packer, Picker or Stower) and there are fewer reviews posted by IT employees (where the job position contains the 'Software' keyword). Moreover, we can see the positions with the highest numbers of reviews described in Figure 5.  
Figure 4: Top 10 jobs distributed based on number of reviews.  
Figure 5: Top 5 jobs distributed based on number of reviews.  
Figure 3: Top five locations chart for the provided reviews.  
One more way to visualize the entire dataset and different metrics associated with it is to also import the entire dataset into a business intelligence tool and observe the distribution of data per different categories.  
For example, in Figure 6, one can observe the rating distribution by the number of records using bar-chart graphs. In the first histogram, the distribution of job security is represented, and it can be noticed that most of the respondents consider that Amazon offers 3 out 5 for job security. Moreover, as it can be observed in the fourth graph, almost 10k of the reviews from the dataset seem to be satisfied with the pay benefits received, as they offered the maximum value for the rating. Nonetheless, the visualizations have been realized using Power BI for a more practical way of understanding the data.