Data warehouse Project
Budget: ₹1,500 – ₹12,500 INR
- 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
- 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