SQL Datawarehouse
تفاصيل العمل
This project adopts the Medallion Architecture to progressively enrich and improve data quality: 🥉 Bronze Layer (Raw Data): Acts as the landing zone for raw data ingested from source systems (ERP and CRM CSV files) directly into the SQL Server database. No transformations are applied at this stage. 🥈 Silver Layer (Cleansed & Conformed): Data is cleansed, standardized, and normalized. This layer resolves data quality issues, handles missing values, and ensures data consistency across the pipeline. 🥇 Gold Layer (Business-Ready): The final layer where data is modeled into a highly optimized Star Schema. This layer is specifically designed to support reporting tools, BI dashboards, and complex analytical queries.
مهارات العمل
بطاقة العمل
طلب عمل مماثل
