Oracle Datawarehouse setup with ETL and running queries.
Budget: $30 – $250 USD
Build a Datawarehouse project,ETL to load data and run complex queries on Oracle Database.
Requirement:
1. Project can be based on covid or anyother data.
2. Create 2 fact table and 5 or 6 dimensional table. Constellation design ERD diagram.
3. Need to know from where source of data , basically it should be 2 different data sets.
4. DDL/DML/index scripts. ETL to load data (python using oracle db or insert.sql to load data.
5. 6 to 7 business questions based on ERD diagram.
6. sql Query to answer the business questions based on the above data.
7. Complete documentation and explanation of erd relationship and step by step source code.
I need to learn this setup and practise based on the above setup and test on different technologies.
Please let me know incase of any questions.
Requirement:
1. Project can be based on covid or anyother data.
2. Create 2 fact table and 5 or 6 dimensional table. Constellation design ERD diagram.
3. Need to know from where source of data , basically it should be 2 different data sets.
4. DDL/DML/index scripts. ETL to load data (python using oracle db or insert.sql to load data.
5. 6 to 7 business questions based on ERD diagram.
6. sql Query to answer the business questions based on the above data.
7. Complete documentation and explanation of erd relationship and step by step source code.
I need to learn this setup and practise based on the above setup and test on different technologies.
Please let me know incase of any questions.