Level: Introductory to Intermediate
Microsoft SQL Server MVP
While OLAP has been around for many years, some developers/organizations shy away from OLAP, despite the benefits it could bring them. In this presentation, I'll present an OLAP example, how to build an SSAS (Analysis Services) database, and the benefits of OLAP. I'll also compare some of the capabilities in the Analysis Services OLAP model with the new Tabular Model in SQL Server 2012. I'm an instructor who has spent years demystifying OLAP in the classroom, and I'll do the same thing in this presentation.
You will learn:
- How an OLAP database can be created from a data mart or data warehouse, and how Analysis Services handles different types of fact/dimension relationships (both simple and complex)
- The power of MDX in extending OLAP databases
- The benefits to end users who consume an OLAP database