Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.
In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.
This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.
Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Compare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Features covered can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
PowerPivot is a breakthrough for self-serve BI but is not easily deployed in the enterprise. Join us for this fast-paced, technical demonstration on how to upgrade PowerPivot into secure and scalable Analysis Services tabular cubes