Gravity-Books-Data-Warehouse-2025

Gravity Books Data Warehouse – ETL & Analytics

Project Overview:

The Gravity Books Data Warehouse is a centralized system designed to store, process, and analyze data related to book sales, customers, orders, and shipping. Built using a Snowflake Schema, the data warehouse enables efficient querying and reporting, supporting business intelligence (BI) and data-driven decision-making.

Key Features:

Structured Data Model: The schema includes Fact and Dimension tables, ensuring a normalized structure for optimized performance.

ETL Pipeline: Data is extracted from multiple sources, transformed through cleansing, de duplication, type conversions, and surrogate key generation, and loaded into the warehouse.

Business Insights: The system provides valuable analytics on books, authors, customer behavior, and sales trends to support decision-making.

Scalability & Performance: The design ensures efficient storage and retrieval, enabling fast reporting and in-depth analysis.

This project enhances data accessibility and accuracy, empowering Gravity Books with actionable insights to improve sales strategies and customer engagement.