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

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

DW de e-commerce (Kimball/Star Schema) em SQL Server, com scripts, dados sintéticos e docs para estudos.

Case Study - Retail Store - Kimball Data Warehouse

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.

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.

Production-ready dbt project for cancer screening analytics. Demonstrates dimensional modeling, healthcare metrics, and client-facing BI for Color Health Senior Analytics Engineer portfolio.

ELT Base: Transferência e Modelagem de Dados OLTP → OLAP

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

Evaluates Sephora's return policy using data warehousing principles.

This project perform an ELT solution to design a Data Warehouse in Snowflake

Data transformation project leveraging Snowflake, dbt, Airflow, and Astronomer to implement Kimball’s star schema for dimensional modeling of British Airways review data. Automates pipelines for transformation and orchestration, with CI/CD powered by GitHub Actions.

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

Cookiecutter template for a dimensional modeling project proposal

learning data, databases, distributed compute, orchestration and alot more Data Engineering concepts for fun.

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

My skills bridge the gap between OLTP and OLAP, combining advanced SQL development with rigorous Kimball dimensional modeling and SSIS ETL automation. Whether it's normalizing a relational database to 3NF or architecting a Star Schema for a data warehouse, I focus on data integrity, query performance, and actionable business intelligence.