Using dbt to Streamline Cross-sell Leads in Consumer Banking + Case Study

As a data professional in the consumer banking sector, you are constantly faced with the challenge of managing and transforming large amounts of data. Streamlining this process can significantly enhance your productivity and the effectiveness of your outcomes. One tool that is proving to be quite instrumental in this regard is the data build tool, […]
dbt Incremental part 1: Choosing the Right Strategy

Incremental Strategies & When to Use Them Incremental materialization is an advanced and powerful feature of dbt; however, you don’t need to use it in every single model of your project. Understanding when and how to leverage incremental materialization can be a game-changer for your data workflows. In this blog post, I’ll delve into the […]
Why is Data Lineage Critical for a Data Team?

A recurring problem that I see is that data teams are often unaware of how critical data lineage is — not just from maintenance point of view — but from cost optimization perspective as well — to put things into the economic context. In this post, lets discuss data lineage. What it is, why is it critical, look at some proof, […]
Enabling data culture in organizations with purposeful documentation

Documentation is so often taken rather lightly or not always on top of projects’ priorities especially when it comes to tight deadlines to follow. The rooting reason for this problem is how the management team is initially viewing and handling data as assets, leading to an insufficiency of purposeful documentation in the development phase, and the availability of suitable tools to navigate to understand their current data in the launching phase. What could have been done better?
Data Modeling and Why It’s Important

Data transforms global processes, from disease research to revenue strategies, construction, and social media ads. Machine-readable data requires context; e.g., customer data needs to correspond to product purchases or price points. Data Modeling assigns relational rules, simplifying data for strategic decision-making. What is Data Modeling? Data modeling is a process of creating a visual representation […]
VPN vs SSH tunnel and why do companies use them?

When you are an outsource company and you’re working with clients, if they have a database data source, you are most likely to connect to it through a VPN or through an SSH tunnel. Have you ever wondered: why all this shenanigans? Why not just give me an IP or a URL and I can […]
BROOKLINEN, Inc. Growing Data Team

Location: New York, United States Industry: Bedding products, Lifestyle & health Founded: 2014 Website: https://www.brooklinen.com/pages/about Having Brooklinen as a customer and a partner over the past year was Joon’s honor. At the time when we first started working with Brooklinen, the team was in need of data reporting for sales. But as the team was […]
Data Observability with Elementary

1. What is Data Observability? Data observability is the ability to observe data and data-related jobs in your data system. This will help you monitor your data pipelines, understand whether the system is operational, where the data are coming from and flowing into, which transformations are fast, which jobs are resource-consuming, where the data errors […]
Coalesce dbt Gold Award – Collective reflections from Joon’s Leadership Team

Coalesce has come and gone and with it there were a lot of fantastic surprises and developments that we want to share. Starting with us, Joon Solutions, being awarded the dbt Gold certification award. There were only 12 companies featured for a certification award and we are super proud to be one of them. Our […]