Is Kimball Data Modelling Dying?
Over the past few decades, the subject area of data warehousing has seen a fair share of changes. Among the most popular approaches is...
Adding Animated Images to Reports in Power BI
Animated images, such as GIFs, can add an extra layer of engagement and interactivity to your Power BI reports. However, their use should be...
Introduction to Streamlit: Building Data Apps using Python
Streamlit has quickly become a favorite tool among data professionals, and for good reason. It lets you create interactive, user-friendly (and really good looking,...
Introduction to Pandas DataFrames in Python
Pandas are one of the most powerful and flexible libraries in Python for data analysis and manipulation. I would dare to say it’s an...
Rethinking Data Architecture: The Promise of Data Mesh
It’s not every day that you stumble upon a book that completely shifts your perspective on your day-to-day work. That’s exactly what happened when...
Partitioning Tables in BigQuery
If you are analyzing relatively small amounts of data, then your queries won’t cost very much, but if you regularly analyze huge datasets, then...
Mastering and Understanding the Join Function in SQL
Joins are one of the most frequently used functions in SQL, and that is for good reason. They play an important role in relational...
Generating Dates Between Two Dates in BigQuery
Generating a list of dates between two dates can be very helpful in many situations. Many source systems typically provide you with a start...
Medallion Architecture in Modern Data Platforms
If you’ve explored or worked with modern data management strategies, you’ve likely encountered terms like data lake, data warehouse, and the increasingly popular concept...
Incremental Load of Delta Records Using Dataform in BigQuery
When working with large datasets in data pipelines, processing every record repeatedly can be inefficient. A common approach to optimize this process is to...