{"id":21800,"date":"2024-02-07T03:20:36","date_gmt":"2024-02-07T03:20:36","guid":{"rendered":"https:\/\/www.fditf.com\/bi\/?p=21800"},"modified":"2024-02-18T20:15:27","modified_gmt":"2024-02-18T20:15:27","slug":"developing-dbt-models-converting-business-logic-into-performant-sql-queries","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/","title":{"rendered":"Developing dbt Models: converting business logic into performant SQL queries"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In the realm of analytics engineering with dbt (data build tool), one of the most crucial skills is translating complex business logic into performant SQL queries. This ability ensures that data models not only accurately represent the business requirements but also execute efficiently within the data warehouse. Here&#8217;s a guide to achieving this with dbt models.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Understanding Business Logic<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Business logic encompasses the rules, calculations, and conditions that define business operations. In data modeling, it&#8217;s essential to grasp this logic to ensure the data accurately reflects the business&#8217;s needs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Optimizing SQL for Performance<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Writing performant SQL involves several best practices:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Use CTEs Wisely:<\/strong> Common Table Expressions (CTEs) can organize complex queries but use them judiciously as they can impact performance.<\/li>\n\n\n\n<li><strong>Aggregate Early:<\/strong> Perform aggregations as early as possible to reduce the amount of data processed in subsequent steps.<\/li>\n\n\n\n<li><strong>Indexing:<\/strong> Ensure that the underlying tables your dbt models depend on are properly indexed in the database.<\/li>\n\n\n\n<li><strong>Window Functions:<\/strong> Utilize window functions for efficient row-by-row operations over a partition of the dataset.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Example: Business Logic to SQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Consider a business rule that calculates a rolling average of sales over the past 30 days. Here&#8217;s how you might translate this into a performant SQL query within a dbt model:SELECT sale_date, AVG(sale_amount) OVER ( ORDER BY sale_date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW ) as rolling_30_day_avg FROM sales_data<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This example demonstrates how window functions can be used to efficiently implement complex business logic in SQL.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Key Takeaways<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Converting business logic into performant SQL queries within dbt models requires a deep understanding of both the business requirements and SQL optimization techniques. By applying these strategies, analytics engineers can ensure their dbt models are both accurate and efficient.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the realm of analytics engineering with dbt (data build tool), one of the most crucial skills is translating complex business logic into performant SQL queries. This ability ensures that data models not only accurately represent the business requirements but <a href=\"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":21826,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[252,262],"tags":[261],"class_list":["post-21800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dbt","category-dbt-certification","tag-dbt-certification"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Developing dbt Models: converting business logic into performant SQL queries - Business Intelligence MX<\/title>\n<meta name=\"description\" content=\"This article delves into the essential skill of translating complex business logic into performant SQL queries within the context of developing dbt (data build tool) models. It underscores the significance of understanding business operations to accurately reflect requirements in data models while emphasizing SQL optimization techniques. Key strategies include judicious use of Common Table Expressions (CTEs), early aggregation to minimize data processing, effective indexing, and the utilization of window functions for efficient computations. Through a practical example, it illustrates the application of these strategies in converting a business rule into a SQL query for a rolling average calculation. This guide aims to equip analytics engineers with the knowledge to ensure their dbt models are both reflective of business needs and optimized for performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transform Business Logic Into High-Performance SQL with dbt\" \/>\n<meta property=\"og:description\" content=\"Discover how to elevate your data models by converting complex business logic into efficient SQL queries using dbt. Our latest guide walks you through optimization techniques and practical examples to ensure your analytics projects are both accurate and high-performing. Perfect for analytics engineers seeking to refine their SQL skills.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-07T03:20:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-18T20:15:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2024\/02\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"Developing dbt Models: converting business logic into performant SQL queries\",\"datePublished\":\"2024-02-07T03:20:36+00:00\",\"dateModified\":\"2024-02-18T20:15:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/\"},\"wordCount\":301,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp\",\"keywords\":[\"dbt certification\"],\"articleSection\":[\"dbt\",\"dbt certification\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/\",\"name\":\"Developing dbt Models: converting business logic into performant SQL queries - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp\",\"datePublished\":\"2024-02-07T03:20:36+00:00\",\"dateModified\":\"2024-02-18T20:15:27+00:00\",\"description\":\"This article delves into the essential skill of translating complex business logic into performant SQL queries within the context of developing dbt (data build tool) models. It underscores the significance of understanding business operations to accurately reflect requirements in data models while emphasizing SQL optimization techniques. Key strategies include judicious use of Common Table Expressions (CTEs), early aggregation to minimize data processing, effective indexing, and the utilization of window functions for efficient computations. Through a practical example, it illustrates the application of these strategies in converting a business rule into a SQL query for a rolling average calculation. This guide aims to equip analytics engineers with the knowledge to ensure their dbt models are both reflective of business needs and optimized for performance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp\",\"width\":1024,\"height\":1024,\"caption\":\"Converting business logic into performant SQL queries\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/dbt-certification\\\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Developing dbt Models: converting business logic into performant SQL queries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Developing dbt Models: converting business logic into performant SQL queries - Business Intelligence MX","description":"This article delves into the essential skill of translating complex business logic into performant SQL queries within the context of developing dbt (data build tool) models. It underscores the significance of understanding business operations to accurately reflect requirements in data models while emphasizing SQL optimization techniques. Key strategies include judicious use of Common Table Expressions (CTEs), early aggregation to minimize data processing, effective indexing, and the utilization of window functions for efficient computations. Through a practical example, it illustrates the application of these strategies in converting a business rule into a SQL query for a rolling average calculation. This guide aims to equip analytics engineers with the knowledge to ensure their dbt models are both reflective of business needs and optimized for performance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/","og_locale":"en_US","og_type":"article","og_title":"Transform Business Logic Into High-Performance SQL with dbt","og_description":"Discover how to elevate your data models by converting complex business logic into efficient SQL queries using dbt. Our latest guide walks you through optimization techniques and practical examples to ensure your analytics projects are both accurate and high-performing. Perfect for analytics engineers seeking to refine their SQL skills.","og_url":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2024-02-07T03:20:36+00:00","article_modified_time":"2024-02-18T20:15:27+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2024\/02\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp","type":"image\/webp"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"Developing dbt Models: converting business logic into performant SQL queries","datePublished":"2024-02-07T03:20:36+00:00","dateModified":"2024-02-18T20:15:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/"},"wordCount":301,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2024\/02\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp","keywords":["dbt certification"],"articleSection":["dbt","dbt certification"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/","url":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/","name":"Developing dbt Models: converting business logic into performant SQL queries - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2024\/02\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp","datePublished":"2024-02-07T03:20:36+00:00","dateModified":"2024-02-18T20:15:27+00:00","description":"This article delves into the essential skill of translating complex business logic into performant SQL queries within the context of developing dbt (data build tool) models. It underscores the significance of understanding business operations to accurately reflect requirements in data models while emphasizing SQL optimization techniques. Key strategies include judicious use of Common Table Expressions (CTEs), early aggregation to minimize data processing, effective indexing, and the utilization of window functions for efficient computations. Through a practical example, it illustrates the application of these strategies in converting a business rule into a SQL query for a rolling average calculation. This guide aims to equip analytics engineers with the knowledge to ensure their dbt models are both reflective of business needs and optimized for performance.","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2024\/02\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2024\/02\/DALL\u00b7E-2024-02-06-21.25.01-A-refined-conceptual-illustration-focusing-on-a-single-robot-analytics-engineer-translating-complex-business-logic-into-performant-SQL-queries-for-dbt.webp","width":1024,"height":1024,"caption":"Converting business logic into performant SQL queries"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/dbt-certification\/developing-dbt-models-converting-business-logic-into-performant-sql-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"Developing dbt Models: converting business logic into performant SQL queries"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/21800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=21800"}],"version-history":[{"count":1,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/21800\/revisions"}],"predecessor-version":[{"id":21823,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/21800\/revisions\/21823"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/21826"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=21800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=21800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=21800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}