---
title: "Discussion on \"Designing a SaaS Analytics Platform with dbt & DuckDB: A Kimball Dimensional Modeling Guide\" | Hashnode"
description: "Discussion on \"Designing a SaaS Analytics Platform with dbt & DuckDB: A Kimball Dimensional Modeling Guide\". How I'd architect a subscription analytics data warehouse from scratch: a step-by-step walkthrough"
url: "https://hashnode.com/posts/designing-a-saas-analytics-platform-with-dbt-duckdb-a-kimball-dimensional-modeling-guide/69c18d6630a9b81e3a93930a"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Designing a SaaS Analytics Platform with dbt & DuckDB: A Kimball Dimensional Modeling Guide](https://oorucelik.hashnode.dev/designing-a-saas-analytics-platform-with-dbt-duckdb-a-kimball-dimensional-modeling-guide?utm_source=hashnode&utm_medium=feed)

How I'd architect a subscription analytics data warehouse from scratch: a step-by-step walkthrough

Mar 23 · 13 min read · oorucelik.hashnode.dev  
Read the article

-   [#dbt](https://hashnode.com/tag/dbt)
-   [#duckdb](https://hashnode.com/tag/duckdb)
-   [#data-modeling](https://hashnode.com/tag/data-modeling)
-   [#data-engineering](https://hashnode.com/tag/data-engineering)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[Ömer Oruç ÇELİK](https://hashnode.com/@detail-pipelines)

@detail-pipelines · Istanbul, Turkey

  
[View profile](https://hashnode.com/@detail-pipelines)

BI Developer turned Data Engineer | Building pipelines that power decisions

Detail-oriented computer engineer with a self-taught mindset. After 4 years of SAP BI, settling back in my engineering chair. Throughout my career, I've built forecasting ETL and dashboards, designed countless reports and supported ETL systems for enterprise companies across the Middle East and Europe with DataIku, SAP Analytics Cloud, SDI(Smart Data Integrator) on SAP HANA. Now I'm focused on engineering with data platforms, building pipelines, modeling and visualizing datasets. So far I've worked with; PySpark, DAX, SQL, AWS, Microsoft Fabric and Power BI. I've always had the desire to share what I know but the problem was, not everyone around me are interested in what I'm about to teach them lol. So here we are, starting this blog for the people who would appreciate .I know I'll keep on growing, so why not share along the way with a community where we can grow together! Have a great harvest of knowledge!

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
