Today it feels like everything is moving to the cloud. Even large enterprise data warehouses that many people thought would never leave the on-premise data…
Blog,Data Warehousing
There are a lot of definitions of Master Data Management out there today. “Master data management (MDM) is a technology-enabled discipline in which business and…
This is the third and final blog a part of my deep dive series for dimensional modeling. Today, I will focus on Bridge Tables in…
In this blog post, a part of my deep dive series, I will focus on Degenerate Dimensions in this post. When introducing the concept of…
In my previous post about Slowly Changing Dimensions (SCDs), I provided you an overview of the four most common SCDs types and how they are…
In my previous post about the Cloud Data Hub / Data Science Architecture, I focused on the data lake. In this post, I will be…
In my previous post about the Cloud Data Hub / Data Science Architecture, I focused on the interface between the Operational Data Store (ODS) and…
Have you ever imagined a world where transactional systems were able to focus solely on the tasks they were built to complete? Have you ever…
Data warehouses and modern cloud architectures go together better than chocolate and peanut butter. The “abilities” (scalability, flexibility, reliability, etc.) of the cloud allows one…
Traditional data warehouses were often created as custom reporting data structures using on-site servers. These on-prem servers need to have a team of DBAs, storage…
In my previous Operational Data Store (ODS) blog, we discussed how to design an ODS. In this post, I will describe how to optimize the…
Operational Data Stores (ODS) are entity-centric and should only contain data about that specific entity. When designing an ODS, you will use relational database design…
An Operational Data Store (ODS) is a powerful tool to help provide any company or organization operational reports with up-to-date 360-degree views of any and…
The definition of an Operational Data Store (ODS) is a subject-oriented, integrated, volatile collection of current data designed to support the tactical decision-making of an…
The three keys to warehouse project success are to quickly, efficiently and consistently refresh the data in the warehouse. Here are four ways to design…
You often hear “drilling down” and “drilling across” from business intelligence professionals, but what does it mean and how do you, as a data modeler,…
I was recently tasked with loading a lot of historical json files into a database. I wanted to use KNIME to create a repeatable workflow…
I recently came across a situation where I needed to load a couple of table partitions. I wanted to automate this process and have a…
You will inevitably come across a time when a source system will allow the updating of transaction records. This drives data modelers, ETL developers, analytics…
In my last post I discussed late arriving facts, and although it is slightly annoying to receive delayed transaction data, the impact on the ETL…