Advanced Dimensional Modeling Techniques

Advanced Dimensional Modeling Techniques

Dimensional modeling is one of the key concepts in data warehouse design. In its essence, it is a collection of techniques used to structure database tables. The primary benefit of…

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 warehouse security

Best Practices for Ensuring Impenetrable Data Warehouse Security

In today’s world ‘data’ is the driving force behind any business. Storage of that data in a place where it’s secure from unauthorized access, be it physical or online, is…

Data warehouse and Business Intelligence

Data warehouse and Business Intelligence – Do Both Technologies Complement One Another?

If technicalities were to be put aside and the subject matter of this article was put in layman’s term, it would be “can the cookie cutter exist without the dough?”…