Data warehouse Project

– 2nd Step: Build or find your own idea ASAP that relates to a real case of relational database (try to find an open-source sample of databases whether in Healthcare https://medium.com/@ODSC/15-open-datasets-for-healthcare-830b19980d9 https://healthdata.gov/, Business – AdventureWorks2017 httpsD://docs.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver15, Banking, HR & Finance, Automotive, etc.)

– 3rd Step: Create your dimensional model (Fact and Dimensions) from your relational model

– 4th Step: Use PL/SQL to build the required ETL package (Extract-Transform-Load) to update your data-mart (facts and dimensions)

– 5th Step: Using Oracle OLAP to build the Multi-Dimensional Cube (Dimensions, Metrics, and KPIs Key Performance Indicators