etl and dataware house

Data Warehouse Design

Built a fact table with historical records

Used a snowflake schema to normalize the dimensions

Applied Slowly Changing Dimensions (SCD) on attributes like:

▫️ book_price

▫️ customer_email

▫️ customer_address_status

▫️ shipping_price

Transformations & Calculations

Added new measures that weren’t in the raw database:

▫️ order_quantity

▫️ total_price

Extracted the book_price indirectly (since it wasn’t directly available in the DB)

Designed the fact table to hold historical data, enabling time-based analysis

ETL & Visualization

Built ETL pipelines using SSIS to load and transform the data

Connected everything to Power BI for building an interactive dashboard with insights