star-schema

A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.

Udacity Data Engineering Nano Degree (DEND)

Personal Data Engineering Projects

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

DWH Star Schema

Udacity Data Engineer Nanodegree - Postgres data modeling

Data Warehousing (DW) Project Building and Analysing a DW for NatureFresh Stores in NZ, built using a high-performance Oracle database 12c, and Index-Nested Loops Join-Oracle.

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

YAML format for star schema and snowflake schema

Udacity Data Engineer Nanodegree - Data Modelling with Postgresql

Udacity Data Engineer Nanodegree - Redshift data modeling

Data Engineering Projects including Data Modeling, Data Warehouse, Data Lake Development

Udacity Nano Degree Post Gres Datamodelling

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

Creating a Data Warehouse using Aws Redshift.

creates postgres ETL pipeline on a star schema.

Star Schema design and Data Ingestion

This is a project for Udacity's Data Engineering nanodegree program. It's goal is to satisfy a mock start-up -Sparkify's requirement of querying a large amount of data.

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

Created a Postgres database and built an ETL pipeline to optimize queries on song play analysis. The fact and dimension tables for a star database schema for a particular analytic focus are defined, and an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL was developed.

All in one slice and dice module

Projects from Udacity Data Engineer Nanodegree

Building a relational database using simulated songs and users' activities with Postgres.

Data Warehousing project | Outsourced for Autumn Group | Retail Outlet DW | Melbourne based | Sep - Feb 2018

University lab exercises with processing big data.

Data Modeling with Apache Cassandra

Data Modeling with Postgres

Python scripts to set up a multidimensional model and run an ETL process for Ethereum data analysis.