Bookstore Data Analysis Project

Developed a complete end-to-end data project for a bookstore, starting from database design

to interactive dashboards.

Features:

• Designed a relational database with tables: Book, Author, Category, Employee, Branch, Review,

Customer, Sale, SaleLine, Inventory, Belongs_to, Written_by.

• Cleaned and transformed raw data using Python (Pandas, NumPy).

• Built SQL queries for sales, inventory, and customer behavior analysis.

• Created dashboards in Power BI / Excel for clear and dynamic insights.

Tools Used:

• SQL (Database Design & Queries)

• Python (Pandas, NumPy for preprocessing)

• Excel / Power Query

• Power BI (Visualization & Dashboards)