This project was an exciting opportunity to bring Customer Data Management with a well-structured Data Warehouse, providing scalable and high-performing solutions. Looking forward to applying these skills to future challenges!
this is what I used: SQL Server for database and data warehouse management:
ERD, Data Mapping
Stored Procedures & Functions
Views & Indexes
User Logins and Security
SSIS for ETL processes:
Extract, Transform, and Load operations to streamline data integration into the Data Warehouse.
Python for data visualization, enabling deeper insights into customer data trends.
Power BI for building interactive and dynamic dashboards, turning data into actionable insights.