SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality is enhanced, with tabular models in particular becoming more capable and fully featured.

In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.

In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.