- 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 [login to view URL]@ODSC/15-open-datasets-for-healthcare-830b19980d9 [login to view URL], Business - AdventureWorks2017 httpsD://[login to view URL], 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
Hi
I am very good for MySQL, MongoDB and PostgreSQL
So I can work with your project perfectly
Please discuss with me start work
I am ready for you
Thank you!
Hello there I am Ammar Shaikh I have 6 years experience in Database Administration, SQL, Oracle, database programming, database development , I had read the above project details, kindly ping me for more details.
Hi,
I have worked as a Business Intelligence Engineer. I have experience in Designing Dimensional Model, Data Warehousing, Have worked on 2 BI Projects from the Scratch as a Full stack BI Engineer. Have Designed many Procedures , Packages to perform ETL over Millions of records. I have a deep understanding of KPIs and have designed in multiple OLAP Cubes in order to use them in visualization. I have extensive experience in Designing and implementing Metrices according to the requirement of customer.
hello,
I can deliver what is required as per the description .I am working as etl developer and have total 7 years of experience into etl development.
Please connect for more details