Excel Tutorial: What is Business Intelligence and an OLAP Cube? | ExcelCentral.com

This video lesson fully explains the concepts of Business Intelligence, OLAP, MDX and how they apply to Excel 2013.

The lesson begins with an explanation of OLAP and its purpose. You'll learn about OLAP Cubes and how they are divided into Dimensions, Measure and Hierarchies to create a multidimensional data structure. You'll also learn about how the MDX query language is used to extract values from OLAP cubes. This lesson also explains the concept of Business Intelligence and how it applies to OLAP.

This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills free video training course).

I’ve written a more up to date (and completely free) overview of OLAP that you can read on this link:

thesmartmethod.com/excel-power-pivot-2-minute-o…