مشروع كتب

** Database to DWH Evolution: Transformed the database to a Data Warehouse, implementing a Galaxy schema for sophisticated data analysis, using fact accumalative table to track item lifecycle stages.

** Data Lineage Maintenance: Implemented a data lineage system, including a source system code column, to track the origin of each piece of data, ensuring transparency and accountability throughout the analytical process.

** Data Integration with SSIS: Executed sophisticated ETL processes using SQL Server Integration Services, integrating Slowly Changing Dimension (SCD) techniques to ensure data accuracy and timeliness.

** Enhanced Analytics with SSAS: Used SQL Server Analysis Services to construct cubes and analytical models.

** Power BI integration: Imported and modeled data in Power BI, creating interactive dashboards that unlock valuable business insights.