Posts
All the articles I've posted.
-
Splitting Strings in Excel: A Simple Guide
When working with Excel, you may encounter situations where you need to split a string into separate parts. For example, consider the following string: orderId: 12345abc-de67-89fg-hijk-123456lmnop If
-
Handling Schema Changes in a Data Warehouse
When building and maintaining a Data Warehouse (DWH) , handling schema changes without breaking existing processes is a crucial challenge for data engineers. As new requirements emerge, we often need
-
Understanding How Hive Converts SQL Queries into Hadoop Jobs
When you execute a SQL query in Apache Hive, the query is not directly run on a traditional database. Instead, Hive translates it into a Hadoop job, which is then executed across a distributed system.
-
Delta Lake vs. Traditional Data Lakes: Key Differences and Vendor Options
Introduction As data-driven organizations scale their analytics and machine learning workloads, the limitations of traditional data lakes become more apparent. Delta Lake is an open-source storage
-
Why OLTP Systems Don't Retain Historical Changes
Online Transaction Processing (OLTP) systems are designed for high-speed transactions and efficient data management. However, one of their characteristics is that they do not retain historical changes
-
Understanding Slowly Changing Dimensions (SCD) in Data Warehousing
When dealing with data warehouses, handling changes in dimension data over time is crucial. Unlike operational databases where updates are straightforward, data warehouses require preserving
-
Modes and Examples of KPIs in Data Analysis Expressions (DAX)
Last Year Comparison When analyzing sales performance, it is often useful to compare the current year's sales with the same period in the previous year. To do this, we create several calculated
-
Understanding Surrogate Keys in Databases
When designing relational databases, one crucial decision is how to uniquely identify each record in a table. This is where surrogate keys come into play. Unlike natural keys, which derive from