data modeling

Multidimensional Data Modeling – OLAP Cubes

OLAP (short for Online Analytical Processing cubes) refers to multidimensional databases optimized for data warehouse requirements and specific OLAP applications. The OLAP cube is a technique of storing data (or…

Data warehousing concepts

Normalization and Denormalization – Differences through Use Cases

Introduction Today, the most common argument among data warehouse managers is determining which schema is more performance-oriented. However, it’s critical to know that neither of the normalization or denormalization approaches…

Which Data Integration Approach is Right for You?

An enterprise uses an average of 928 applications, along with many other on-premise systems. This means that you can have about a thousand source systems from different vendors, each storing…

Data warehouse vs marts vs lakes

Data Marts, Lakes, and Warehouses – Understanding the Differences

Too many buzzwords, too little understanding. With the ubiquity of data and analytics, IT vocabulary is expanding fast, and terms like data marts, data lakes and data warehouses are being…