Analysed the Airbnb Business Requirement to design ER Diagram (Normalized) and Dimension Model (Fact with Dimensions)
-
Updated
Feb 11, 2019
Analysed the Airbnb Business Requirement to design ER Diagram (Normalized) and Dimension Model (Fact with Dimensions)
PostgreSQL, Data Modeling, Star Schema, ETL, Data Engineering
Projects done in the Data Engineering Nanodegree by Udacity.com
Create Data Lake on AWS S3 to store dimensional tables after processing data using Spark on AWS EMR cluster
Business Intelligence and Data Warehousing Project
Logical and Dimensional Database Creation for US School System Finance Data
Load data from the Million Song Dataset into AWS RedShift.
Load data from the Million Song Dataset into a final dimensional model stored in S3.
Dimensional Modeling on AWS Redshift with S3 data source
Projects from data engineer nanodegree @ Udacity
3NF conversion to dimensional modelling and OLAP operations, Advanced SQL queries(DML)
Data Warehouse Repositories
Easy-to-understand data modeling with Postgres to ETL data into a Star Schema
assignments and projects for Yeshiva University's Katz School Information Architectures course, spring 2020
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
All the necessary scripts so as to set up a data warehouse with three databases.
Store San Francisco transaction data into SFTP and pull into a Redshift data warehouse.
This repository contains about final exam from data warehouse course at my college
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."