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-overview/
- Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence. ( Download)
- OLAP 101: What It Is And How To Apply It To Your Marketing ( Download)
- Excel CUBE Functions can do everything a PivotTable does and more! ( Download)
- Beginner's guide to OLAP modeling: Cubes ( Download)
- Excel Expert Lesson 6-1: Understand primary and foreign keys ( Download)
- Understand OLAP, MDX and Business Intelligence in excel | USING THE CUBE FUNCTION | ( Download)
- What is OLAP ( Download)
- OLAP vs OLTP ( Download)
- Learn MDX Fundamentals ( Download)
- Business Intelligence: Multidimensional Analysis ( Download)
- Forecasting using Regression Analysis in Microsoft OLAP Cubes ( Download)
- OLAP Cartoons, Business Intelligence, Dimensions, Measures, OLAP ( Download)
- Structure of MultiDimensional Cube and How MDX Queries fetch data from the cube SSAS mp4 ( Download)
- Understanding Business Intelligence ( Download)
- Excel Expert Lesson 6 5 Manually Grouping & Ungrouping Data ( Download)
