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 virtual relationship (without physical relationship in the data model), dynamic warehouse evaluation without snapshot, dynamic currency conversion, number of events in a particular state for a given period, survey, and basket analysis. The goal is showing how to solve classical problems in an unconventional way.
Presented by Alberto Ferrari at SQLBits XII
  • Downloads
    Slide deck available Slide deck 7 MB
    Video available MP4 Video HD 554 MB
  • SpeakerBIO
    Alberto Ferrari is a Business Intelligence consultant. Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. He is a book author also, having worked on "Exper Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning with Marco Russo.
  • Video