ETL Data Warehouse pipeline using Pentaho Data Integration (Kettle) - Star Schema with dimensions and fact tables
-
Updated
Feb 22, 2026
#
dimensional-modelling
Here are 8 public repositories matching this topic...
Language: All
Filter by language
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
python sql eda saas data-warehouse data-engineering business-intelligence data-analytics dbt elt powerbi data-modeling customer-analytics churn-analysis kpi-dashboard analytics-engineering revenue-analytics snowflake-data-cloud dimensional-modelling snowlake
-
Updated
May 28, 2026 - Jupyter Notebook
Snowflake and dbt airline analytics engineering platform covering airport reference data, operations, bookings, billing, revenue recognition, reconciliation, and commercial reporting.
python sql snowflake data-engineering billing dbt data-quality github-actions airport-data ourairports analytics-engineering revenue-analytics revenue-recognition aviation-analytics airline-data airline-operations financial-reconciliation commercial-analytics dimensional-modelling airstats
-
Updated
Aug 28, 2026 - Python
Part 1: Building an enterprise-style Power BI semantic model using dimensional modeling and Star Schema principles.
sql etl data-transformation data-warehouse data-engineering business-intelligence data-analytics power-query dax powerbi data-modeling star-schema row-level-security fact-table data-modelling microsoft-power-bi dimensional-modeling semantic-model galaxy-schema dimensional-modelling
-
Updated
Jul 16, 2026
dbt + Snowflake project modeling raw Airbnb data into a dimensional warehouse with incremental loads, SCD2 snapshots, and custom tests
sql snowflake data-warehouse data-engineering dbt analytics-engineering dbt-core dimensional-modelling
-
Updated
Jun 27, 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
mysql sql etl data-warehouse data-engineering business-intelligence pentaho star-schema scd-type-2 dimensional-modelling
-
Updated
Apr 22, 2026
Employee wellbeing data warehouse — Snowflake star schema · SCD Type 2 · 1.4M+ rows · 16 tables
python sql-server snowflake data-warehouse star-schema scd-type-2 healthcare-analytics dimensional-modelling
-
Updated
Aug 5, 2026 - Python
A practical data modelling course repository covering conceptual, logical, physical, dimensional, and banking capstone data models.
sql postgresql data-warehouse data-engineering banking database-design data-modelling dimensional-modelling
-
Updated
Jun 24, 2026
Add this topic to your repo
To associate your repository with the dimensional-modelling topic, visit your repo's landing page and select "manage topics."