nattamon-ch / amazon-books-data-sql

The "Amazon-Books-Data-SQL" project delves into categorizing and analyzing Amazon's top fiction and non-fiction books. Using SQL, it examines trends in ratings and reviews, providing insights into reader preferences and market dynamics. The repository houses SQL scripts, data files, and an analysis summary to explore book sales patterns.

Amazon-Books-Data-SQL

The "Amazon-Books-Data-SQL" project delves into categorizing and analyzing Amazon's top fiction and non-fiction books. Using SQL, it examines trends in ratings and reviews, providing insights into reader preferences and market dynamics. The repository houses SQL scripts, data files, and an analysis summary to explore book sales patterns.

Amazon-Books-Data-SQL

Project Overview

This repository contains an SQL database and analysis of 550 Amazon books categorized into fiction and non-fiction. It includes queries for top 50 bestsellers, high-rated books in 2019, and books with significant reviews in 2018, along with custom analyses.

Data Description

• data: Contains the Amazon.xlsx and Amazon.csv files with book details.

SQL Database and Queries

• sql/Amazon.book_information.sql: SQL script for database creation, data insertion, and queries execution.

Analysis Documentation

• documentation/Amazon Book Data Analysis Summary.pdf: Summarizes the query results and provides insights into the dataset.

Getting Started

To replicate this analysis:

1. Set up a SQL server and execute the Amazon.book_information.sql script.
2. Review the data files for an understanding of the book details.
3. Consult the documentation for analysis insights and query summaries.

Tools Used

• SQL for database and query management.
• Excel or compatible software to view the raw data files.