Projects done in the Data Engineering Nanodegree by Udacity.com
Business Intelligence and Data Warehousing Project
Create Data Lake on AWS S3 to store dimensional tables after processing data using Spark on AWS EMR cluster
DataLakeHouse Saleforce.com Analytics
Data Warehouse Repositories
Load data from the Million Song Dataset into a final dimensional model stored in S3.
Logical and Dimensional Database Creation for US School System Finance Data
Analysed the Airbnb Business Requirement to design ER Diagram (Normalized) and Dimension Model (Fact with Dimensions)
assignments and projects for Yeshiva University's Katz School Information Architectures course, spring 2020
Source code for the Kimball-style date dimension generator dimdates.com.
Dimensional Modeling on AWS Redshift with S3 data source
PostgreSQL, Data Modeling, Star Schema, ETL, Data Engineering
All the necessary scripts so as to set up a data warehouse with three databases.
DataLakeHouse Stripe Analytics package for DBT
Store San Francisco transaction data into SFTP and pull into a Redshift data warehouse.
Business Intelligence FER labs
Easy-to-understand data modeling with Postgres to ETL data into a Star Schema
Add a description, image, and links to the dimensional-model topic page so that developers can more easily learn about it.
To associate your repository with the dimensional-model topic, visit your repo's landing page and select "manage topics."