Data Analysis of the Amazon Top 50 Bestselling Books 2009-2020 Dataset.

Objective

Extensively analyze the data using SQL

Data

The dataset is a table file of the Top 50 Bestselling Books between 2009 and 2020 on Amazon. It was gotten from Kaggle. It contains:

• Name
• Author
• User_Rating
• Reviews
• Price
• Year
• Genre

Data Cleaning

The whitepaces in the name of some authors were removed inorder for them to match correctly. The cleaned dataset is then analyzed

SQL Analysis

This analysis was made to derive insights from the dataset.

Tableau Dashboard