A data professional experienced in the modern data stack and analytics engineering.
March 6, 2024 My updates for this week Choosing the right data catalog for your organization This week I cover how to navigate the complexities of selecting a data catalog tailored to your organization's needs, with insights on key considerations, best practices, and implementation success metrics. Read story Unsubscribe · Preferences
February 21, 2024 My updates for this week Master dbt and leverage variables Learn how to set variables within your dbt project! By using Jinja templating syntax, you can define and reference variables within your SQL code, offering more flexibility in your data transformations. Check out the latest blog post for a guide on mastering dbt variables in order to enhance your development. Read story Unsubscribe · Preferences
February 15, 2024 My updates for this week *Admittedly, that poster above should say Happy belated Valentine's Day! I pushed ChatGPT so hard to produce this poem that I decided to send it regardless of the tardiness :) Managing multi-project architecture with dbt-meshify This week's post dives into the simplicity of dbt-meshify and the cross project references for managing multi-project architecture. It provides a walkthrough of a workaround for those who have not instrumented dbt-meshify and...
February 7, 2024 My updates for this week Advanced insights into dbt source freshness testing Last week's post discussed the basic principles behind testing our source data for freshness and received great feedback. Therefore, this week, I decided to delve deeper and discuss the important use cases for instrumenting a method to build models based on their freshness. Read story Unsubscribe · Preferences
January 31, 2024 My updates for this week What you need to know about dbt source freshness testing When we enable source freshness tests, we are asking “how fresh is our data?” This weeks blog discusses the functionality behind source freshness testing and the benefits of adding these tests to your project when managing visibility on large datasets is a high impact objective for your organization. Read story Unsubscribe · Preferences
January 17, 2024 My updates for this week Part 2: Navigating the landscape of dimensional modelling We're closing out the two-part series with Sr. Analytics Engineer Ben Labenski at theScore by delving deep into the intricacies of dimensional modelling, uncovering tangible insights essential for optimizing and refining your data architecture. We hope you find this useful! Note: Part 2 will be building upon the principles and foundations laid in Part 1. Read story Unsubscribe · Preferences
January 10, 2024 My updates for this week Part 1: An introduction to dimensional modelling I've teamed up with Sr. Analytics Engineer Ben Labenski at theScore the next two weeks to explore various dimensional modelling principles that can be used to unlock valuable insights in your data warehouse. This two-part series will dive into key strategies, best practices, and innovative techniques to elevate your data modelling understanding and capabilities. We hope this is a topic you enjoy! Read...
January 3, 2024 My updates for this week Why did the SQL query break up with 2023? Because it couldn't handle the NULL promises! - Nothing says happy new year like a good ol' SQL joke generated by AI A comprehensive guide to managing data quality with dbt tests This week's post focuses on harnessing the power of dbt tests to ensure accuracy and reliability in your analytics pipeline. Discover best practices, implementation tips, and the transformative impact of incorporating dbt tests into...
December 20, 2023 My updates for this week A sincere thank you to each and every one of you who have subscribed this year, been active readers and who have reached out on Medium or LinkedIn. Thank you to all who have inspired me, taught me and helped me get here. This newsletter has become such a great way for me to connect and learn from each one of you, in addition to developing my skills as a writer and an engineer. Happy Holidays to you and yours. Striking the right balance between...
December 13, 2023 My updates for this week Streamline your data career with these essential git commands Git doesn't have to be a mystery. Get acquainted with these ten high priority commands to increase your comfort levels and velocity in the command line. Mastering these essential Git commands will not only demystify version control but also enhance your overall workflow.By incorporating these commands into your routine, you'll gain the confidence to efficiently manage branches, collaborate...