Data Warehouse and Business Intelligence Projects (ETL, Dimensional Modeling, Talend, Tableau, Qlik Sense, Power BI)
April 16, 2020 ยท View on GitHub
1st: Adventure Works DW, a classic sample microsofts data warehouse; best moel to understand dimensional modeling
2nd: Contoso Datawarehouse, a retail store. Handled very dirty data one of the best data model project for beginers
Created multi-dimensional data model (STAR Schema) and enhanced it to meet growing requirements
Developed a centralized data warehouse, pipelining retail data from diverse data sources using Talend Open Studio
Implemented Slowly Changing Dimensions, Rejection codes, and performance tuning on a dataset
Built interactive dashboards to analyze sales, product inventory and customer data using Tableau, Power BI and Qlik Sense