Skip to main content

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.

Getting Started with SQL Server Analysis Services

SSAS, 2012

Prepare to Install SQL Server 2012
What is SQL Server Analysis Services?
Install or Upgrade SQL Server 2012
Learn SQL Server Analysis Services:

SSAS, 2008 R2

Prepare to Install SQL Server 2008 R2
What is SQL Server Analysis Services?
Install or Upgrade SQL Server 2008 R2
Learn SQL Server Analysis Services:

SQL Server Analysis Services Highlights SQL Server Analysis Services Highlights RSS

SQL Server – Analysis Services Multidimensional Data (SSAS)

The Tabular AMO 2012 sample project is released!
The Tabular AMO 2012 sample project is released!
Tabular AMO 2012 involves creating and managing tabular models using the AMO API. It is a sample geared for developers who are interested in managing Analysis Services.
DAX in the BI Tabular Model Whitepaper and Samples
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
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
Sorting Dates Columns in PowerPivot v2 and BISM Tabular

SQL Server Analysis Services Resources

Additional Resources

Related Sites Forums Wiki 
Related Sites Forums Wiki 

 

In the Spotlight

Teo Lachev MVP (SQL Server), MCSD, MCT, is a developer, author, and mentor with a focus on Microsoft Business Intelligence. Through his company, Prologika (www.prologika.com), he helps organizations make sense of data by applying the latest Business Intelligence technologies for reporting, multi-dimensional analysis, and data mining.

Blog Space | Book