Data Warehousing Portfolio

In addition to my experience writing SQL queries, I also have a strong foundation in data warehousing principles which I learned in the Coursera course Data Warehouse Concepts, Design, and Data Integration.

Schema Development and Entity Relationship Diagrams

In the exercise below, I took a written summary of the data a business needed to collect, and designed a data warehouse to suit their needs.

ETL Design Using Pentaho Data Integration

In the exercise below I used an open source ETL tool, Pentaho Data Integration, to clean and join inventory data from an access database with columns from several dimension tables. Data was ultimately inserted into an inventory fact table in the data warehouse.