Design and implement a complete ETL pipeline ,data modeling, data warehousing concepts, and ETL best practices using industry-standard tools.

This project is an ETL (Extract, Transform, Load) solution built using SSIS (SQL Server Integration Services).

Its goal is to populate a Data Warehouse (GravityDW) from the source database (GravityBooks) to enable reporting and analytics on book sales.

The ETL process includes three main components:

Dim_Customer: Extracts customer data, standardizes data types, and creates a full name column.

Dim_Book: Extracts book information, converts data types, and standardizes text fields.

Fact_Sales: Combines orders and order_items, performs lookups to dimensional tables, calculates a DateKey, and loads the fact table for reporting.