top of page

Create Your First Project

Start adding your projects to your portfolio. Click on "Manage Projects" to get started

Online Bookstore Sales Database Analysis using SQL

Project type

Data Analytics

Date

December 2024

Location

Accra

In this project, I created and queried a simulated database for an online bookstore to analyze sales performance and customer behavior. The dataset included tables for books, customers, orders, authors, and inventory. Using SQL, I wrote queries to identify best-selling books, frequent customers, and monthly revenue trends. I also performed data joins, aggregations, and filtering to answer key business questions such as which genres were most popular and which customers had high lifetime value. This project demonstrates my ability to manage and analyze relational data using SQL for data-driven decision-making.

bottom of page