This course introduces the concept of data warehousing and data integration architecture and explains the role they play in overall business intelligence and analytics strategy of an organization. The course covers predominate architecture design strategies as well as hybrid designs that combine best practices from multiple areas. A key componen…

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

This repository contains a Data ware house solution for Property Analysis: A one-stop online platform for property investors, managers, owners, tenants and service providers.

In this project, we analyze the past criminal record data of Ireland generated by the Gardaí. We attempt to map this data with some key metrics such as population of different divisions, unemployment rates and depression levels to analyze the relation between crime types and criminal intense areas.

Case Study - Retail Store - Kimball Data Warehouse

Use Case of a Dimensional Data Warehouse built with dbt and BigQuery.

A sample project to demonstrate competence in Python, SQL and data modelling for sourcing, loading, transforming and querying data.

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

Implementing end-to-end data warehouse following Kimball's techniques using dbt

Analytics Engineering with dbt on Bigquery. This project implements the use of Analytics Engineering Best practices to build a dimensional data model, using dbt (data build tool) and BigQuery.