Model an star schema from raw normalized Olympic Games data using dbt - postgres, airflow and docker

Batch & streaming data pipelines built using Databricks with Pyspark and modeled the data into star schema to analyze in PowerBI, Formula-1 racing data from multiple data sources, APIs.

All in one slice and dice module

Build a data warehouse from scratch, including full load, daily incremental load, design schema, SCD Type 1 and 2.

Building Data Warehouse and ETL pipelines using Amazon S3 and Redshift

Creating a Data Warehouse using Aws Redshift.

Simple scripts for data cleaning, etl transformations and data reorganisations

ETL pipeline that extracts and transforms student athlete academic performance data, then populates a data warehouse using a star schema dimensional model.

A Postgres database using a star schema to facilitate the analysis of user behaviour on a music streaming app.

A data warehouse on Amazon Redshift using a star schema to facilitate the analysis of user behaviour on a music streaming app.

Udacity Data Engineering Nanodegree - Project #5

Data Modeling with Apache Cassandra

This repository contains code for building a Data Warehouse from scratch. I started with the elicitation process, then used functional dependencies for conversion to GOM4DW schema, followed by conversion to Star Schema to find out different facts and dimensions and lastly I implemented the ETL process. I have used HTML and flask to provide a use…

Udacity project: implementing an ETL process on a PostgreSQL DB to create a star schema data model

Create Data Lake on AWS S3 to store dimensional tables after processing data using Spark on AWS EMR cluster

This is a flask application that converts an informational model of a decision problem to a snow-flaked star schema

University lab exercises with processing big data.