Category: analytics-engineering
-
Why Every Analytics Engineer Needs to Understand Data Architecture
Why Every Analytics Engineer Needs to Understand Data Architecture Get the data architecture right, and everything else becomes easier. I know it sounds simple, but in reality, little nuances in designing your data architecture may have costly implications. This article provides a crash course on the architectures that shape your daily decisions – from relational…
-
Data Analyst or Data Engineer or Analytics Engineer or BI Engineer ?
Data Analyst or Data Engineer or Analytics Engineer or BI Engineer ? If you’ve followed me for a while, you probably know I started my career as a QA engineer before transitioning into the world of data analytics. I didn’t go to school for it, didn’t have a mentor, and didn’t land in a formal training…
-
Optimize the dbt Doc Function with a CI
Optimize the dbt Doc Function with a CI How to set an automated check to improve your dbt documentation Image by the author (generated with chatgpt) In large dbt projects, maintaining consistent and up-to-date documentation can be a challenge. Although dbt’s {{ doc() }} function allows you to store and reuse descriptions for the columns of…
-
Measuring Cross-Product Adoption Using dbt_set_similarity
Measuring Cross-Product Adoption Using dbt_set_similarity Enhancing cross-product insights within dbt workflows Introduction For multi-product companies, one critical metric is often what is called “cross-product adoption”. (i.e. understanding how users engage with multiple offerings in a given product portfolio) One measure suggested to calculate cross-product or cross-feature usage in the popular book Hacking Growth [1] is…