Welcome to the GravityBook_DWH_Project repository! This project showcases the development of a cutting-edge data warehouse tailored for Gravity Bookstore, a fictional bookstore capturing information about books, customers, and sales.
The primary goal of this project is to design and implement a sophisticated data warehouse solution that enables Gravity Bookstore to efficiently manage and analyze its vast repository of transactional data. Leveraging advanced techniques such as Slowly Changing Dimensions (SCD) and SQL Server Integration Services (SSIS), this repository presents a comprehensive approach to data warehousing.
The galaxy schema serves as the foundation of our data warehouse, providing a robust framework for organizing data into fact and dimension tables. SQL scripts are utilized to create the necessary tables and establish relationships, ensuring seamless data modeling.
SSIS packages are employed to facilitate the Extract, Transform, Load (ETL) processes, enabling the seamless transfer of data from the OLTP Gravity Bookstore database to the data warehouse. Both full and incremental loads are implemented to optimize data migration and ensure data consistency.
