Advanced Modeling with Analysis Services Tabular



This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional. You will see several practical examples, including creating a virtual relationship (without a physical relationship in the data model); a dynamic warehouse evaluation without a snapshot; dynamic currency conversion; a number of events in a particular state for a given period; surveys; and basket analysis. The goal of this session is to show you how to solve classical problems in an unconventional way.



Enclose code in comments with <PRE></PRE> to preserve indentation.