/projects
ERP & CRM Data Warehouse
End-to-end data warehousing and analytics project built with SQL Server using the Medallion Architecture. It covers data ingestion, transformation, modeling, and reporting, showcasing best practices in data engineering and analytics.
Highlights
- Integrated ERP and CRM data with T-SQL transformations
- Implemented star schema for analytics-ready datasets
- Created Power BI dashboards delivering key business insights and KPIs
Technologies
SQL ServerT-SQLPower BIMedallion ArchitectureData ModelingData Warehousing