End-to-end ELT batch pipeline | Medallion Architecture (Bronze → Silver → Gold) | dbt + Snowflake + AWS S3 + Apache Airflow + Docker | 3.5M+ records
End-to-end streaming data platform on AWS: Kafka → Iceberg lake → Kimball model → Athena, orchestrated with Airflow 3. Terraform, Glue PySpark, dbt.
DW de e-commerce (Kimball/Star Schema) em SQL Server, com scripts, dados sintéticos e docs para estudos.
Visual ERD designer for dbt — design your data warehouse on a canvas, in your repo, where your AI assistant can read it. Free and open source.
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…
Data Warehouse dimensional populado com dados da API do Observatório de Saúde Global (GHO) da OMS.
Fortune-500-grade banking analytics platform: OLTP -> medallion lakehouse -> Kimball star schema -> semantic layer -> 9-tab executive dashboard + 5 ML models (churn, fraud, segmentation, forecasting). Production-ready, governed, fully tested.
🏢 Decision support system with a star-constellation Data Warehouse integrating PostgreSQL, CSV, and MongoDB sources, NLP-based sentiment analysis (VADER/NRClex), and Metabase dashboards for a tech retail company.
assignments and projects for Yeshiva University's Katz School Information Architectures course, spring 2020
End-to-end supply chain analytics: medallion lakehouse → Kimball star schema → Power BI dashboard with 101 DAX measures → executive briefing. Reframed leadership conversation from "stockouts" to "overstock recovery".
Source code for the Kimball-style date dimension generator dimdates.com.
Power BI pharmacy analytics: star schema + 25 DAX measures surfacing revenue concentration, stockout & expiry risk.
Enterprise data warehouse on GCP Free Tier — Medallion Architecture, Kimball Star Schema, event-driven ingestion, Airflow orchestration, Terraform IaC, K8s observability stack
Dual-target dbt + DuckDB/Snowflake ELT pipeline: Kimball star schema, Airflow/Cosmos orchestration, CI with lint/build/test/security gates
Designed and implemented an ETL pipeline using SQL Server Integration Services (SSIS) to build a Northwind Data Warehouse with dimensional modeling and fact/dimension tables.
Azure-native healthcare analytics platform ingesting CMS Medicare and openFDA drug safety data via ADF into ADLS Gen2, loading into Snowflake, transforming with dbt into star schema, validating with Great Expectations, orchestrating with Airflow, and delivering insights through Power BI dashboards.
Complete materials for "Data Warehousing and Modeling" uni course: lectures (Inmon, Kimball, Dimensional Modeling, NoSQL), PostgreSQL labs (Star Schema), exam questions, and practical SQL solutions.
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."