The origins, use and evolution of OLAP software over the last 25 years. This is a personal view (not a history lesson) from an experienced BI practitioner who has used a variety of OLAP software, such as, SQL Server Analysis Services since graduating in 1985.
The heart of this session will be an end-to-end technical demo that will show the role of MDS in extracting master data from source systems, before demonstrating how data is fed via MDS to subscribing downstream systems. Whilst the focus of the session will be on MDS, other parts of the Microsoft BI stack will be shown, in order to demonstrate how a Microsoft MDM solution complements existing parts of SQL Server.
This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it
The Microsoft SQL Server provides a complete library of programmatically accessed objects for all Business Intelligence relevant services. With this set of functions almost any customer challenge can be solved without the need to purchase additional products. This possibility is often underestimated in projects. The session will explain the hidden power of using the Microsoft APIs to build BI middleware solutions for enterprise customers.