The harsh truth about the analytics industry is that “simple doesn’t sell”. It’s challenging to advocate for simplicity in data architecture because simple solutions often appear effortless, and who wants to invest in something that looks easy? While everyone claims…
Rule engines have the potential to streamline decision-making processes by separating business logic from the application code, allowing for greater flexibility and adaptability. However, despite these benefits, the adoption of rule engines often faces significant hurdles. In this article, I’ll…
I accidentally re-invented a Data Lakehouse. Over the last couple of months, I chipped away at my car price estimation tool whenever I could muster up some free time. I haven’t put much thought into the overall data architecture. This…
Goodbye, DBeaver! For the terminal lovers, have you checked out Harlequin? It’s a SQL IDE that you can easily install via pip and run right in your terminal. I’ve found it super user-friendly—really straightforward to install and use. Sure, it…
Overview: What is dbt and what can it do for your data pipeline? One tool that we recommend and often use is dbt (data build tool), which focuses on simplifying and accelerating the process of data transformation. In this blog,…
When people in analytics talk about data modelling, they usually dive right into the technical aspects. Into the pros and cons of data vault vs star schema modelling, for example. Providing a broad definition can provide some context to avoid getting stuck in the details.
Introduction In today’s data-driven world, businesses are constantly seeking ways to leverage the power of data for insights and decision-making. One popular approach is building a dashboard, a visual representation of key metrics and data points that provides a quick…
Data Build Tool (dbt) is a command line tool that helps data analysts and engineers transform, analyze, and visualize data in their warehouse. It is designed to work with popular warehouses such as Snowflake, Redshift, and BigQuery, and integrates with…
Most businesses today are data-driven, and to make sound decisions, they need access to accurate and timely data. However, setting up and maintaining a data warehouse can be costly and time-consuming. Apache Superset is an open-source tool that makes it…
Apache Superset is an open-source data visualization and dashboarding tool that is designed to be easy to use, yet powerful and flexible. It was developed at Airbnb and is now a top-level Apache project. One of the main benefits of…