SQL Server Analysis Services

Microsoft's portal for SQL Server Analysis Services (SSAS). This site aggregates the best content we can find for SSAS including virtual labs, tutorials, videos, training, troubleshooting, how to, getting started, blogs, news, and more.

SSAS, 2012 What is SQL Server Analysis Services? Learning Center Resources What's New Product Overview Learn SQL Server Analysis Services: New to SSAS? Start Here Tutorials Documentation

SSAS, 2008 R2 What is SQL Server Analysis Services? Learning Center Resources What's New Product Overview Learn SQL Server Analysis Services: New to SSAS? Start Here Tutorials Documentation

SQL Server – Analysis Services Multidimensional Data (SSAS)

DAX in the BI Tabular Model Whitepaper and Samples This whitepaper and sample workbook introduce Data Analysis Expressions (DAX), a formula expression language used to define calculations in PowerPivot for Excel® workbooks and Analysis Services tabular model projects authored in SQL Server Data Tools... more

BISM – Tabular Security Model The tabular model uses role based security in the same manner as traditional SSAS. This post looks at the creation of roles and the use of restriction of data through (roles). In this example, the model is very simple only showing only sales by [ship... more

Sorting Dates Columns in PowerPivot v2 and BISM Tabular Sorting Dates Columns in PowerPivot v2 and BISM Tabular

Using Database Images in Tabular BI Semantic Models with Power View Now that the SQL Server 2012 RC0 release is out I wanted to do a follow up posting to my Using Images in Tabular BI Semantic Models with Crescent (now officially known as Power View). With this release there is now full support for using images stor... more