{"id":80130,"date":"2026-10-28T08:34:40","date_gmt":"2026-10-28T07:34:40","guid":{"rendered":"https:\/\/juvo.be\/?p=80130"},"modified":"2026-10-28T08:33:00","modified_gmt":"2026-10-28T07:33:00","slug":"semantic-layers-in-practice-snowflake-dbt-or-power-bi","status":"publish","type":"post","link":"https:\/\/juvo.be\/en\/semantic-layers-in-practice-snowflake-dbt-or-power-bi\/","title":{"rendered":"Semantic Layers in Practice: Snowflake, dbt, or Power BI?"},"content":{"rendered":"<p>Semantic layers are back on the agenda, and it\u2019s all about AI. If you want a language model to provide accurate answers about revenue, margin, or churn, you first need to define what those terms mean. But which approach should you choose?<\/p>\n<p>Joris Jonckers, Data Engineer at JUVO, compares the options based on his daily experience with Snowflake and dbt.<\/p>\n<p>1. What a semantic layer is, what it delivers, and what it costs<br \/>\n2. A comparison of Snowflake Semantic Views, dbt (MetricFlow and the dbt Semantic Layer), and the Power BI semantic model<br \/>\n3. Reference architectures for each option and how Tableau and Power BI fit in<br \/>\n4. AI on the semantic layer: Snowflake Cortex and Power BI Copilot, and what\u2019s needed for reliable answers<br \/>\n5. Pitfalls and Q&amp;A<\/p>\n<p>No sales pitch and no one-size-fits-all solution\u2014because there isn\u2019t one for every project. Instead, an honest assessment of where each option excels and where it falls short. The field is evolving rapidly, so consider this the state of affairs as of November 19 at 12:00 PM.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Semantic layers are back on the agenda, and it\u2019s all about AI. If you want a language model to provide accurate answers about revenue, margin, or churn, you first need to define what those terms mean. But which approach should you choose? Joris Jonckers, Data Engineer at JUVO, compares the options based on his daily [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":80132,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","content-type":"","footnotes":""},"categories":[75],"tags":[],"class_list":["post-80130","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-planned-webinars"],"acf":[],"_links":{"self":[{"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/posts\/80130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/comments?post=80130"}],"version-history":[{"count":2,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/posts\/80130\/revisions"}],"predecessor-version":[{"id":80135,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/posts\/80130\/revisions\/80135"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/media\/80132"}],"wp:attachment":[{"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/media?parent=80130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/categories?post=80130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/juvo.be\/en\/wp-json\/wp\/v2\/tags?post=80130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}