Data warehouses are moving to the cloud at an increasing pace. Each year the technology gets better and better and the costs become more affordable.…
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…
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 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…
Define and create a data layer. That was the task my team was handed a few weeks back, with minimal context. The client is a…
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…
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…