SQL Server Analysis Services (SSAS)

SQL Server Analysis Services contains engines for multidimensional (OLAP) and tabular analytical models, and for data mining.

Reference materials:

1. MSDN. Introducing the BI Semantic Model in Microsoft® SQL Server® 2012
2. MSDN. Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
3. MSDN. Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
4. MSDN. Securing the Tabular BI Semantic Model
5. MSDN. Using DirectQuery in the Tabular BI Semantic Model

Reference materials on multidimensional modeling (OLAP):

• REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter
• Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
• Scale-Out Querying with Analysis Services
• Scale-Out Querying with Analysis Services Using SAN Snapshots
• The Analysis Services 2008 Performance Guide
• Analysis Services 2005 Performance Guide
• Analysis Services Distinct Count Optimization
• Analysis Services Processing Best Practices
• Analysis Services ROLAP for SQL Server Data Warehouses
• Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
• OLAP Design Best Practices for Analysis Services 2005
• Precision Considerations for Analysis Services Users
• Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
• Scale-Out Querying for Analysis Services with Read-Only Databases
• SQL Server 2008R2 Analysis Services Operations Guide
• Analysis Services 2008 R2 Performance Guide
• Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014

Reference materials on tabular modeling:

• 5 Tips to Ensure Super Fast SSAS Tabular Models
• Getting Started with Row Level Security
• Implement Dynamic Security by Using Row Filters
• Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services