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.

Analysed the Airbnb Business Requirement to design ER Diagram (Normalized) and Dimension Model (Fact with Dimensions)

Source code for the Kimball-style date dimension generator dimdates.com.

Logical and Dimensional Database Creation for US School System Finance Data

assignments and projects for Yeshiva University's Katz School Information Architectures course, spring 2020

Dimensional Modeling on AWS Redshift with S3 data source

All the necessary scripts so as to set up a data warehouse with three databases.

PostgreSQL, Data Modeling, Star Schema, ETL, Data Engineering

Evaluates Sephora's return policy using data warehousing principles.

This project builds a cloud-based ETL pipeline for Sparkify to move data to a cloud data warehouse. It extracts song and user activity data from AWS S3, stages it in Redshift, and transforms it into a star-schema data model with fact and dimension tables, enabling efficient querying to answer business questions.

DataLakeHouse Stripe Analytics package for DBT

Easy-to-understand data modeling with Postgres to ETL data into a Star Schema

Desigining Advanced Data Architectures for Business Intelligence.