Enterprise data warehouse for ICE Entertainment — 5-layer architecture with MySQL star schema, Pentaho ETL pipelines, multi-currency USD conversion, and SCD Type 2 across 500 stores and 10 countries
-
Updated
Apr 22, 2026
Enterprise data warehouse for ICE Entertainment — 5-layer architecture with MySQL star schema, Pentaho ETL pipelines, multi-currency USD conversion, and SCD Type 2 across 500 stores and 10 countries
dbt + Snowflake project modeling raw Airbnb data into a dimensional warehouse with incremental loads, SCD2 snapshots, and custom tests
Snowflake and dbt airline analytics engineering platform covering airport reference data, operations, bookings, billing, revenue recognition, reconciliation, and commercial reporting.
Part 1: Building an enterprise-style Power BI semantic model using dimensional modeling and Star Schema principles.
End-to-End SaaS Analytics Engineering Pipeline built using Snowflake, dbt, SQL, Python, Power BI. Features Dimensional Data Modeling, Automated Transformations, KPI Reporting Layers, Data Quality Testing, dbt Lineage Documentation, and Interactive Business Intelligence Dashboards for Revenue, Churn, Customer Health, Engagement & Retention Analytics
ETL Data Warehouse pipeline using Pentaho Data Integration (Kettle) - Star Schema with dimensions and fact tables
Employee wellbeing data warehouse — Snowflake star schema · SCD Type 2 · 1.4M+ rows · 16 tables
A practical data modelling course repository covering conceptual, logical, physical, dimensional, and banking capstone data models.
Add a description, image, and links to the dimensional-modelling topic page so that developers can more easily learn about it.
To associate your repository with the dimensional-modelling topic, visit your repo's landing page and select "manage topics."