Analytical SQL
In this project, I utilized SQL to create ad-hoc queries from an Oracle Cloud ATP Database. Then I utilized excel to create a pivot table to aggregate values such as total revenue. Lastly, I utilized tableau desktop to create dashboards and data visualizations.
View
ETL
In this project, I utilized Pentaho Data Integration to perform ETL on the data. I did this to transition an OLTP to an OLAP for deep history analytical queries that enables concurrecy control. Then I extracted an SQL View with Oracle SQLDeveloper to display KPI in my BI tool.
View
Data Warehousing for Analytics
In this project, I worked with a group member in an asynchronous fashion by utilizing online collaborative environments such as Discord and Google Drive. We created Dimensional Models and implemented a Data Warehouse by utilizing Tableau.
View