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

No description provided.

DataLakeHouse Saleforce.com Analytics

Load data from the Million Song Dataset into a final dimensional model stored in S3.

Data Warehouse Repositories

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

Logical and Dimensional Database Creation for US School System Finance Data

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

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

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.

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

Dimensional Modeling on AWS Redshift with S3 data source

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

Evaluates Sephora's return policy using data warehousing principles.

No description provided.

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

DataLakeHouse Stripe Analytics package for DBT

Store San Francisco transaction data into SFTP and pull into a Redshift data warehouse.

Business Intelligence FER labs

Desigining Advanced Data Architectures for Business Intelligence.

No description provided.

A project to build data marts for different departments of a business from scratch, validating business logic using dimensional modelling and dbt tests, and building product sales funnel to determine drop-offs in customer engagement during the entire attribution process

Load data from the Million Song Dataset into AWS RedShift.

Repositório dos arquivos que representam todo o projeto público que consiste em trazer dados de Compras Públicas do Governo Federal e fazer análises