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:

Featured SQL Server Analysis Services 'How Do I' Video

Security Context of PowerPivot Connections in a Farm

Security Context of PowerPivot Connections in a Farm

More Videos >

SQL Server Analysis Services Highlights SQL Server Analysis Services Highlights RSS

SQL Server – Analysis Services Multidimensional Data (SSAS)

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
Using Database Images in Tabular BI Semantic Models with Power View
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

Additional 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

Team and Community BlogsTeam and Community Blogs OPML Button

SQL Server – Analysis Services Multidimensional Data (SSAS)

Identifying Top MDX Queries running in SSAS environment
Thursday, May 24 webadmin@ssas-info.com (Parikshit Savjani)
Percentile Measures in DAX - Errata
Thursday, May 24 webadmin@ssas-info.com (Colin Banfield)
Deployment Options for BISM Project
Thursday, May 24 webadmin@ssas-info.com (Fendy Huang)
Microsoft BI VHD XII – SQL 2012
Wednesday, May 23 denglishbi
Row security and hierarchies-part 1
Monday, May 21 webadmin@ssas-info.com (Cathy Dumas)
Binding Excel to a custom MDX query supporting PivotTable filters
Monday, May 21 webadmin@ssas-info.com (Christian Wade)
Consolidation and Intercompany Elimination made easy using PowerPivot and DAX
Monday, May 21 webadmin@ssas-info.com (Gerhard Brueckl)
SCOPING at different granularities (Part III)
Monday, May 21 webadmin@ssas-info.com (Javier Guillen)