O'Reilly logo

Building a Scalable Data Warehouse with Data Vault 2.0 by Michael Olschimke, Dan Linstedt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15

Multidimensional Database

Abstract

A key component of Microsoft SQL Server is the analytical database engine. The authors show how to build an OLAP cube to support multidimensional analysis based on the information mart, including the definition of measures and dimensions. They cover basic MDX and DAX querying on these cubes. The chapter demonstrates how to use Microsoft Excel to access the OLAP cube and perform simple calculations and adding charts to the cube. By doing so, they meet the goals of the book, to provide a complete end-to-end demonstration of building a scalable data warehouse using Data Vault 2.0.

Keywords

analytical database engine
OLAP cube
MDX
DAX
data vault
data
The previous chapters of this book have described how ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required