BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//SQLBits/com
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
DTSTART:20140718T150000Z
DTEND:20140718T160000Z
LOCATION:SQLBits Conference - Ironbridge 2
SUMMARY:Advanced Modeling with Analysis Services Tabular
DESCRIPTION: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.
X-ALT-DESC;FMTTYPE=text/html:

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.

Alberto Ferrari

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.