End-to-end analytics pipeline for synthetic private markets data — SQL Server → dbt core → star schema → Power BI. Independent portfolio project.
-
Updated
May 11, 2026 - TSQL
End-to-end analytics pipeline for synthetic private markets data — SQL Server → dbt core → star schema → Power BI. Independent portfolio project.
A hand-built, end-to-end ETL pipeline that extracts the classic Northwind dataset from a local PostgreSQL source, stages it in Snowflake, and transforms it into a Kimball-style star schema (with one deliberate snowflake branch) — orchestrated with Prefect and validated automatically before it's trusted.
Power BI analytics portfolio showcasing end-to-end reporting projects, from data understanding and dimensional modeling to interactive dashboards and business insights.
A Databricks data engineering project simulating a full medallion architecture (Bronze → Silver → Gold) for e-commerce sales data, featuring incremental loading, a Kimball-style star schema, and SCD Type 1 & Type 2 implementations using PySpark and Delta Lake MERGE INTO.
Pipeline ETL de cotações financeiras com Pandas, Data Warehouse Star Schema no Supabase (PostgreSQL) e Airflow.
Revenue-weighted seller accountability for late delivery on a Brazilian marketplace, SQL Server, Power BI, dimensional modeling
Add a description, image, and links to the kimball-modeling topic page so that developers can more easily learn about it.
To associate your repository with the kimball-modeling topic, visit your repo's landing page and select "manage topics."