Description: Demonstrated a comprehensive data warehousing solution, encompassing ETL, in-depth analysis with SSAS, and dynamic reporting with Power BI.
•
Data Source: Utilized the "Gravity Book Sales" transactional database.
•
Key Achievements:
•
Led ETL processes with SSIS to ensure accurate and timely data extraction and transformation.
•
Developed an advanced data model using SSAS in Tabular Mode to support data analysis.
•
Created dynamic reports and dashboards in Power BI, enabling stakeholders to access data insights.
•
Applied DAX for intricate calculations, enhancing data-driven decision-making.