Introduction

To extract insights from your database, you need data. While many companies store and update data within a central database, there are scenarios in which you will need more data than is currently in your database. For example, you are working on an ambitious project to revamp a website whose performance has progressively degraded over the past nine years. The first step in solving such a problem is to do a root cause analysis of it. The central database houses daily logs of the site's page load times along with other details. You will need to retrieve this data, clean it up, and filter out the entries where the page load times were over a certain threshold. You will need to share this information with a team of engineers and developers who will categorize these outliers, attributing the poor load times to a server issue, badly written code, network failure, or poor caching, among other things. You will then need to do an analysis of the categorized data and update...