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







