Session Details

SSAS 2012 Tips and Tricks  

Level :
Intermediate
Date :
10:45 AM Sunday
Room :
PSEC4502
Track :
Microsoft Business Intell...
Interested : (-) - Registered : (-)
Tag(s) :

Presentation

Compare and contrast how multidimensional and tabular models achieve the same result in quite different ways. You’ll learn where multidimensional decorates the metadata of the model, while tabular offloads responsibility to DAX. You will also see how the design goals of the DAX language – which are akin to Excel formulas and relational-database concepts – differ from MDX and traditional OLAP. In addition, the session discusses the benefits of database compare for SSAS tabular models. Many of the code samples are for currency conversion, but techniques can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal. The demo content also covers BISM Normalizer, which is a free tool developed by the SQL community for the SQL community.

The Speakers

img

Christian Wade

Christian Wade, creator of the BISM Normalizer, has been doing BI and solution architecture since SQL Server 7.0. He speaks at the PASS Community Summit, SQLBits, SQL Saturday and other events.
  • Not Interested
  • Interested
  • Attending

SPONSORS List