DW de e-commerce (Kimball/Star Schema) em SQL Server, com scripts, dados sintéticos e docs para estudos.
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.
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.
Use Case of a Dimensional Data Warehouse built with dbt and BigQuery.
Enterprise data warehouse on GCP Free Tier — Medallion Architecture, Kimball Star Schema, event-driven ingestion, Airflow orchestration, Terraform IaC, K8s observability stack
Production-ready dbt project for cancer screening analytics. Demonstrates dimensional modeling, healthcare metrics, and client-facing BI for Color Health Senior Analytics Engineer portfolio.
Evaluates Sephora's return policy using data warehousing principles.
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.
This project perform an ELT solution to design a Data Warehouse in Snowflake
End‑to‑end analytics engineering project using dbt, DuckDB, and both relational and NoSQL sources
A complete data integration solution that migrates data from multiple source systems into a modern data warehouse, with full documentation, quality validation, and analytical reporting.
End‑to‑end Russell 3000 market data pipeline: Polygon → Snowflake → dbt → Streamlit. Daily U.S. equities analytics pipeline with Airflow, Snowflake, dbt, Streamlit. Market data ELT stack for Russell 3000 signals, marts, and dashboards.
Add a description, image, and links to the kimball topic page so that developers can more easily learn about it.
To associate your repository with the kimball topic, visit your repo's landing page and select "manage topics."