by Bjorn | Sep 29, 2023 | Data, Databases, Uncategorized
The importance of identifying and cleaning your dirty data TL;DR: Data cleaning, often overlooked, is the backbone of quality analytics. Dive into the significance of turning dirty data into clean, accurate, and duplicate-free information. Understand its impact on...
by Bjorn | Sep 11, 2023 | Data, Databases, Uncategorized
In the ever-evolving landscape of data management, two terms often pop up in conversations among data professionals: Data Warehouses and Data Reservoirs. But what are they, and how do they differ? Let’s dive deep into the world of data storage to find out....
by Bjorn | Jul 17, 2023 | Data, Databases, Uncategorized
The vast and dynamic realm of data management has seen a significant shift in methodologies with the advent of big data. At the heart of this transformation lies two key strategies — schema-on-read and schema-on-write. As a data professional, it is essential to have a...
by Bjorn | Mar 1, 2021 | Databases
When your daily life regularly has databases in it, then the chances are quite high that you’ve already heard the term quite a few times, data modeling. But what is it exactly? And why should you do it? What is data modeling? Data modeling is often considered a...
by Bjorn | Mar 20, 2019 | Databases, Uncategorized
What is database partitioning? Partitioning is dividing your tables and indexes into smaller pieces, and even subdivide it into even smaller pieces. Think of it as having several million different magazines of different topics and different years (say 2000-2019)...