MDX vs. DAX: Currency Conversion Faceoff
Compare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Learn where multidimensional decorates the metadata of the model, while tabular offloads responsibility to DAX. Understand how the design goals of the DAX language – which are akin to Excel formulas and relational-database concepts – differ from MDX and traditional OLAP. Features covered can be used in a broad range of scenarios (not only currency conversion) adding valuable knowledge to your SSAS arsenal. Level: 400
Christian Wade, creator of the BISM Normalizer, has been doing BI and solution architecture since SQL Server 7. He spoke at the PASS Community Summit in 2012 and 2005, the 2005 European PASS Conference, and other events including SQLSaturday. Christian is from the UK, but lives in California.
Christian Wade is an independent consultant and senior solutions architect. He has led BI, data-warehousing and application-development projects since 1999. In his spare time, he created the BISM Normalizer for the SQL community, which is a free database-compare tool for Analysis Services tabular models. Christian holds a bachelor’s degree in operations research and business statistics.